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: 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
Get step-by-step solutions from verified subject matter experts
