Question: Instructions Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script

 Instructions Implement the following ER model and sample data using Oracle

Instructions Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. Customer The table name should be CUSTOMERS (plural). Each CustomerlD should be a 3-digit number. Names should be strings of up to thirty characters. The sample data should be: - 101, John Doe - 102, [your name] Order The table name should be ORDERS (plural). Each OrderlD should be a 4-digit number. Product names should be strings of up to thirty characters. The sample data should be: - 1001, 01-IAN-22, Apple, 101 - 1002, [a date of your choice], [a product of your choice], 102 What you submit are 1. The SQL script to (i) drop the two tables, (ii) create the two tables, (iii) insert the sample data, and (iv) show the full contents of the two tables. a. The header of your script should be something like

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!