1 / 7

A Sound Recordings Database Page Recordings Page

This database catalogs sound recordings, tracking physical recordings, musical pieces, performers, and composers. Cross-referencing data is vital, ensuring efficient organization. Query functions allow for easy searches, such as finding recordings by top American orchestras.

tomas
Télécharger la présentation

A Sound Recordings Database Page Recordings Page

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Sound Recordings DatabasePage Recordings Page LIS 7460 Database Concepts & Applications Wayne State University Charles N. Page II 5-1-2009

  2. Objective • This Database is, quite simply a sound recordings catalog. As the following ERD shows, it keeps track of the physical recordings as well as the musical pieces, musicians, and groups include in each recording. • It is important for any catalog such as this to be able to cross-reference the following data: • Recordings and Titles • Musical Pieces • Performers • Composers • This is the main objective of this database.

  3. Track, Performance, and Performpiece entities allow adequate cross-referencing between the main entities of Musician, Group, Piece, and Recording.

  4. Because most recordings contain numerous Composers and/or Performers, entities such as Track and PerformPiece must accommodate duplicate attribute entries. This is necessary for the database to work properly.

  5. Some queries such as this one were created in order to accommodate common searches. This query brings up all recordings made by the "Big Five" American orchestras. (I haven't included any recordings by Boston or Philadelphia yet.)

  6. This report was created to show recordings organized by the principal performer. For example, the first recording is Beethoven Piano Sonatas performed by Vladimir Ashkenazy. If more were availble by Ashkenazy, they would follow.

More Related