Question: CPSC 2221 Lab 4: Relational Schema Total Marks: 40 INDIVIDUAL LAB SUBMISSION 1. Convert below ER diagram to the relational schema. Underline the primary keys
CPSC 2221 Lab 4: Relational Schema Total Marks: 40 INDIVIDUAL LAB SUBMISSION 1. Convert below ER diagram to the relational schema. Underline the primary keys and bold the foreign keys. 2. Write the SQL statements needed to create the relation using all required and appropriate constraints. Employees address capacity name phone ISA model no weight salary Model Expert Technician Traffic control Type Test Test info Plane name score hours core Tegno FAA no date Submission Submit the PDF through Brightspace. Marking 1. Relational schema [20 Marks) 2. SQLS [20 Marks]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
