[solved]-Given Following Relational Database Tables Customer Orders Items Visually Identify Custome Q39074661
Given the following relational database tables (Customer, Orders, and Items), can you visually identify customer(s) who ordered “milk” or “soda” and paid by “cash“? Please explain your reasoning or approach to the problem and what would be the output (select one option below). You can just explain your output based on selected option but also feel free to show your SQL statement (optional). If choose to explain your solution using simple SQL statements/commands, please explain what your SQL is doing. Customer Table CustomerID Items table OrderID ItemID CustomerName William Smith Natalie Lopez Brenda Harper Adam Petrie Items Hamburger Milk soda Orders table OrderID CustomerID Amount 122.25 11.75 5.00 9.33 10.11 Order Type Cash Credit Other Other Credit 1) Which of the following output would be the correct answer to the problem? a. William Smith, Nathalie Lopez b. Brenda Harper, Adam Petrie c. Nathalie Lopez d. William Smith e. None 2) Please list all the Primary Keys and Foreign Keys for each table. 3) What normal rule violated by the Customer Table and how would you normalize the Customer Table? 4. What is the relationship between a primary key and a candidate key? 5. In your own words, how you would restate the difference between entity integrity constraint and referential integrity constraint? Show transcribed image text Given the following relational database tables (Customer, Orders, and Items), can you visually identify customer(s) who ordered “milk” or “soda” and paid by “cash“? Please explain your reasoning or approach to the problem and what would be the output (select one option below). You can just explain your output based on selected option but also feel free to show your SQL statement (optional). If choose to explain your solution using simple SQL statements/commands, please explain what your SQL is doing. Customer Table CustomerID Items table OrderID ItemID CustomerName William Smith Natalie Lopez Brenda Harper Adam Petrie Items Hamburger Milk soda Orders table OrderID CustomerID Amount 122.25 11.75 5.00 9.33 10.11 Order Type Cash Credit Other Other Credit 1) Which of the following output would be the correct answer to the problem? a. William Smith, Nathalie Lopez b. Brenda Harper, Adam Petrie c. Nathalie Lopez d. William Smith e. None 2) Please list all the Primary Keys and Foreign Keys for each table. 3) What normal rule violated by the Customer Table and how would you normalize the Customer Table? 4. What is the relationship between a primary key and a candidate key? 5. In your own words, how you would restate the difference between entity integrity constraint and referential integrity constraint?
Expert Answer
Answer to Given the following relational database tables (Customer, Orders, and Items), can you visually identify customer(s) who … . . .
OR
