Project 2 - SQL DDL and SQL DML (Part 1 of 2)
In this project you will conclude the _logical_ design of the Mom and Pop Johnson Video Store database you designed in Project 1, 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. As described in Module 4, these are the next steps in implementation of the database that you designed via E/R Diagramming in Project 1 (_logical_ design).
In addition, some basic single-table and multi-table data retrievals against your database will be performed.
Your design work and SQL must be submitted through the Submit Assignments WebTycho facility. **Include both the SQL used, and the Oracle 9i or 8i responses immediately after each SQL statement in a single listing. ** Do not provide separate SQL and response listings. You may use any SQL*Plus available to you as long as it interfaces to Oracle9i or 8i. You should use a hierarchy of SQL scripts to perform this project (review SQL scripts in Module 4). Allow _sufficient_ _time_ to complete the project fully by following _all_ directions.
_The assignment_: plz open the zip file..