Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A database of 16th-century European music records what pieces are located in which books, and where. A single book will contain many pages. A given

image text in transcribed

image text in transcribed

A database of 16th-century European music records what pieces are located in which books, and where. A single book will contain many pages. A given musical piece can cover several lines of multiple pages. The Entity-Relationship diagram below shows an attempt to model this situation. (a) This model doesn't allow storing the order or co-ordinates for lines of music on a page, meaning that retrieving all the lines for a given piece will jumble them up. How could this be fixed? (b) Some books are published in tablebook format. These are designed to be placed on a flat table, with multiple performers standing around the book. An example is given below: To add this to our model, we need to resolve two concerns. Firstly, there are multiple instrument or voice parts to a piece. Secondly, the page has regions, each with lines going in different directions. Add these aspects to the model. [8] (c) List the tables, primary and foreign keys for a relational implementation of your modified model. [7] (d) Give a query to list pieces with the total number of lines of music that they occupy. (e) Assess the suitability of this data structure for a relational model, and compare with ONE other database model from the course (XML-based tree database, document database or Linked data graph database)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions