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.