Chapter 7 Assignment 2019 Spring Part 2 (1).docx - You have been asked to add additional information to the database for Professional Baseball you

Chapter 7 Assignment 2019 Spring Part 2 (1).docx - You have...

This preview shows page 1 out of 1 page.

You have been asked to add additional information to the database for Professional Baseball you designed in the first ER Diagram you provided. For this part of the assignment, please make sure you include the appropriate bridge tables, specialization hierarchies and time dependent tables. Your diagram must contain all the tables needed to meet the business rules below. For each table, you must show the primary keys and relationships to other tables. The database is to contain the following:1.The people recorded in the database can be in one or more of the following types:a.Pitcherb.Fielderc.ManagerDifferent information without overlap is stored for each of the types.2.Each of these people can be in one or more types in a given year and can be a member of one ormore teams in a given year
Image of page 1

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture