Question: Relational database question, please answer all parts Exercise 4 (total 20 pts) The ToyCo Access relational diagram shows the entities, attributes, and relations for the

Relational database question, please answer all partsRelational database question, please answer all parts Exercise 4 (total 20 pts)

Exercise 4 (total 20 pts) The ToyCo Access relational diagram shows the entities, attributes, and relations for the ToyCo stores, which are located in regions of the country. ToyCo is a company that sell toys for kids. REGION 7 REGION_CODE REGION_DESCRIPT STORE STORE CODE STORE NAME STORE YTD SALES REGION_CODE JOB Y JOB_CODE JOB DESCRIPTION JOB_BASE_PAY EMPLOYEE EMPCODE EMPTITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP DOB JOB CODE STORE CODE DO DO 1. (5 pts) Give a name to each relationship and give its multiplicity (type). 2. (10 pts) Create the Crow's Foot ERD for ToyCo. 3. (5 pts) Give three business rules you can infer from the above diagram

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!