Based on the given ERD, identify all the business rules and explain them. Also, identify all primary keys and foreign keys with in the entities and explain the roles that they are playing in the ERD design. PARENT REGISTERS PLAYER PK Parent ID PK,FK1 Parent ID PK,FK2 Player ID has has PK Player ID Parent LName Parent_FName Parent Phone Parent_Street Parent City Parent State Parent Zip %23 Player FName Player LName Player Age FK1 Team_ID saphpu TEAM COACH coached by PK Team ID Team Name Team_Colors Coach FName Coach LName Coach Phone Team ID IHO
Based on the given ERD, identify all the business rules and explain them. Also, identify all primary keys and foreign keys with in the entities and explain the roles that they are playing in the ERD design. PARENT REGISTERS PLAYER PK Parent ID PK,FK1 Parent ID PK,FK2 Player ID has has PK Player ID Parent LName Parent_FName Parent Phone Parent_Street Parent City Parent State Parent Zip %23 Player FName Player LName Player Age FK1 Team_ID saphpu TEAM COACH coached by PK Team ID Team Name Team_Colors Coach FName Coach LName Coach Phone Team ID IHO
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 19RA
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning