Assignment 1: ER ModelArkansas Basketball Conference is an amateur basketball association. It has contacted you tocreate a database that will meet the expected data requirements for its basketball gamemanagement program. The administrator gives you the following description of the group'soperating environment.Each city in the county has one team that represents it. The database will maintain informationabout cities (CityID, Name, and State) and teams (TeamID, Name, and Mascot). Each team has anumber of players. Each player belongs to one team. Player information (such as PlayerID,FName, LName, and Position) will be maintained in the databaseA team has many coaches (e.g., head coach, offensive coaches, defensive coaches etc.). Eachcoach belongs to one team. The database will store information on coach such as CoachID,Name, Phone, and Title.A team plays many games against other teams during the season. Each game involves two teams.The game information (such as GamelD, Location, Score, Date and Description) will bemaintained. The system will need to maintain information which team won or lost in the game.For the basketball game management, the association hires staff members. The system maintainsinformation on staff (such as EmpID, FName, LName, Address, HireDate and Salary). Each staffmember is supervised by a supervisor. Each suoervisor manages more than one (i.e., many) staffmembers. The association assigns staff to games for game management. A staff member isassigned to many games. Each game is assigned many staff members. The database needs tokeep track of the number of hours assigned to games for each staff member. The system alsoneeds to maintain the information on the dependents of the staff members (such as FirstName,Relationship, and BirthDate) for the purpose of payroll calculation.RequirementsThe first step to database development is to construct a conceptual model. Given the datarequirements and business rules, construct a conceptual model using ERD.

Answered: Assignment 1: ER Model Arkansas…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Assignment 1: ER Model
Arkansas Basketball Conference is an amateur basketball association. It has contacted you to
create a database that will meet the expected data requirements for its basketball game
management program. The administrator gives you the following description of the group's
operating environment.
Each city in the county has one team that represents it. The database will maintain information
about cities (CityID, Name, and State) and teams (TeamID, Name, and Mascot). Each team has a
number of players. Each player belongs to one team. Player information (such as PlayerID,
FName, LName, and Position) will be maintained in the database
A team has many coaches (e.g., head coach, offensive coaches, defensive coaches etc.). Each
coach belongs to one team. The database will store information on coach such as CoachID,
Name, Phone, and Title.
A team plays many games against other teams during the season. Each game involves two teams.
The game information (such as GamelD, Location, Score, Date and Description) will be
maintained. The system will need to maintain information which team won or lost in the game.
For the basketball game management, the association hires staff members. The system maintains
information on staff (such as EmpID, FName, LName, Address, HireDate and Salary). Each staff
member is supervised by a supervisor. Each suoervisor manages more than one (i.e., many) staff
members. The association assigns staff to games for game management. A staff member is
assigned to many games. Each game is assigned many staff members. The database needs to
keep track of the number of hours assigned to games for each staff member. The system also
needs to maintain the information on the dependents of the staff members (such as FirstName,
Relationship, and BirthDate) for the purpose of payroll calculation.
Requirements
The first step to database development is to construct a conceptual model. Given the data
requirements and business rules, construct a conceptual model using ERD.

Expert Solution

Step 1

ER diagram is known as Entity-Relationship Diagram, it is used to analyze to structure of the Database. It shows relationships between entities and their attributes. An ER Model provides a means of communication.

Entities and their Attributes are

City Entity : Attributes of City Entity are cityID,name,state.
cityID is Primary Key for City Entity.

Team Entity : Attributes of Team Entity are teamID,name,mascot.
teamID is Primary Key for Team Entity.

Player Entity : Attributes of Player Entity are playerID,Fname,Lname,position.
playerID is Primary Key for Player Entity.

Coach Entity : Attributes of Coach Entity are coachID,name,phone,title.
coachID is Primary Key for Coach Entity.

Game Entity : Attributes of Game Entity are gameID,score,location date,description.
gameID is Primary Key for Game Entity.

Staff Entity : Attributes of staff Entity are empID,Fname,Lname,address,salary,hiredate.
empID is Primary Key for staff Entity.

Dependent Entity : Attributes of Dependent Entity are first name,birthdate,relationship.
cityID is Primary Key for Dependent Entity.

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions