Lists and Files
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
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 selects that option.
Level 4:
Your interface is now a combination of graphics and text that still uses a mouse to navigate through a menu system.
You will need to work with the Pygame Appendices to create a graphical menu in Pygame.
Level 4+:
All aspects of the interface are graphical, including keyboard input.
Communication:
Level 1:
Code is unclear to understand with no effort put into commenting or the use of good variable names.
Output from the interface is not user-friendly.
Level 2:
Code is unclear in some parts due to lack of good variable names or limited effective commenting.
Output provides understandable prompts and messages sometimes.
Level 3:
Code is mostly clear and easy to understand due to good use of variable names and commenting.
Output consistently provides understandable prompts, messages and screens for the user.
Level 4:
Code is clear and easy to understand with the use of excellent variable names, effective commenting and organization of the code. Good use of functions to organize code and make it easier to read.
Output is always user friendly and shows a high degree of polish.
Hello! I'd like to help you with a custom database development. I'm familiar with database architecture as well python language. I'll do the job blazingly fast. Please, give me a try!
Hi im a computer engineer working with python for a long time, i worked with scraping, with pandas as dataframe, database such as MySQL and MongoDB, i would like to know more about your project, i didnt see many difficult on your specification but realy want to know more.
Regards,
Fabian
I am comfortable with python data structures along with connecting to mysql databases via python. I have the time to write a quality program and believe that your highest level described could be met.