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

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

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!