Scribd Logo
Upload

Welcome to Scribd!

  • 144 views

    Database Documentation

    Uploaded by

    ward.robyn9323
    The document outlines plans to convert David Adler's vinyl record collection inventory from a flat file WORD document to a relational database. The new database will include more detailed information for each record, allow searches and reports on composers, artists, and owners, and support adding to the collection in the future. Tables will include records, composers, artists, tracks, and owners with linking tables to connect records to other tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Database Documentation

    Uploaded by

    ward.robyn9323
    144 views6 pages
    The document outlines plans to convert David Adler's vinyl record collection inventory from a flat file WORD document to a relational database. The new database will include more detailed information for each record, allow searches and reports on composers, artists, and owners, and support adding to the collection in the future. Tables will include records, composers, artists, tracks, and owners with linking tables to connect records to other tables.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines plans to convert David Adler's vinyl record collection inventory from a flat file WORD document to a relational database. The new database will include more detailed information for each record, allow searches and reports on composers, artists, and owners, and support adding to the collection in the future. Tables will include records, composers, artists, tracks, and owners with linking tables to connect records to other tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    144 views6 pages

    Database Documentation

    Uploaded by

    ward.robyn9323
    The document outlines plans to convert David Adler's vinyl record collection inventory from a flat file WORD document to a relational database. The new database will include more detailed information for each record, allow searches and reports on composers, artists, and owners, and support adding to the collection in the future. Tables will include records, composers, artists, tracks, and owners with linking tables to connect records to other tables.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 6

    LPs Database 1

    LPs Database Design Project

    David Adler, Tyler Kaye, Melissa Ludeman and Robyn Ward

    LI844XO

    Emporia State University


    LPs Database 2

    Mission Statement

    The purpose of the LPs’ database is to provide a searchable inventory of David


    Adler’s music record collection.

    Mission Objectives

    • To provide information about the contents of the collection


    • To provide methods for searching through the collection
    • To provide methods for printing out the collection inventory
    • To distinguish the different parts of the collection
    • To maintain new and existing information

    Analysis of Current Database

    This collection of phonograph records consists of vinyl recordings of various


    genres and types, amassed over the past fifty years by David Adler. Some of these
    recordings may have significant collector value. A portion of the collection was gifted to
    David by his friend Liza Goldblatt, and includes rare recordings of Asian music.

    The current database used to inventory the collection is a flat file WORD
    document that is incomplete, as only Liza’s portion of the collection is represented. The
    database is divided into four parts: classical, jazz/gospel/folk/pop, music of Nepal and
    Tibet, and miscellaneous world music. All the international LPs are listed alphabetically
    by album title, and the rest are listed alphabetically by performing artist. Information
    about each record album currently includes only album title, composer/performing artist,
    record label and label manufacturing number.

    The database needs to be revised into a relational database, reorganized to reflect


    proper cataloging procedures, and updated to include David’s part of the collection and to
    allow for new acquisitions. Provisions for more detailed information about each
    recording needs to be created, as well as provisions for different types of reports and
    database views, so that a more flexible and comprehensive analysis of the collection may
    be done.

    Possible Future Enhancements

    The phonograph collection may be enlarged in the future by additions from other
    people. There should be a way of identifying who owned these additions.
    LPs Database 3

    Types of Reports Needed:

    1) Full listing of phonograph record attributes providing a general description of


    each record element and who owns it. It would include title, genre, name of
    manufacturer label, label number, RPM, how many vinyl disks are in each album
    set, the tracks, artist last name, composer last name, artist group name, owner
    name, number of copies of each title and who owns them, and general comments
    about each recording.

    2) A way of identifying which person owns a specific recording.

    3) A list of recordings that identifies which composers and their works are
    represented in the collection.

    4) A list of recordings that identifies which artists and their works are represented in
    the collection.

    5) A way of identifying the tracks on each phonograph record.

    Views:

    1) Full record for general description of recording elements and ownership.


    Fields include Title, Genre, ComposerID, Composer LastName, ArtistID,
    ArtistGroupName, ArtistLastName, LabelName, LabelNumber, RPM,
    SetNumber, OwnerID, OwnerLastName, Comments.

    2) Owner record for identifying which person owns specific recordings.


    Fields include Title, OwnerID, OwnerLastName.

    3) Composer record to identify which composers and their works are represented in
    the collection.
    Fields include ComposerID, ComposerLastName, Title, Genre, OwnerID,
    OwnerLastName.

    4) Artist record to identify which artists and their recordings are represented in the
    collection. Fields include ArtistID, ArtistGroupName, ArtistLastName, Title,
    Owner ID, OwnerLastName.

    5) Tracks record to identify phonograph record title and the tracks on it.
    Fields include Title, TrackID, and all the track names.
    LPs Database 4

    TABLES:

    Summary:
    Table Name Type Description
    PhonoRecords Data Basic information regarding each title in the
    collection.
    PhonoRecords Linking Connects a title with composer information
    Composers
    PhonoRecords Linking Connects a title with artist information
    Artists
    Composers Data Information regarding the composer associated with
    the title
    Artists Data Information regarding the artist associated with the
    title
    Tracks Subset List of tracks for each side of an album/record
    Owners Subset Specifies the owner of each copy of a title
    LPs Database 5

    TABLES &FIELDS

    PhonoRecords
    Title PK
    Genre
    LabelName
    LabelNumber
    RPM
    SetNumber
    TrackID FK
    OwnerID FK
    Comments

    PhonoRecordsComposers
    Title CPK/FK
    ComposerID CPK/FK

    PhonoRecordsArtists
    Title CPK/FK
    ArtistID CPK/FK

    Composers
    ComposerID PK
    ComposerLastName
    ComposerFirstName
    ComposerMiddleName

    Artists
    ArtistID PK
    GroupName
    ArtistLastName
    ArtistFirstName
    ArtistMiddleName
    ArtistType

    Tracks
    TrackID PK
    SideOneTrackOne
    SideOneTrackTwo
    SideOneTrackThree
    SideOneTrackFour
    SideOneTrackFive
    SideOneTrackSix
    SideOneTrackSeven
    SideOneTrackEight
    LPs Database 6

    SideOneTrackNine
    SideOneTrackTen
    SideTwoTrackOne
    SideTwoTrackTwo
    SideTwoTrackThree
    SideTwoTrackFour
    SideTwoTrackFive
    SideTwoTrackSix
    SideTwoTrackEight
    SideTwoTrackNine
    SideTwoTrackTen
    SideThreeTrackOne
    SideThreeTrackTwo
    SideThreeTrackThree
    SideThreeTrackFour
    SideThreeTrackFive
    SideThreeTrackSix
    SideThreeTrackSeven
    SideThreeTrackEight
    SideThreeTrackNine
    SideThreeTrackTen
    SideFourTrackOne
    SideFourTrackTwo
    SideFourTrackThree
    SideFourTrackFour
    SideFourTrackFive
    SideFourTrackSix
    SideFourTrackSeven
    SideFourTrackEight
    SideFourTrackNine
    SideFourTrackTen

    Owners
    OwnersID PK
    OwnersLastName
    OwnersFirstName
    OwnersMiddleName
    Notes

    You might also like