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).
 

Transcribed Image Text:

Emp_First Name Emp_Last Name) Emp Id Shift ID Employee Works Shift Shift Hours Emp_Contact Inf ormation Employed By Shift Job Rst_ID Rst_name TH Restaurant Owned By Corporation Corp ID Corp name Rst sales Emp_First Name Emp_Last Name) Emp Id Shift ID Employee Works Shift Shift Hours Emp_Contact Inf ormation Employed By Shift Job Rst_ID Rst_name TH Restaurant Owned By Corporation Corp ID Corp name Rst sales

Answer rating: 100% (QA)

Here are the business rules and relational schema Business Rules An employee can work at multiple re... View the full answer