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 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.

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: 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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 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.