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.The table name should be CUSTOMERS (plural).Each CustomerID should be a 3-digit number.Names should be strings of up to thirty characters.The sample data should be:101, John Doe102, [Rachel Araya] OrderThe table name should be ORDERS (plural).Each OrderID should be a 4-digit number.Product names should be strings of up to thirty characters.The sample data should be:1001, 01-JAN-22, Apple, 1011002, [a date of your choice], [a product of your choice], 102 PLEASE FOLLOW BELOW 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.The header of your script should be something like:/*Your NameIS451 HW5*/Make sure to start your script file with DROP TABLE commands for the two tables in order to avoid conflicts. Use the DROP TABLE commands in the following order.ORDERSCUSTOMERS CustomerIDCustomerName1placesOrderIDMOrderDateProductName

Below is the implementaiton of given ER model with CREATE statemetns: CREATE TABLE…

Answered: Implement the following ER model and…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

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.

The table name should be CUSTOMERS (plural).

Each CustomerID should be a 3-digit number.

Names should be strings of up to thirty characters.

The sample data should be:

101, John Doe
102, [Rachel Araya]

Order

The table name should be ORDERS (plural).

Each OrderID should be a 4-digit number.

Product names should be strings of up to thirty characters.

The sample data should be:

1001, 01-JAN-22, Apple, 101
1002, [a date of your choice], [a product of your choice], 102

PLEASE FOLLOW BELOW

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.
1. The header of your script should be something like:
  /*
  Your Name
  IS451 HW5
  */
2. Make sure to start your script file with DROP TABLE commands for the two tables in order to avoid conflicts. Use the DROP TABLE commands in the following order.
  1. ORDERS
  2. CUSTOMERS