1. Engineering
  2. Computer Science
  3. region store employee job store code store name storeytd sales...

Question: region store employee job store code store name storeytd sales...

Question details

REGION STORE EMPLOYEE JOB STORE CODE STORE NAME STORE_YTD SALES REGION CODE EMP CODE EMP TITLE EMP LNAME EMP FNAME EMP INITIAL EMP DOE JOB CODE STORE CODE REGION CODE REGION DESCRIPT JOB CODE JOB DESCRIPTION JOB BASE PAY Figure P2.4 The DealCo relational diagram 4. (P2.4) Using figure P2.4 the DealCo diagram, identify each relationship type (1:1, 1:M, M:N) and write all of the business rules, Note there is one relationship between two entities and this relationship is bi-direction. This meansI would expect two business rules per relationship - one for each direction. (3 points) 5. (P2.5) Using figure P2.4 the DealCo diagram, create the basic Crows Foot ERD for DealCo. For full credit be certain to label each entity, label the relationship, and indicate connectivity. (5 points)

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution