Database design

Assignment 1
For this assignment, you need to submit your code (SQL script), including structure from the Data Definition Language (DDL) and the Data Manipulation Language (DML).
Use these SQL Statements
As a starting point for your 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, it’s columns, define and modify the primary and foreign keys, stored procedures, delete 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.
• Your document must include comments (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:

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

 
The deliverables for this assignment are

• Cover sheet
• Updated database creation DDL and table loading DML, and
• The new DML queries as requested

Assignment 2

1. What did you accomplish this week? How has what you are learning in your current course assisted with this?
2. What did you apply and how did you apply it?
3. Were there problems encountered with job assignments or your work environment? What were your efforts towards resolution?
4. Directly connect course related content to this week’s experiences at work.