Consider the following assumptions: A music company offers three types of music genres: Jazz, Hip-hop, and

Question:

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 9780134773650

13th Edition

Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman

Question Posted: