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, 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
Get step-by-step solutions from verified subject matter experts
