RE: Database Design - Music CD/Tape Library - Opus - com.mysql.lists.win32

11 messages in com.mysql.lists.win32RE: Database Design - Music CD/Tape L...

From	Sent On	Attachments
Ramesh Rao	01 May 2002 10:18
Edward Apostol	01 May 2002 10:28
Ramesh Rao	01 May 2002 10:46
Asendorf, John	01 May 2002 11:32
Ramesh Rao	01 May 2002 11:51
Land, Christopher	01 May 2002 12:23
Ramesh Rao	02 May 2002 09:20
jbon...@sola.com.au	02 May 2002 16:28
Opus	02 May 2002 16:32
Jasiph A.P	03 May 2002 18:45
jbon...@sola.com.au	05 May 2002 16:41

Subject:	RE: Database Design - Music CD/Tape Library
From:	Opus (op...@value.net)
Date:	05/02/2002 04:32:44 PM
List:	com.mysql.lists.win32

If I may add, you probably want to also track the composer info for each song.

A song would be as: Song_ID Title Composer_ID etc...

A performance of that song, would be as such: Performance_ID Song_ID Source_ID Performer_ID Info on the performance

A CD or Tape would be seen as a collection of performances on a media Media_ID Media_Type Media_Title etc.

Tie the performances and the media together with a relationship table. Media_ID Performance_ID Index

This would let you easily have the same performance of a song on many medias, and even have the same performance many times on the same media (?). You can also track where performances are in your collection, and where you copied them from.

The design you decide on will reflect what data you want to track, and how you want to manipulate it.

On 1 May 2002 at 12:24, Land, Christopher wrote:

Perhaps look at the www.FreeDB.org...; and, don't forget www.DataModel.org.

C:~

-----Original Message----- From: Ramesh Rao [mailto:rame...@hotmail.com] Sent: Wednesday, May 01, 2002 11:52 AM To: JAse...@lcounty.com; win...@lists.mysql.com Subject: RE: Database Design - Music CD/Tape Library

John,

Thanks indeed. My main doubt/question you seem to have answered. That is, I need to separate CDs from songs on the CDs.

I will work it out and possibly come back to you if I still have questions..

Thanks again,

Ramesh

From: "Asendorf, John" <JAse...@lcounty.com>

To: Ramesh Rao <rame...@hotmail.com>, win...@lists.mysql.com Subject: RE: Database Design - Music CD/Tape Library Date: Wed, 1 May 2002 14:32:46 -0400

As a guy who designs databases and has a degree in music I might suggest this:

table_CDs CD_ID (primary key) CD_title label

table_performers Performer_ID (primary key) performer_name

table_songs song_ID (primary key) CD_ID song_title performer_ID

You can take it from there...

The key here is to separate the CDs from the songs ON the CDs...

John

--------------------- John Asendorf - jase...@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Nullum magnum ingenium sine mixtura dementiae fuit

-----Original Message----- From: Ramesh Rao [mailto:rame...@hotmail.com] Sent: Wednesday, May 01, 2002 1:19 PM To: win...@lists.mysql.com Subject: Database Design - Music CD/Tape Library

Hi everyone,

I am trying to design a database for Music Cd/Tape library using MySql on Windos NT 4.0 system.

Broadly the information it would contain are:

- Cd/Tape Title - Composer(s) name - Conductor(s) name - Orchestra(s) name - Performer(s) name - Different works on a Cd/Tape - Label Name, year produced - Liner notes etc..

A Cd/tape may contain: - mutliple Composers/Conductors/Performers/works

Can any one suggest table layout/design. I am particulary lost when trying to design, multiple works on a Cd each with different Composer/Conductor/Orchestra.

Experts out there could you help? Or lead me to sites where such info available?

Thanks in advance..

--------------------------------------------------------------------- Please check

"http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail win3...@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.

Dictatorship (n): a form of government under which everything which is not prohibited is compulsory.