Normalize model for an artist music records... Does my model makesmake sense?
I want to make a database about one artistartist's music records... CD, Vinyl, Cassette, 8 Track, Singles, Ep, Lp, etc...
I
I believe iI have a good normalizenormalized model that will achieve my need... Butneeds, however before starting creating the dbdatabase, iI want to ask the experts so that my model is solid from the start.
Here are some models that imI'm looking to implement:
Basically, there are albums that contain discs that contain tracks. 1 1 album can have multiple discs and 1 disc can only be part of one album. 1 1 disc can have multiple tracks and 1 track can be in multiple discdiscs.
This is a basic normalizenormalized model iI came up with. Is this a good fundationfoundation? Any remarks, tips, etc...
Thanks in advance,
Marco
Normalize model for an artist music records... Does my model makes sense?
I want to make a database about one artist music records... CD, Vinyl, Cassette, 8 Track, Singles, Ep, Lp, etc...
I believe i have a good normalize model that will achieve my need... But before starting creating the db, i want to ask the experts so that my model is solid from the start
Here are some models that im looking to implement:
Basically, there are albums that contain discs that contain tracks. 1 album can have multiple discs and 1 disc can only be part of one album. 1 disc can have multiple tracks and 1 track can be in multiple disc.
This is a basic normalize model i came up with. Is this a good fundation? Any remarks, tips, etc...
Thanks in advance,
Marco
Does my model make sense?
I want to make a database about one artist's music records... CD, Vinyl, Cassette, 8 Track, Singles, Ep, Lp, etc...
I believe I have a good normalized model that will achieve my needs, however before creating the database, I want to ask the experts so that my model is solid from the start.
Here are some models that I'm looking to implement:
Basically, there are albums that contain discs that contain tracks. 1 album can have multiple discs and 1 disc can only be part of one album. 1 disc can have multiple tracks and 1 track can be in multiple discs.
This is a basic normalized model I came up with. Is this a good foundation?