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

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 18:00

When is it appropriate to use an absolute reference

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:00

This question involves a class named textfile that represents a text file. public class textfile { private string filename; private string filename; private arraylist words; // constructors not shown // postcondition: returns the number of bytes in this file public int filesize() { } // precondition: 0 < = index < words.size() // postcondition: removes numwords words from the words arraylist beginning at // index. public void deletewords(int index, int numwords) { } // precondition: 0 < = index < = words.size() // postcondition: adds elements from newwords array to words arraylist beginning // at index. pub lic voidaddwords(int index, string[] newwords) { } // other methods not shown } complete the filesize() method. the filesize() is computed in bytes. in a text file, each character in each word counts as one byte. in addition, there is a space in between each word in the words arraylist, and each of those spaces also counts as one byte. for example, suppose the words arraylist stores the following words: { mary had a little lamb; its fleece was white as snow. } the filesize() method would compute 4 + 3 + 1 + 6 + 5 + 4 + 6 + 3 + 5 + 2 + 5 as the sum of the lengths of each string in the arraylist. the value returned would be this sum plus 10, because there would also be 10 spaces in between the 11 words. complete the filesize() method below: // postcondition: returns the number of bytes in this file public int filesize() { }

Answers: 1

Answer

Computers and Technology, 24.06.2019 15:30

What type of forensic evidence was recovered during the bomb set off at the new mexico facility on the video that was similar to the evidence obtained at the boston bombings and how did the evidence allow the researchers to connect other pieces of evidence to the same bomb?

Answers: 2

Answer

Computers and Technology, 24.06.2019 17:00

What are some examples of what can be changed through options available in the font dialog box? check all that apply. font family italicizing bolding pasting drop shadow cutting character spacing special symbols

Answers: 2

Answer

You know the right answer?

For this assignment you will create a database and c++ program that can read from/write to that data...

Questions