Part III ER Mapping:

Player(JerseyNumber, SchoolAttended, Name.first, Name.middle, Name.last, TeamName)

Student(JerseyNumber, CreditHours)

Athlete(JerseyNumber, AthleteNum, Trainer)

Team(TeamName, Conference, Record.wins, Record.loses)

Head(CoachID, YearsCoached, Name.first, Name.middle, Name.last CoachType, CoachedBefore)

Assistant(CoachID, YearsCoached, Name.first, Name.middle, Name.last CoachType, Position)

Team-Coach(TeamName, CoachID)

Company(TaxIDnum, Name)

Person(ssn, Name, Income)

Owner(Owner_ID, YearsOwned)

Team-Owner(TeamName, Owner_ID)

Arena(Address, Name, Occupancy)

Team-Arena(TeamName, Address)

Referee(EmployeeNum, Name, Hometown, YearsExperience)

Arena-Referee(Address, EmployeeNum)

Create tables according to the mapping. For this part, submit a description of the tables created.

Add at least five records. Submit a copy of all the records inserted.

Write and answer some (at least five) reasonable queries for your database. When I say reasonable queries I mean 3-4 table joins to use most of the tables or group of tables in your database. You should not have tables that are of no use. For this part, first, write the queries in English that is, telling me what you are finding in the queries. Then, present the query and finally present the output of the query (as you do for your homework assignments).