70.2K

Verified Solution

Link Copied!

2 Given a table used by a gallery to keep track all transactions customer buy and sell artists works from to the gallery Assuming the given data shows all possible FDs artisti artistName 1 1 2 3 3 3 4 5 John John Roman Shaw Shaw Shaw Peter Kim Artwork ArtworkID Transation Price Title Type Buy from A Boy A Boy Farmers A face XYZ No title No title No title 1 1 2 3 4 5 6 7 Sell to Buy from Buy from Sell to Sell to Buy from Sell to 600 700 100 100 200 200 240 220 Customer Customer Customer Trans Agent Number Name Location Date name 1 2 20 Smith 1 5 21 Mary 1 2 20 Mary 1 2 20 Mary 1 2 20 Smith 2 1 20 Smith 1 e Describe one modification anomaly this table has 2 2 3 1 3 4 4 Stacy Chen Chen Joy Stacy Joy Joy Joy LA LA LA NY LA NY NY NY 2 1 21 Joe 2 1 21 Smith Note each artist has an agent who handles the transactions of his her art pieces But artist may change their agent periodically Customers can buy sell a piece of art from to the gallery a Carefelly 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 combineatoin of attributes can provide the value to uniquely identify a transaction 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 f Normalize above table In the normalization result you must show the table name and the key and FK if there is

Answer & Explanation Solved by verified expert

See Answer