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 parts
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
Get step-by-step solutions from verified subject matter experts
