Computers and Technology, 20.12.2019 19:31, simrankaurdhatt
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.
Answers: 3
Other questions on the subject: Computers and Technology
Computers and Technology, 21.06.2019 16:50, glitch14
3.2.5 suppose that we have an estimate ahead of time of how often search keys are to be accessed in a bst, and the freedom to insert items in any order that we desire. should the keys be inserted into the tree in increasing order, decreasing order of likely frequency of access, or some other order? explain your answer.
Answers: 1
Computers and Technology, 22.06.2019 15:30, tfornwalt4390
Melissa needs to add a topic to an email that she will send to her teacher. choose the name of the field where she should type her topic.
Answers: 2
Computers and Technology, 23.06.2019 00:40, QueenKy6050
Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why. a.) student. course. callnum = "csc230"; b.) cin > > student. name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student. name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist. course. credits = 3; j.) course = studenttype. course;
Answers: 1
Computers and Technology, 23.06.2019 08:30, mai1261
Helen's credit card has an apr of 15.32% and a grace period of 17 days and helen pays her balance in the full every month. if her last billing cycle ended on september 26, 2009, and she made her payment on october 11, 2009, did she owe any interest on her last statement's balance?
Answers: 3
Do you know the correct answer?
For this assignment you will create a database and c++ program that can read from/write to that data...
Questions in other subjects:
Mathematics, 09.12.2020 22:20
English, 09.12.2020 22:20
Mathematics, 09.12.2020 22:20
History, 09.12.2020 22:20
