Jump to content

Planning a relational database for (classical) music


This topic is 2576 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have some 36,000 CDs in a flat database (FM Pro 11).

I am considering building a new one, where the different data elements have their own table and bring it all together with relationships.

It would be a great help to analyze a sample database, but Google has not given a useful result. The example database need not necessarily be tailored to classical music, but the principle should resemble my needs, so I can learn about the structure. Where can I find such a download?

I realize that the following is rather loose and that it will show retail issues, but here are my initial thoughts:

Tables:

COMPOSER(s)
- First name
- Surname
- The year of birth
- The year of death
- Country

About birth / death: Accurate data are not always available, especially for early composers. There must be given approximate, but still so that composers can be listed in chronological order.

ARTIST(s)
- First name
- Surname
- Category example. soprano, trumpet player, pianist

ITEM
- Product Name / Title
- Catalog Number
- Barcode (with validation)
- Purchase price
- Wholesale price
- Retail price
- Release date
- Genre (classical, jazz, traditional etc.)
- Category (orchestral music, chamber music, opera etc.)
- Media (1 CD, 2 SACD, 1 CD + 1 DVD etc.)

RECORD COMPANIES
- Name
- Account number
- Supplier

Link to comment
Share on other sites

Based on your description, I would expect to see something like:

MusicLibrary.png.f152395fabe6b198dc64f62d7a1d26f8.png

The Composers and Performers tables could be possibly united into single Artists table, albeit retaining its dual role.

If you have duplicate performances on different media, then you may need another join table of Tracks in-between Performances and Media.

Link to comment
Share on other sites

I'm sorry, Comment. I have once again managed to express myself unclear, although I myself think that I make a great effort not to do so.
I see your sketch as a structure to a record collection. I ask, however, as representant of company selling music on disc media, and it is in this light my structure scetch must be seen.

Link to comment
Share on other sites

This topic is 2576 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.