This program stores CD information in a simple relational database. The menu prompts for user input and allows the user to add new artists or add albums to existing artists. Album information can be edited or deleted. There is also an option to view basic statistics of the database (number or albums per artist or genere)
I wrote this out of personal interest. I have a lot of physical CDs and I was curious about how much I have of different generes or artists.
Local database file. Contains an artist table and album table.
Artist holds ID(primary key) and Name. Album holds ID(primary key), artist ID (foreign key), Name, Genre
Code was written in VSCode using python and SQLite3
- Expand tables to include more information (album release year, composer names, etc.)
- Impliment a graphical UI, potentially