Question: Using the following relational database, write out each relationship between the tables below including primary and foreign key information. Make sure to include relationship type

Using the following relational database, write

Using the following relational database, write out each relationship between the tables below including primary and foreign key information. Make sure to include relationship type and cardinality for full credit. (Hint: There are 5 relationships you must list) Grading Rubric: (Total 40 points) 8 points for correctly identifying each relationship from the tables 2 points for listing the cardinality and modality of each relationship indicating the PK and FK along with names of entities involved o Employee# Name Position Year Hired Supervisor Number Department Name OFFICE STAFF Building_Loc Size Department Name Unit Number DEPARTMENT SalespersonID Name Office Number Telephone# BackupID Department Name SALESPERSON Age Address City State Buyer Number Buyer Name BUYER Type DateofContact Lead Name LEADS Department Name Sale Date Buyer Number Price_sold Type_of_Loan SalespersonlD CAR PURCHASE

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 General Management Questions!