Create a Data Model depicting a hypothetical Business or Organization with the following requirements: - At least 5 tables (create your own table name. Make sure it is a descriptive name) - Each Table has a primary key - Make sure that Tables are normalized - Establish a relationship among tables (using Foreign Key) - Create CRUD (Create (or Insert)-Retrieve-Update-Delete) Operations Scripts for each Table Files to be submitted (only 3 SETS of files):

1) DDL (Data Definition Language) Scripts - One script for EACH Table (e.g. CREATE TABLE tablename1 .....). - Zip all the DDL Scripts and give it the filename "DDL_YourOwnStudentId.zip".

2) DML (Data Manipulation Language) Scripts: - One INSERT Statement for EACH Table - One SELECT Statement for EACH Table - One UPDATE Statement for EACH Table - One DELETE Statement for EACH Table - One Stored Procedure without a parameter to select from at least two Tables that are Joined using the INNER JOIN command - One Stored Procedure with a parameter to select from at least two Tables that are Joined using the INNER JOIN command - Zip all the DML Scripts and give it the filename "DML_YourOwnStudentId.zip".

3) Snapshot image (filename should be "ERD_YourOwnStudentId.jpg") of the Entity-Relationship Diagram showing the relationship between tables (with a 1:1 or 1:M symbols) IMPORTANT NOTES: 1) No duplicate design is allowed (All duplicated submissions will be deducted 50% of the mark - no exceptions) 2) Submit on or before the Due Date (late submission will be deducted 10 points) 3) Do not use the examples from the course (zero marks will be given)

4) Marks will be based on the following criteria: - Completeness of design - Originality - Workability or Functionality - Means all the scripts are correct and working - Effectiveness and Efficiency - Means that Tables are properly normalized and no data redundancy