Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script
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. CustomerID Customer Name 1 places OrderID M Order Date ProductName Customer 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, [your name] 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 What you submit are 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.
Step by Step Solution
★★★★★
3.44 Rating (151 Votes )
There are 3 Steps involved in it
Step: 1
Answer step 1 CREATE TABLE Customer CustomerID NUMBER PRIMARY KEY Name VARCHA...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started