Implement the ER model you developed in Part A as a relational database design. 1. Transform your ER model into a relational database design. (25 marks) Note: Document the tables in your design using...

Implement the ER model you developed in Part A as a relational database design.  1. Transform your ER model into a relational database design.                       (25 marks) Note: Document the tables in your design using the Relation Notation shown below. Customer(CID, Name, Street, Suburb, State, PostCode, DiscountPercent, Email)  SalesOrder(SOID, CID, Number, FullPrice, Discount, FinalPrice, TotalPaid, Status) foreign key (CID) references Customer(CID) Please provide two sentences explaining your cascade decisions for each foreign key.  How You Are Marked for the relational database design  Please pay attention to the following aspects when developing your ERD: • Correct tables and primary keys (7 marks) • Correct foreign keys (6 marks) • Correct cascades (6 marks) • Documentation of cascades (6 marks)  2. Implement enough of the database to demonstrate the following.  (25 marks) You do not need to implement the entire database. A. use of data types: provide examples of four different data types used in your design B. primary key constraints: provide two examples C. composite primary key constraint: provide one example D. foreign key constraints: provide two examples  E. a unique constraint: provide one example F. a cascading delete: provide one example G. a cascading update: provide one example H. column constraints (constraint affects only one column): provide two examples I. a table constraint (constraint affects more than one column): provide one example.  One possibility is that you could require that mentors were employed prior to those they mentor, i.e., mentors have a lower EmployeeId. J. default values: provide two examples K. validation rule with a corresponding validation text: provide two examples L. input mask: provide one example M. required: provide one example N. format: provide one example O. unary relationship: provide one example P. many to many relationship: provide one example Q. a subtype: provide one example.  Implement the parent and at least one child.  Note: Each item has its mark as bolded and underlined above. You need to include a brief documentation (in a word document) that highlights where the above items are demonstrated in your database, e.g. where the primary key constraints are.  Marks will be lost if your documentation is missing, unclear or not concise.
COIT11237 – Assignment 2 Specifications Page: 4.
How and what to submit Submit your assignment on the unit web site.  Please submit two files: 1. A Microsoft Word document containing: • Your Entity Relationship Diagram (ERD) for Part A • Your reasonable assumptions/points of clarification for Part A (if you have any) • Your Table Structures (Relation Notation) and Implementation documentation for Part B.  2. Microsoft Access file containing the tables and features you have implemented to support the requirements for Part B.