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
Get step-by-step solutions from verified subject matter experts
