Question: Create the Data Definitions for each of the relations shown below, using SQL DDL Assume the following attributes and data types: Insertion of data is

 Create the Data Definitions for each of the relations shown below,

Create the Data Definitions for each of the relations shown below, using SQL DDL Assume the following attributes and data types: Insertion of data is required and create table with last 3 digits of your enrolment no. (e.g. Order_001). Order: OrderID(integer, primary key) CustomerID(integer) SalesmanID(integer) 3001 1001 5001 1002 3002 5002 1003 3003 5003 Customer: CustomerID(integer, CustomerName(15 characters) Country(15 characters) primary key) 3001 Nick Rimando New York 3002 Brad Davis California 3003 Geoff Cameron New York Salesman: SalesmanlD(integer, primary key) SalesmanName(15 characters) 5001 James Hoog 5002 Me Lyon 5003 Paul Adam 1. Create table of Order, Customer and Salesman 2. Add an attribute, Order Date, to the "Order" table (use integer data type) 3. Modify the attribute Order Date from integer to Data format. 4. Remove Order Customer and Salesman Table 5. Create Replica of Order table by adding an attribute of Product detail in it

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!