2018 Summer IS631 Chapter 7 Assignment Summer 2019-1.docx - You have been asked to design a database for Professional Baseball Your diagram must contain

2018 Summer IS631 Chapter 7 Assignment Summer 2019-1.docx -...

This preview shows page 1 out of 1 page.

You have been asked to design a database for Professional Baseball. 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.Information on people should be kept together. A record for each person contains the basic information about the person such as name, address, etc….2.The people recorded in rule #1 can be in one or more of the following types:a.Pitcherb.Fielderc.ManagerDifferent information without overlap is stored for each of the types.3.Batting information is also stored for each person. Personal batting information is reported by year, team and league over a person’s entire professional career.4.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 year5.Each Team belongs to a League6.Each Team has their own Stadium or Ball Park they play in. Over time, teams may move to new
Image of page 1

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture