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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 19RA

See similar textbooks

Similar questions

The "Annual_Sal" attribute in the "BOOK" Entity type is considered as: Main Sub Annual Title ISBN Author Sal ВОK O 1. Key Attribute O 2. Stored Attribute O 3. Derived Attribute O 4. Multi-Valued Attribute 10 The "Title" attribute in "R OOK" Entity Tyne is considered as:
a) Put the following relation in BCNF: STUDENT_ACTIVITY STUDENT_ACTIVITY (StudentID, StudentName, Activity, ActivityFee, AmountPaid) StudentID StudentName Activity ActivityFee AmountPaid 1 100 Jones Golf 65.00 65.00 2 100 Jones Skiing 200.00 0.00 3 200 Davis Skiing 200.00 0.00 4 200 Davis Swimming 50.00 50.00 5 300 Garret Skiing 200.00 100.00 6 300 Garrett Swimming 50.00 50.00 7 400 Jones Golf 65.00 65.00 400 Jones Swimming 50.00 50.00 b) Put the following relation in BCNF: Student(SSN, sName, address, HScode, HSname, HScity,GPA, priority) Assuming a student can attend more than one high school, and priority is determined by GPA
For the following business rules, a sample ERD is provided below. • A painter can paint may paintings. Each painting is painted by only one painter. A gallery can exhibit many paintings. • A painter can exhibit paintings at more than one gallery at a time. • Each painting is exhibited in only one gallery. In the ERD below, an entity is missing a foreign key. Click on the entity that is missing the foreign key. PAINTER PAINTING PK Painter Num PK Painting Num Painter_LName paints но- Painter FName Painting Title FK Gallery Number Painter_Initial O is shown in GALLERY PK Gal Num Gal_Name Gal_Web
Normalize the following table to 3NF. 4 PK StudentNo CourseID StudName | GradeReceived StudCity StudMajor Business rule A student takes more than one course. Each course takes more than one students. The PK of the table is a composite of StudentNo and CourseNo
39 Refer to the following ER diagram to answer the question below: PK Student SSN Name Year GPA How are keys used in these relations? PK PK Registration CampusID SSN EnrollmentDate Graduation Date PK O The CampusID attribute in the Registration relation is a candidate key. O The SSN and CampusID attributes in the School and Student relations areforeign keys. The CampusID and SSN attributes in the Registration relation are foreign keys. O The SSN attribute in the Registration relation is a candidate key. School CampusID Name Address X PERHI
Let R and K be two relations under a join operation. Assume that m = |R| and n = IKI, then the maximum and minimum sizes of the join, respectively, are: 1. m+n and 0 II. mn and 0 III. m+n and m-n IV. mn and m+n III O IV =
Normalize the following table up to 3NF. Show output and dependencies at each step. ClientRental clientNo cName propertyNo pAddress rentStart rentFinish rent ownerNo oName CR76 PG4 Tina Murphy John Кay 6 Lawrence St, 1-Jul-03 Glasgow 31-Aug-04 350 CO40 5 Novar Dr, Glasgow PG16 1-Sep-04 1-Sep-05 450 CO93 Tony Shaw 6 Lawrence St, 1-Sep-02 Glasgow Tina Murphy Aline Stewart CR56 PG4 10-June-03 350 CO40 PG36 2 Manor Rd, 10-Oct-03 1-Dec-04 375 CO93 Tony Shaw Glasgow 5 Novar Dr, Glasgow PG16 1-Nov-05 10-Aug-06 450 CO93 Tony Shaw
Given the following relation that stores details of employees and their projects: If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. 1.ProjectID ➡ EmployeeName 2.ProjectID ➡ EmployeeSalary 3.ProjectID , EmployeeName ➡ EmployeeSalary 4.EmployeeName ➡ EmployeeSalary 5.EmployeeSalary ➡ ProjectID 6.EmployeeSalary ➡ EmployeeName , ProjectID
Draw an ERD that shows the entities, attributes, primary key(s), foreign key(s), and relationships. Each relationship must be labeled. List all identifying relationships (if any). List all non-identifying relationships (if any). List all independent entities (if any). List all dependent entities (if any). Whenever patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients signed up to be seen by doctor must be a member of at least one insurance carrier. Each time a patient visits the doctor, an insurance claim is generated and will later be sent to the carrier for payment. The claim must contain information about the visit, such as date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. The relational notation for the database is: Patient (Patient ID, Name, Address, Phone, Primary Carrier,…
There are M:1 relationship between Property entity and Owner entity. There are 1:M relationship between Property entity and Services entity. There are 1:M relationship between Address entity and Property entity. There are M:1 relationship between Service entity and Employee entity. Find minimum and maximum cardinality of the following relations
Create a Crow's Foot ERD to include the following business rules for the ProdCo company:a. Each sales representative writes many invoices.b. invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales representative.e. Each customer can generate many invoicesd. Each invoice is generated by one customer
Which of the following statements are correct about EER model for this requirement? Book, Periodical, DVD, ReferenceItem, BorrowingItem, RegisteredUser, and TemporaryUser are set as entities. RegisteredUser and TemporaryUser can be generalized into a User entity. The specialization/generalization hierarchy for users is overlapping for disjoint constraint. Book, Periodicals, DVD, ReferenceItem, and BorrowingItem can be generalized into an Item entity

SEE MORE QUESTIONS

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

SEE MORE TEXTBOOKS