1. Based on the dependency diagram above, create a database whose tables are at least in 2NF, showing the dependency diagram for each table.

2. Based on the dependency diagram above, create a database whose tables are at least in 3NF, showing the dependency diagram for each table.

3. What is a partial dependency? Give an example.

4. A co-worker reviews a database design youve been working on . In it, they notice that you include the following in your customer entity:

a. Customer Name (Frist, Middle Initial Last)

b. Customer Address i. Street address ii. City iii. State iv. Zip

c. . Your co-worker argues that having the City is unnecessary duplication of data, as if you know the zip code, the city can be determined. They also argue that your design violates 3NF (because of the inclusion of both City and Zip). In addition to your desire to tell him to , you also want to answer the specific questions. Namely, does this design violate 3NF, and if so why? If it does violate 3NF, what would it look like (in terms of Entities, Attributions, and Relationships) of the model that doesnt violate 3NF. Finally, if it does violate 3NF, what would your rationale be to keep it as is?

ISBN BookTitle Author Num LastName Publisher Royalty Edition