Question: SQL - Database Management Given the following ERD for a Restaurant Inc.: 2.1) Identify (write down) all relationships and their cardinality and write the corresponding

SQL - Database Management

Given the following ERD for a Restaurant Inc.:

SQL - Database Management 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 Nam Rst sales ormation EmployeeloBH Restaurant Emp ld Owned By Works Shift Corporation Shift ID Shift Job Corp ID Corp name Shift Hours

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!