Week 7 Designing A Database

Week 7 Designing a Database

Using the attached Database Diagram, answer the following questions!

1)  Identify the Primary Key in each table in the diagram.   List the Primary key in each table and describe why you think this field was selected to be the primary key.

2) The Orderline and BookAuthor tables have multiple primary keys, why is this the case?  What do we call this type of table?

3)  What would the Select statement look like if I needed all the orders for customerID 99999?

4)  What would the Select statement look like if I needed all the customers that live in zip code 34583?