Preview

Lyric Music Description

Satisfactory Essays
Open Document
Open Document
309 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Lyric Music Description
Lyric Music
Lyric Music is an e­commerce company that provides web services to music artists. Among its services are offering mp3 and Real A udio files for download, selling CDs, and developing promotional materials for artists.

Lyric Music Data
A database can be described in more than one way. One technique is to simply list the rows and columns of each table. These are shown below.

Artists
The Artists table holds information about each artist. An artist could be a band or group. It could also be a solo artist.

Members
The Members table holds information about the individuals who are members of each artist group. See the table on the facing page.

XrefArtistsMembers
An artist (band) may have several members. But also a member may be part of more than one artist group. For instance Band X may have four members, one of whom also works as a solo artist. A cross­reference (xref ) table is needed to maintain this complex relationship between artists and members. XrefArtistsMembers is that table. Its primary key is a combination of
MemberID and ArtistID, so it can match any artist with any member and vice­versa. The
RespParty is a Yes/No field that identifies which of each artist’s members is the person responsible for paying bills and receiving official correspondence from Lyric Music.

Titles
The Titles table tracks information on each CD title produced by each artist. ArtistID is a foreign key that relates this table to Artists.

Tracks
Each CD title can have multiple tracks. The primary key of this table is the combination of
TitleID and TrackNum. The mp3 and RealAud fields are Yes/No fields that indicate whether that track is available in mp3 or Real Audio formats.

Genre
Each title is classified according to its genre. The Genre table is a simple look­up table that lists the valid genres.

You May Also Find These Documents Helpful

  • Satisfactory Essays

    3. Analyze or determine the year of release for all CD’s or DVD’s in collection.…

    • 137 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Your choices for the attributes for each table are shown below. The listing of "correct" choices is based on using all…

    • 1302 Words
    • 11 Pages
    Good Essays
  • Satisfactory Essays

    Econcon

    • 374 Words
    • 2 Pages

    Consumers have all different tastes of music; therefore producers produce CD’s of various genres. This way, consumers influence the production of CD’s.…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Answer: The band is a group of ‘friends’ who can’t play and merely pretend to be rock musicians. The most unlikely of the four is the only true musician whereas the others are merely acting the part.…

    • 565 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Band vs. Orchestra

    • 578 Words
    • 3 Pages

    Smaller groups of 50 or less are called chamber orchestras, but are not as common as full symphonies. The word “orchestra” can also be used in a less formal way such as the Ukulele Orchestra of Great Britain. Concert bands can be broken into many subcategories such as marching band, jazz band, symphonic band, and no matter how many members there are in the band, the name does not change.…

    • 578 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Add a further field, of your choosing, to the Track class, and provide accessor and mutator methods to query and manipulate it. Find a way to use this information in your version of the project; for instance, include it in a track’s details string, or allow it to be set via a method in the MusicOrganizer class.…

    • 341 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Marching Band

    • 322 Words
    • 2 Pages

    -For each instrument, there is at least one section leader. Since they are our friends or we have the same classes, we…

    • 322 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    References: Music. (2011). (E. B. Company, Producer, & Merriam-Webster, Incorporated) Retrieved October 27, 2011, from Merriam-Webster Dictionary: http://www.merriam-webster.com/dictionary/music…

    • 798 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Title: The title appears on the title page with the student 's name, course number,…

    • 1274 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    The music industry consists of the companies and individuals that make money by creating and selling music. In today’s world a large majority of music market for recorded music is controlled by three major companies. They are; French-owned Universal, Japanese owned Sony, and the US owned Warner Music. There are still music companies but those companies mostly independent. In live music, the market’s huge piece controlled by Live Nation.…

    • 529 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Terms of Reference

    • 893 Words
    • 4 Pages

    Once this website has been designed, implemented and tested, users should be able to view a catalogue of CD's/Music from a variety of Asian music genres. The website will also allow users to search for music on the website by entering their specific criteria and then the application displaying the results if any. Users will be able to search through search tab that will match criteria against attributes such as artist names, album titles, track titles and music genres too. In more general terms the user will be allowed to navigate around the website, listen to samples of audio and purchase music in either or both of the procedures mentioned above.…

    • 893 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Whereas there may be more than one way of classifying titles, here we classify them on the basis of their structure. Classified thus, titles fall into five categories: (i) indicative titles; (ii) informative or declarative titles; (iii) question titles; (iv) hanging titles; and (v) series titles, with main title and sub-title.…

    • 2353 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Lyrics as a Genre

    • 619 Words
    • 3 Pages

    Lyric derives from the Greek word λυρικός lyrikos, meaning "singing to the lyre". A lyric poem is one that expresses a subjective, personal point of view.…

    • 619 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Ecommerce

    • 314 Words
    • 2 Pages

    stored in two separate library files. The first is a binary file called iTunes Library and it uses a proprietary file format ("ITL"). It caches information like artist and genre from the audio format's tag capabilities (the ID3 tag, for example) and stores iTunes-specific information like play count and rating. iTunes typically reads library data only from this file. The second file, iTunes Music Library.xml, is refreshed whenever information in iTunes is changed. It uses an XML format, allowing developers to easily write applications that can access the library information (including play count, last played date, and rating, which are not standard fields in the ID3v2.3 format). Apple's own iDVD, iMovie, and iPhoto applications all access the library…

    • 314 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    search engine

    • 1128 Words
    • 5 Pages

    Title is defined for every page so that the users understand why that particular page is being used for. A tag is placed in the tag of every HTML document so that all the pages have a definition specified to them. These titles usually appear at the top of the page and also show up when we search for that particular topic. The title may contain the name of the website along with a few bits of information like the purpose of website, address etc. The title which can be specified for the website we are developing will be bricks and Mortar, Construction material etc. These titles will play an important role for the search engine to find the website.…

    • 1128 Words
    • 5 Pages
    Powerful Essays