Question: gallery) Assuming the given data shows all possible FDs.) Note: each artist has an agent who handles the transactions of his/her art pieces. But artist

 gallery) Assuming the given data shows all possible FDs.) Note: eachartist has an agent who handles the transactions of his/her art pieces.

gallery) Assuming the given data shows all possible FDs.) Note: each artist has an agent who handles the transactions of his/her art pieces. But artist may change their agent seriodically. Customers can buy/sell a piece of art from/to the gallery. Type your answer a. Carefully exam the data shown in this table to list all FDs. b. If you want to create above table in a database, what is the primary KEY for this table? Namely, what combination of attributes can provide the value to uniquely identify a transaction record. Note this table is very bad design. c. What normal form this table is in? Why? d. How many "themes" (i.e., pieces of information) that are implied by above table? State each "theme". e. Describe one modification anomaly this table has. f. Normalize above table. In the normalization result you must show the table name and the key, and FK if there any

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!