Analyze the case study and develop:

1)Using the attached ER-Diagram for the case study, create a relational schema diagram. Make sure your diagram identifies relations, their attributes, the primary key, and referential integrity

2)Create a set of SQL files which create the tables of your diagram in Oracle. Have one file for each table. Thus, each file will contain one complete create table statement. In addition, create a separate SQL file to create the entire database and another SQL file to drop all tables in the database. The create database file should contain a list of @ where file name is the name of a file that creates a table. The drop database file, is to drop each table you created. Thus all the tables for your database can be created with your create file and dropped with you drop file. All files are expected to run on Oracle

User Name PIN Street Address CREDIT CARD City ADMINISTRATOR Address Phone State ate Code Zip STATE State Name Order Number On Hand RESTOCK ORDER Title Order Point Price Contains Quantity Ordered CATAGORY Category Classified by has REVIEW BOOK Year Published Published By Written by Review Text Review No Quantity Ordered PUBLISHER Contains Price At Purchase AUTHOR Order Date First Name ORDER Street Address Order Time Last Name City Shipping Address First Name Last Name State Credit Card Type Street Address Cust Name PIN Zip Credit Card Number Total Subtotal City Address CUSTOMER Shipping Handling Expiration Date State Credit Card Type Zip Expiration Date Credit Card Number