Description

Database Foundations

ASSIGNMENT 2

Please create a relational schema for the ER diagram that is attached to this assignment as the Assignment 1 solution (File name: Solution_Assignment1.jpeg).
Please use GRAPHICAL REPRESENTATION to express your relational schema.

a. Show all the tables (relations) you need to create with all the corresponding attributes for each table, including foreign keys.

b. Show the primary keys (underline), foreign keys (dotted underline) and foreign key references (using arrows).

Use the solution attached to this assignment, not your own Assignment 1 Solution. No exceptions!

Good luck.