you are to create your own database using data of your choosing. This data must contain at least?10 records? with ?5 fields?

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Lists and Files In this assignment (python in wing personal software) you are to create your own database using data of your choosing. This data must contain at least?10 records? with ?5 fields?. You may fabricate this data if you wish, though it should still have meaning (Reference Number, Name, Email, and Birthday etc.), not just random numbers. You are encouraged to do your own research to find data that interests you. Some sample databases are: Sports Team Drivers Information Student Information These links may help you find data: https://toolbox.google.com/datasetsearch https://data.world/datasets/sports https://www.sports-reference.com/ https://www.statcan.gc.ca/eng/star https://www.who.int/ https://www.gapminder.org/ Be careful that you don’t pick a data set so big it’s not manageable for you. There are no bonus marks for picking more interesting data, so don’t spend too long picking the data you’re going to work with. Application: This section deals with the database you are creating.

Level 2: Your program can read your data file that has multiple fields and records into appropriate related lists. Print the contents of the file to the screen in well organized columns.

Level 3: Continued from level 2. Your program can modify individual fields in a record. Use some kind of ID Number to determine which record to modify. It should write the data from the related lists back to the file without loss of information. Hint: Read in the file. Add and modify data in the lists of your program. Then before the program exits write ALL the information back to the file.

Level 4: Continued from level 3. Your program should now be able to add new records and delete specific records from the database. Everything is written back to the file to keep the data current. Level 4+ Continued from level 4. Choose at least 3 of the different categories in your database and allow the user to generate meaningful reports. e.g. Players who have scored more than 20 goals. e.g. List of students whose Major is Music. Thinking: This section deals with the interface the user has to your database. It is expected that all output is aesthetically pleasing and any responses from the program are clear about its state. Level 2: Your program is a text based interface of the data in your database. It runs through all the options in Application once and then exits. Level 3: Your interface is still text based but uses a menu that allows the user to select options using the keyboard to navigate through your database. The program will only exit when the user wants it to by typing in assigned variable

 

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of