Consider the following assumptions: • A music company offers three types of music genres: Jazz, Hip-hop, and Metal (subtypes of the Genre supertype). An “Artist” instances “Records” of these Genres. • There are total of 8,000 songs in company’s database, which can be categorized per the Genres’ subtypes: 30 percent being Jazz, 45 percent Hip-hop, and 55 percent Metal. •

Chapter 8, Review question #64

Consider the following assumptions:

• A music company offers three types of music genres: Jazz, Hip-hop, and Metal (subtypes of the Genre supertype). An “Artist” instances “Records” of these Genres.

• There are total of 8,000 songs in company’s database, which can be categorized per the Genres’ subtypes: 30 percent being Jazz, 45 percent Hip-hop, and 55 percent Metal.

• There are 250 artists. On average, each artist instances 10 records, yielding a total of 2,500 records.

• On average, genres are accessed 10,000 times per hour across all applications.

• Direct access reported for subtypes is 2,000 times for Jazz; 1,500 times for Hip-hop; and 3,500 times for Metal.
• For the Metal genre, out of the 8,000 instances of access, 6,000 times are for Records, and 3,500 subsequent instances of access are for Artist. Similarly, from 9,000 total access instances to Artist, 3,000 were for Records and 3,000 for Metal.

This problem has been solved!


Do you need an answer to a question different from the above? Ask your question!
Related Book For answer-question

Modern Database Management

13th Edition

Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman

ISBN: 9780134773650