For this assignment you will write CREATE TABLE and INSERT INTO statements in order to create and populate five tables in Oracle’s SQL*Plus.

computer science

Description

For this assignment you will write CREATE TABLE and INSERT INTO statements in order to create and populate five tables in Oracle’s SQL*Plus. All the information you need about the database is contained in an MS Excel workbook comprising five worksheets (there is one worksheet for each table!). The MS Excel file accompanies these instructions in the Assignment 3 item in Canvas.

More specifically, each worksheet includes the following information about its associated table: 

➢ Column names (for example, the jr_order table contains the orderID, customerID, orderDate, orderStatus, and orderShippedDate columns); 

➢ Column data types (for example, orderID is INT, orderStatus is VARCHAR2(2), etc.); 

➢ Column constraints, if any (for example, orderID in the jr_order table is a primary key, supplierName in the jr_supplier table is NOT NULL, etc.); and 

➢ All values (i.e., the data).

Instruction Files

Related Questions in computer science category