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.
Step by Step Answer:
Modern Database Management
ISBN: 9780134773650
13th Edition
Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman