Scribd Logo
Upload

Welcome to Scribd!

  • 124 views

    Exercise 1

    Uploaded by

    Lord Genesis
    The document describes a database design problem where a record label wants to store information about musicians, albums, songs, instruments, and places. Key entities are Musician, Album, Song, Place, and Instrument. The relationships are that a musician can play multiple instruments, an instrument can be played by multiple musicians, a song is performed by one or more musicians, a musician can perform multiple songs, an album contains multiple songs but a song is only on one album, and an album has one musician as its producer.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Exercise 1

    Uploaded by

    Lord Genesis
    124 views4 pages
    The document describes a database design problem where a record label wants to store information about musicians, albums, songs, instruments, and places. Key entities are Musician, Album, Song, Place, and Instrument. The relationships are that a musician can play multiple instruments, an instrument can be played by multiple musicians, a song is performed by one or more musicians, a musician can perform multiple songs, an album contains multiple songs but a song is only on one album, and an album has one musician as its producer.

    Original Description:

    ghhahaha

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes a database design problem where a record label wants to store information about musicians, albums, songs, instruments, and places. Key entities are Musician, Album, Song, Place, and Instrument. The relationships are that a musician can play multiple instruments, an instrument can be played by multiple musicians, a song is performed by one or more musicians, a musician can perform multiple songs, an album contains multiple songs but a song is only on one album, and an album has one musician as its producer.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    124 views4 pages

    Exercise 1

    Uploaded by

    Lord Genesis
    The document describes a database design problem where a record label wants to store information about musicians, albums, songs, instruments, and places. Key entities are Musician, Album, Song, Place, and Instrument. The relationships are that a musician can play multiple instruments, an instrument can be played by multiple musicians, a song is performed by one or more musicians, a musician can perform multiple songs, an album contains multiple songs but a song is only on one album, and an album has one musician as its producer.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 4

    EXERCISE 1

    LIGBI ABDUL SAMED BATAMIA

    INDEX NUMBER:4708915

    Notown Records has decided to store information about musicians who perform on its
    albums (as well as other company data) in a database. The company has wisely chosen
    to hire you as a database designer (at your usual consulting fee of $2500/day).
    Each musician that records at Notown has an SSN, a name, an address, and a phone
    number. Poorly paid musicians often share the same address, and no address has more
    than one phone.
    Each instrument used in songs recorded at Notown has a unique identication number, a
    name (e.g., guitar, synthesizer, ute) and a musical key (e.g., C, B-at, E-at).
    Each album recorded on the Notown label has a unique identication number, a title, a
    copyright date, a format (e.g., CD or MC), and an album identier.
    Each song recorded at Notown has a title and an author.
    Each musician may play several instruments, and a given instrument may be played by
    several musicians.
    Each album has a number of songs on it, but no song may appear on more than one
    album.
    Each song is performed by one or more musicians, and a musician may perform a
    number of songs.
    Each album has exactly one musician who acts as its producer. A musician may produce
    several albums, of course.
    Design a conceptual schema for Notown and draw an ER diagram for your schema.

    Solution

    Step 1.

    The entities are Musician, Album, Song, Place, Instrument

    Step 2

    Find the relations


    STEP3:Identify key attribute
    Musician :SSN

    Place: address

    Album: title

    Song: author

    Instrument: name

    STEP4:Identify other relevant attributes

    Musician :m_name , age

    Place: ph.no

    Album: date, format

    Song: s_title

    Instrument: key

    THE ER DIAGRAM

    You might also like