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.
