I want to see reports on the various songwriters and their musical catalog for my music publishing company. It's too time consuming to use excel every time I need information compiled.
- Must be written using CRUD
- Must Use the Command Line to run
- Must have 2-3 interesting queries
- User can enter in Songs, Writers and Publisher Info to database.
- User can update incorrect information if stored incorrectly.
- User can remove a Song, Writer or Publisher.
- User can query various reports on Songs, Writers & Publishers.
- Queries a songwriter song catalog for information that is missing. (Info the writer still needs to submit to publisher)
- Queries songs that were written in a certain contract period.
- Queries a songwriter's catalog and creates a report of all their songs
- Queries songs that a writer wrote with a particular co-writer.
- Queries Publisher info for a certain song.
- A publishing company has provided their music catalog via .xlsx files. I will need to parse it to reformat fields and tables. Here is a link to an example of one of their songwriter's catalog worksheets here