Scribd Logo
Upload

Welcome to Scribd!

  • 16 views

    Data Model (Simple Case Study)

    Uploaded by

    Cassie Cutie

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd

    Data Model (Simple Case Study)

    Uploaded by

    Cassie Cutie
    16 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd
    Download as pdf
    16 views1 page

    Data Model (Simple Case Study)

    Uploaded by

    Cassie Cutie

    Copyright:

    © All Rights Reserved
    Download as PDF or read online from Scribd
    Download as pdf
    You are on page 1of 1
    10118122, 9:43 AM Loading [<= Search more Sotto! Answer Step 1 Entity-Relational Diagram (ER Diagram): The following diagram illustrates the ER diagram for given business rules in Crow’s Foot notation: PARENT PK [PID _—_ = P_LNAME an SEAYER._—_t) P_FNAME REGISTER CONTACT] | eNRoLis }PRFRI PID nN PK.FK2 [REGISTER ID x [rea Includes! COACH TEAM, PK IC PK TEAMID [COACH FNAME ICOACH_LNAME PHONE leks [TEAMID. AME COLOR [COLOR NAME TEAMID Step 2 Explanation: The above ER diagram contains several entities such as "PARENT", "REGISTER", "PLAYER", "COACH", "TEAM" and "COLOR". ‘+ Each entity has its own attribute * The relationship between "PARENT" and “PLAYER” is M: N. Hence, the composite entity “REGISTER” acts as a bridge between those entities. * Ateam contains several players. Hence, the relationship between “TEAM” and “PLAYER” is 1: M. Ateam contains several colors. Hence, the relationship between “TEAM” and “COLOR" is 1: M. A team may have many coaches. Hence, the relationship between "TEAM" and "COACH’ is 1: M. hitpsscreatveworks olistorytoling-number-one-sklbimprover an

    You might also like