Assignment: NBA Database For this assignment you will create a database and C++ program that can read from/write to that database. You will create a database for the National Basketball Association (NBA) this database adheres to the following business rules. You will use the business rules to determine the attributes and entities for the database. The NBA is made up of 2 conferences the Eastern Conference and the Western Conference Each conference is made up of several divisions Each division belongs to only one conference. Each division is made up of several teams. Each team belongs to only one division. Each team is made up of several players Each player only plays for one team at a time Each team has a head coach. Each coach works for only one team. A team has a name (Washington Wizards, Golden State Warriors) A team has a mascot (Pacers, Pistons, Celtics, Lakers) A team has a city/state associated. A team has an arena where games are played. A player has a first and last name and a number. A game is played by 2 teams on a specific date/time. A game is played at the arena of the home team. A game has a final score. Start this project by defining all the entities and their attributes. Then create a conceptual design for the database using an ER diagram (all tables should be in 3NF). Finally create the database in Sqlite and load sample data into it. After the database is created, write a menu based C++ program that will give you options for viewing and adding information to the database. You may have others, but you should at least have options for viewing the teams in a division; (You can provide menu options that allow the user to choose the division). Adding a new team; Adding a player; Viewing the roster for a team; Viewing game information; Adding game information. Please include documentation in your C++ code in addition to the header with your name. To submit your work in 3 files: 1. Submit your ER diagram that has been saved as a pdf. 2. Submit your .db sqlite file 3. Submit your cpp source code.
Assignment: NBA
For this assignment you will create a database and C++ program that can read from/write to that database.
You will create a database for the National Basketball Association (NBA) this database adheres to the following
business rules. You will use the business rules to determine the attributes and entities for the database.
The NBA is made up of 2 conferences the Eastern Conference and the Western Conference
Each conference is made up of several divisions
Each division belongs to only one conference.
Each division is made up of several teams.
Each team belongs to only one division.
Each team is made up of several players
Each player only plays for one team at a time
Each team has a head coach.
Each coach works for only one team.
A team has a name (Washington Wizards, Golden State Warriors)
A team has a mascot (Pacers, Pistons, Celtics, Lakers)
A team has a city/state associated.
A team has an arena where games are played.
A player has a first and last name and a number.
A game is played by 2 teams on a specific date/time.
A game is played at the arena of the home team.
A game has a final score.
Start this project by defining all the entities and their attributes. Then create a conceptual design for the
database using an ER diagram (all tables should be in 3NF). Finally create the database in Sqlite and load
sample data into it.
After the database is created, write a menu based C++ program that will give you options for viewing and
adding information to the database. You may have others, but you should at least have options for viewing the
teams in a division; (You can provide menu options that allow the user to choose the division). Adding a new
team; Adding a player; Viewing the roster for a team; Viewing game information; Adding game information.
Please include documentation in your C++ code in addition to the header with your name.
To submit your work in 3 files:
1. Submit your ER diagram that has been saved as a pdf.
2. Submit your .db sqlite file
3. Submit your cpp source code.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
