In this assignment 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, 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.