Please create a relational schema for the ER diagram that is attached to this question as the Assignment 1 solution (screenshot attached)

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 primary keys and foreign keys.

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