Posted: December 8th, 2015

What fields do you need to capture information about the clients who are donating computing equipment? What would be the primary key of the “Client” table? Why would that be a good primary key?

A group of students at your school wants to collect a nd refurbish used computer equipment and donate it to underprivileged individuals. To help this group, you want to create a database to facilitate the tracking of the donated equipment.

Based on the scenario, write a 2 page APA style essay answering the following questions:

What fields do you need to capture information about the clients who are donating computing equipment? What would be the primary key of the “Client” table? Why would that be a good primary key?
What fields do you need in your database for identifying and categorizing the computer equipment? What would be a good primary key to uyse for the “Computer Inventory” table? Why would that be a good primary key?
Design a table that tracks the donation transactions. What fields from the other two tables would need to be included in the “donation transactions” table? Justify your answer to your choices.