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

  Analyse the credit approval data set

Analyse the  Credit Approval  data set - A data set description in terms of the attributes present in the data, the number of instances,missing values, and other relevant characteristics.

  What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?

  Create database that implements the proposed data warehouse

Knowing the customers for targeted advertising. The board would like to know which type of customers (age or gender) are more interested in which types of cars (type)

  Compare and contrast at least two types of database

Compare and contrast at least two types of database backup. Then suggest and justify which type of database backup would be more suitable to the organization.

  Explain database models-hierarchical and relational

Explain each of three database models, hierarchical, relational, and object-oriented, and provide specific referenced example of each of these model types implemented in a functioning database

  What specific data about the entities will need to be stored

The local library wants to update its book check process. To do this, the system will need to record data about what entities? What specific data about the entities will need to be stored

  Create a use case diagram for osceolas operations

Use MS Visio to create a use case diagram for question 1, a selected class diagram for question 2, and a sequence diagram for question 3.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Develop conceptual data model diagram

To develop a conceptual data model diagram and to perform logical design and Development Plan applications (here after called as application) that have been received during the previous month from the developers/ owners of the plots under the counc..

  Find out the benefits of data mining to the businesses when

the development of complex algorithms that can mine mounds of data that have been collected from people and digital

  How up to date should data warehouse information be

How up to date should Data Warehouse Information be.- Information timeliness is a must in a data warehouse-old and obsolete information leads to poor decision making.

  Relationship of primis to back-end systems at mcgraw-hill

Assess whether the prototyping would have helped the Primis team. Justify why or why not. Conclude why it was important to consider the relationship of Primis to back-end systems at McGraw-Hill

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