For this assignment, submit the code (SQL script or document), including structure from the Data Definition Language (DDL) and the Data Manipulation Language (DML).  Use these SQL Statements as a starting point for the script.

The data manipulation language (DML) is used to create, read, update, and delete data from a table. The data definition language (DDL) is used to create and alter the structure of the database itself, like creating a table, its columns, defining and modifying the primary and foreign keys, stored procedures, deleting columns, tables, and even the entire database. Your SQL statements should require a variety of SQL capabilities, such as various kinds of join, aggregate functions, etc. (This presupposes a good initial domain choice.)

Remember you must turn in code (or documentation) of the results of these tests indicating that the SQL statements for your requirements worked correctly and that your constraints correctly allowed good data and caught bad data. Your document must include comments (handwritten or entered as SQL comments in a text file) that indicate what each test is testing - i.e. a specific requirement (if "good" data) or a specific problem you were catching (if testing a constraint on "bad" data).

 

Follow these steps to complete your assignment:

 

1. Populate the database with sample data to allow testing of the schema and the various transactions. Each table should have a minimum of ten rows.
2. After entering data, create some sample queries to see if the output is what you expected.
3. Make some sample reports to make sure these also produce similar results.
4. Make any necessary corrections to the database design during this stage and before you enter all of your personal records. If you find any problems, correct the design.
5. Enter all of the personal records.
6. Write the SQL Script.

 

Submit the code (SQL script or document), including structure from the Data Definition Language (DDL) and the Data Manipulation Language (DML).