Database Management Systems

ERD Analysis

Given the following ERD for a Restaurant Inc.:

2.1) Identify (write down) all relationships and their cardinality and write the corresponding business rules.

2.2) Show the relational schema for the database. Make sure to clearly indicate primary keys and foreign keys (be careful on this part).

Rst ID Rst name mp_First_Name Emp_Last Name mp Contact In ormation Rst sales Emp ld Employee Employed ByRestaurant Works Owned By Shift Corporation Shift ID Shift Job Corp ID Corp name Shift Hours