Design program that will serve as database for keeping track

Assignment Help Database Management System
Reference no: EM131325197

Assignment

You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its genre (type), and various user ratings, and store that information into a database (text file). The program will also need to be able to retrieve that information based on data that is to be input by the user of the program. Granted, this will not be a full-featured program, but will serve as a large enough program to test what you have learned over the course of the semester.

Your program should be interactive, presenting the user with a menu of choices, such as the following:

Add Video Game
Add Video Game Rating
Search for a Video Game by Genre (Type)
Search for a Video Game by Name
Show a Listing of All Video Games
Search for a Video Game by Rating
Save Database to a file
Load Database from a file
Exit

Here is a brief explanation of what I am looking for to be contained with each menu item:

Add Video Game. The user will be able to enter a video game%u2019s information to store in the database. The information that will be entered will include the name of the game, genre (type), price paid, and publisher. This option has to be completed at least once before options 2, 3 or 4 can be run, meaning, you must prevent a user from trying options 2, 3 or 4 until options 1 or 8 have been chosen.

Add Video Game Rating. The user will be able to select a game that they wish to rate (up to you how they select it) and then enter a rating on a 0-10 basis. Each time a rating is entered, it is added to existing ratings and the number of ratings should be kept track of. In other words, if I entered ratings about the MLB: The Show %u201812 today and then tomorrow, your ratings may be 18 and the number of ratings 2. This option has to be completed at least once before option 6 can be run, meaning, you must prevent a user from trying option 6 until option 2 or 8 have been chosen.

Search for a Video Game by Genre (Type). This option will prompt the user for a video game genre and return any matching games of that type. If there are no games for a particular type, a message stating this fact should be displayed. Information that should be displayed if a match exists for a given game would be in the format below. NOTE: Your program should not allow the user to do #3 unless #1 or #8 has been performed at least once.

SAMPLE DISPLAY:

Game: MLB: The Show %u201812

Genre: Sports

Price Paid: $54.99

Publisher: Sony

Game: Madden %u201813

Genre: Sports

Price Paid: $59.99

Publisher: EA Sports

Search for a Video Game by Name. For this option, your program will output the details for games matching the name entered. This output will consist of a table similar to the one above.

NOTE: Your program should not allow the user to do #4 unless #1 or #8 has been performed at least once.

Show a listing of all Video Games. This option will produce a similar listing to the one in option 3 above, but will simply list every single game and its corresponding data, INCLUDING its ratings. NOTE: Your program should not allow the user to do #5 unless #1 or #8 has been performed at least once.

Search for a Video Game by Rating. For this option, your program will output the details for all games with a rating above numbers you will enter. For example, if you were looking for a game with its rating above 7, it would output all games whose average rating is above 7.

NOTE: Your program should not allow the user to do #6 unless #2 or #8 has been performed at least once.

Save Database to a file. All of the entered data should be written to a data file (plain .txt file is ok) in a format so that it is easy to retrieve later (see below). You must prompt the user for the name of the file.

Load Database from a file. Data will be read back into your program from a previously saved data file. You must prompt the user for the name of the file.

Exit the program gracefully, including closing all files.

Reference no: EM131325197

Questions Cloud

Why translation exposure is relevant to an mnc : Present an argument for why translation exposure is relevant to an MNC.- Present an argument for why translation exposure is not relevant to an MNC.
What is the standard deviation of the launch price : Her most pessimistic estimate (a lower price than this one is not expected more than 10 percent of the time) is $1 million. The expected value estimate is $1.5 million. The price distribution is believed to be approximately normal.
Are currency correlations perfectly stable over time : Are currency correlations perfectly stable over time? What does your answer imply about using past data on correlations as an indicator for the future?
What is the net profitability effect on the mexican firm : What is the net profitability effect on the Mexican firm? What international market concept is demonstrated in this example? Discuss the risks associated with changing exchange rates and international commerce and provide a scenario demonstrating ..
Design program that will serve as database for keeping track : You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game.
What is assessment as to firms degree of economic exposure : What is your assessment as to the firm's degree of economic exposure? Assume that the RUD and the BTD move in tandem against the US$.
How does physician behaviors impact the nurse viewpoint : How does physician behaviors impact the nurse viewpoint about the work environment - Have any of you heard the old saying if you love what you do, you will never work a day in your life?in 150 words minimum including in text citation and reference
Create an interface displaycharacters : Create an interface DisplayCharacters and another class ShapeCharacter. ShapeCharacter contains a method for displaying either the default alphabet or the user's selected character to comprise a shape.
Discuss the relationships among ksas : Discuss the relationships among KSAs (knowledge, skills, and abilities), job analysis, organizational strategy, and HR activities. What are the KSAs needed by the firm to achieve the strategy and what KSAs are currently resident? How does the firm..

Reviews

Write a Review

Database Management System Questions & Answers

  Explain the purpose database design process

Explain why functional dependency is important in relational design. Database Design: Why go through the database design process? What are important issues during the design phase that impact the success of the database?

  Characteristics of relational database management system

Describe the characteristics of a Relational Database Management System (RDBMS).

  What airplane models are stored in a particular hangar

We require a data base for a small airport. The data base should track airplanes, pilots, hangars, airplane types, mechanics and airplane owners.

  Asnbspyou approach thenbspend ofnbspthe class you have

asnbspyou approach thenbspend ofnbspthe class you have seen how a database can be set up and accessed.nbspnext you

  Explain two ways that organizations today use databases

In your own words, provide a definition of the term "database", and explain at least two ways that organizations today use databases. Next, describe one way that you could use Access in your personal or professional life.

  Evaluation team in order to meet sarbanes-oxley compliance

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley compliance.

  How does oracle process query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Draw entity relationship diagram of state tennessee tn

Draw Entity Relationship Diagram (ERD) of state Tennessee TN. You could also list, for example, top five hospitals, or the bottom five percent. Set "Top Values" property on the property sheet in the Query Design screen.

  Physical design and implementation it requires the use of a

physical design and implementation it requires the use of a relational database management system. strayer university

  Patients post cardiac bypass surgery

Monitor Renal Outcomes in patients post cardiac bypass surgery?

  When does oracle stop processing the query

How does Oracle process this query? That is, what does Explain Plan tell you about how the query is processed - how would you recognize that the results were not correct?

  Which data set will produce frequent item sets high support

Assume that the minimum support threshold is equal to 10%. How many closed frequent itemsets will be discovered from data set 1 amd Which data set will produce frequent itemsets with high support?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd