I cannot seem to design...

[Norm]

the database to work like i need it too. I have a music studio and need to catalog my hard drives. I want to be able to enter the drive serial number as the identifier and the drive size then list the artists who have material on the drive. the song name, which pre-masters CD's a particular song is on and which production master used which pre-master. so
single hard driv
multiple artists (via pull down list
single son
multiple pre-masters (via pull down list
single production maste

any helpers
you can reach me at akewldewd at ya hoo if you want to.

 

[Rebecca Riordan]

Does the production master belong to a single song? How do you want to
search the information?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

the database to work like i need it too. I have a music studio and need to

catalog my hard drives. I want to be able to enter the drive serial number
as the identifier and the drive size then list the artists who have material

 

[Rebecca Riordan]

Sorry for taking so long to answer this...I've been out of town.

You're dealing with a number of entities, and you need to identify them and
their relationships separately. You have drives, artists, songs, and
production masters. Each of those have attributes (e.g., a drive has a
serial number). And they have relationships (e.g., many masters on one
drive). Try approaching the problem from that point of view, and see
whether you make progress. (Check back, of course, if you don't <g>)

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

There is I suppose a possibility that a song may appear on more then one

production master. It would be nice to be able to search for a song or via a
master pre or pro master for all the possibilities. the pre master and pro
master would have titles such as artist/ablum so an artist may have several
production masters with various songs on it like say the artist was Jeff and
one pro master was "debut" and the next was "today is the day"