Deliverables: Relational Schema Diagram and DDL. This is the second part of the ongoing project. Complete the following (based on the case study): 1) Using the attached ER-Diagram (in the next page) for the case study, create a relational schema diagram. Make sure your diagram identifies relations, their attributes, the primary key, and referential integrity. 2) Develop a set of SQL statements that create the tables for your schema. You may use the Notepad to write your statements, save them with a file and name the file as Your FirstNameLastName.sal, and submit it along with your schema diagram PN Street Address CREDIT CARD TYPE Cod. Candy ADMINISTRATOR 0%, Address Phone Stale Code Zp STATE Places State Name On Hand Active RESTOCK ORDER Title Order Point Price ISEN Contains Quantity Ordered CATAGORY Cated by has REVIEW BOOK Year Published Pured By Written by Review Text Review No Quan Ordered PUBLISHER Cartans Price Al Purchase AUTHOR Order Date First Name ORDER Street Address AN Order Time Last Name CY Shop Address Places First Name Last Name Credit Card Type Seet Address Custhame PAN Credit Card Number Total Su Address CUSTOMER Shipping Handing Exprebon Date Credit Card Type Zp Erion Date Credit Card Number