Lab 2 Database Design Part 1 Use the database shown below to work Problems 1 through 7. Note that the database is composed of four tables and reflects these relationships: A CUSTOMER has only one customer#, but a customer can place any number of orders. A BOOK has only one isbn, but can be order as many times as the customer wants. Note also that the M:N relationship has been broken down into two 1:M relationships for which the ORDERITEMS table serves as the composite or bridge entity. 1. Evaluate if the book "HOW TO MANAGE THE MANAGER' will be entered in to BOOKS table without an error explain why or why not? ISBN 9247381001 Title HOW TO MANAGE THE MANAGER Pubdate 09-MAY-03 Pubid 1 Cost 15.4 Retail 31.95 Category BUSINESS Contents of BOOKS table Title ISBN Pubdate Pubid Cost Retail Category 2. Also evaluate the rows shown under ORDERS & ORDERITEMS tables if they will be entered in the respective tables without error, explain why or why not? Orders table: Order Customer # 1019 Shirstat Shirzi Shircos. t 07960 2 1010 NJ arderdat shindat shiraddce Shirsity 55 03-APR- 04-APR- 384 MORRISTOW 09 09 WRONG N WAY HOME Contents of ORDERS Table Order # Customer # giderdat sbirdat Shiraddress Shircity Shiestatshirzi Shirces. t 3. Also evaluate the rows shown under ORDERITEMS tables if they will be entered in the respective tables without error, explain why or why not? Orderitems table: ISBN Order 1005 1009 Item# 1 1 1059831198 3437212490 Quantity 1 1 Paideach 39.95 19.95 Contents of ORDERITEMS table Quantity 1 1 1 Order# 1000 1001 1001 1002 1003 1003 1003 1004 Item# 1 1 2 1 1 2 3 1 ISBN 0401140733 4981341710 8843172113 1059831198 0401140733 4981341710 BB43172113 2491748320 Z 1 1 Paideach 19.95 31.95 85.45 55.95 55.95 30.95 19.95 85.45 1 Z 4. Evaluate if customer# 1006 AND 1004 will be entered in CUSTOMERS table without an error, explain why or why not? Customer Lastnams. Firstname Address City State Zip Region 1006 CRUZ MESHIA BZ DIRT ROAD ALBANY NY 12211 NE 1004 MOLINA JENNIFER P.O. BOX 754 ORLANDO FL 32306 Contents of CUSTOMERS table Customer 1001 1002 Lastnams Firstname MORALES BONITA THOMPSON RYAN Address P.O. BOX 651 P.O. BOX 9835 State FL Zip 32328 CA 90404 City EASTPOINT SANTA MONICA TALLAHASSEE SEATTLE SMITH FL 1003 1005 LEILA CINDY P.O. BOX 66 P.O. BOX 851 32306 98115 GIRARD WA 5. For each table in the database, identify the primary key and the foreign key(s). If the table does not have a foreign key, write None in the assigned space. Table Primary key Foreign Key Books Customers Orders Radecitens 6. Do the tables exhibit entity integrity? Answer Yes or No, then explain your answer. Table Entity Integrity Explanation Books Customers Orders Qidaritems 7. Do the tables exhibit referential Integrity? Answer Yes or No, then explain your answer. Write NA not Applicable) if the table does not have a foreign key. Table Referential Explanation Integrity Books Customers Orders ardecitems Lab 2 Database Design Part 1 Use the database shown below to work Problems 1 through 7. Note that the database is composed of four tables and reflects these relationships: A CUSTOMER has only one customer#, but a customer can place any number of orders. A BOOK has only one isbn, but can be order as many times as the customer wants. Note also that the M:N relationship has been broken down into two 1:M relationships for which the ORDERITEMS table serves as the composite or bridge entity. 1. Evaluate if the book "HOW TO MANAGE THE MANAGER' will be entered in to BOOKS table without an error explain why or why not? ISBN 9247381001 Title HOW TO MANAGE THE MANAGER Pubdate 09-MAY-03 Pubid 1 Cost 15.4 Retail 31.95 Category BUSINESS Contents of BOOKS table Title ISBN Pubdate Pubid Cost Retail Category 2. Also evaluate the rows shown under ORDERS & ORDERITEMS tables if they will be entered in the respective tables without error, explain why or why not? Orders table: Order Customer # 1019 Shirstat Shirzi Shircos. t 07960 2 1010 NJ arderdat shindat shiraddce Shirsity 55 03-APR- 04-APR- 384 MORRISTOW 09 09 WRONG N WAY HOME Contents of ORDERS Table Order # Customer # giderdat sbirdat Shiraddress Shircity Shiestatshirzi Shirces. t 3. Also evaluate the rows shown under ORDERITEMS tables if they will be entered in the respective tables without error, explain why or why not? Orderitems table: ISBN Order 1005 1009 Item# 1 1 1059831198 3437212490 Quantity 1 1 Paideach 39.95 19.95 Contents of ORDERITEMS table Quantity 1 1 1 Order# 1000 1001 1001 1002 1003 1003 1003 1004 Item# 1 1 2 1 1 2 3 1 ISBN 0401140733 4981341710 8843172113 1059831198 0401140733 4981341710 BB43172113 2491748320 Z 1 1 Paideach 19.95 31.95 85.45 55.95 55.95 30.95 19.95 85.45 1 Z 4. Evaluate if customer# 1006 AND 1004 will be entered in CUSTOMERS table without an error, explain why or why not? Customer Lastnams. Firstname Address City State Zip Region 1006 CRUZ MESHIA BZ DIRT ROAD ALBANY NY 12211 NE 1004 MOLINA JENNIFER P.O. BOX 754 ORLANDO FL 32306 Contents of CUSTOMERS table Customer 1001 1002 Lastnams Firstname MORALES BONITA THOMPSON RYAN Address P.O. BOX 651 P.O. BOX 9835 State FL Zip 32328 CA 90404 City EASTPOINT SANTA MONICA TALLAHASSEE SEATTLE SMITH FL 1003 1005 LEILA CINDY P.O. BOX 66 P.O. BOX 851 32306 98115 GIRARD WA 5. For each table in the database, identify the primary key and the foreign key(s). If the table does not have a foreign key, write None in the assigned space. Table Primary key Foreign Key Books Customers Orders Radecitens 6. Do the tables exhibit entity integrity? Answer Yes or No, then explain your answer. Table Entity Integrity Explanation Books Customers Orders Qidaritems 7. Do the tables exhibit referential Integrity? Answer Yes or No, then explain your answer. Write NA not Applicable) if the table does not have a foreign key. Table Referential Explanation Integrity Books Customers Orders ardecitems