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?
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
