1. Engineering
  2. Computer Science
  3. 4 p24 using figure p24 the dealco diagram identify each...

Question: 4 p24 using figure p24 the dealco diagram identify each...

Question details

FIGUREA relational diagram 2.4 AGENT CUSTOMER AGENT CODE AGENT LNAME AGENT FNAME AGENT INITIAL AGENT AREACODE AGENT PHONE AGENT ADDRESS AGENT CITY AGENT STATE AGENT Z1P AGENT DATE HIRED AGENT VTD PAY AGENT YTD FIT AGENT YTD FICA AGENT YTO SLS AGENT DEP CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS PHONE CUS INSURE TYPE CUS INSURE AMT CUS RENEW DATE AGENT CODE

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 means I 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 Crow’s 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