Perform the physical design and implementation using SQL.

In this assignment you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manipulation Language (DML) SQL commands. For each of the steps below you may create a separate SQL script file and SPOOL file or you may want to put the SPOOL output for several steps from the same SQL script file in the same file. Be sure your SPOOL file(s) contains your SQL statements along with the Oracle responses and/or displayed results. Do NOT submit your SQL script files. Only submit your output SPOOL files.

You may also like