Question: Create relational schema that matches ERD and normalized schemas you created in Part A and B. The schema should include suitable data validation, integrity and

Create relational schema that matches ERD and normalized schemas you created in Part A and B. The schema should include suitable data validation, integrity and referential integrity constraints, for example, types and length of attributes, primary and foreign keys etc. Make sure you follow standards, naming conventions and notation. (2.5 Marks) Include the relational schema in your documentation. The following is sample Entity/Table EMPLOYEE Field Name employeeID firstName lastName gender dateBirth email phone storeNo departmentNo Datatype int varchar (30) varchar (30) char (1) Date varchar (50) char (10) int int tabular format on relational schema. You are free to add more columns if required. Constraints NOT NULL PK NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL FK FK

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!