Develop the erd for given problem

Assignment Help Database Management System
Reference no: EM13876036

Question: An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight.

A work of art is developed by an artist, but the artist for some works is unknown. An artist is described by an artist ID (identifier), name, date of birth, and date of death (which is null for still living artists). Only data about artists for works currently owned by the museum are kept in the database.

At any point in time, a work of art is either on display at the museum, held in storage, away from the museum as part of a traveling show, or on loan to another gallery. If on display at the museum, a work of art is also described by its location within the museum.

A traveling show is described by a show ID (identifier), the city in which the show is currently appearing, and the start and end dates of the show.

Many of the museum works may be part of a given show, and only active shows with at least one museum work of art need be represented in the database. Finally, another gallery is described by a gallery ID (identifier), name, and city.

The museum wants to retain a complete history of loaning a work of art to other galleries, and each time a work is loaned, the museum wants to know the date the work was loaned and the date it was returned. As you develop the ERD for this problem, follow good data naming guidelines

Reference no: EM13876036

Questions Cloud

Analyze the validity of four scorecard measures of the bsc : Analyze the validity of the four scorecard measures in the customer perspective of the BSC; here validity means that the BSC measure contributes to an increase in sales over the prior quarter. What conclusions can you draw from your analysis?
Describing the steps the program will perform : An algorithm in pseudocode describing the steps the program will perform. This pseudocode algorithm would consist of a list of steps explaining the sequence of tasks the program will follow to complete the task
Problem regarding the constant deceleration : Automobiles A and B are traveling in adjacent highway lanes and at t = 0 have the positions and speeds shown. Knowing that automobile A has a constant acceleration of 0.6 m/s2 and that B has a constant deceleration of 0.4 m/s2, determine
Identify someone who exemplifies servant leader traits : In three pages, please identify someone who exemplifies servant leader traits. (an example is Harriet Tubman). Please use three resources.
Develop the erd for given problem : An art museum owns a large volume of works of art. Each work of art is described by an item code (identifier), title, type, and size; size is further composed of height, width, and weight.
What are the points of risk or challenge : What are the points of risk or challenge about which the board and executives should be aware in making their decisions
Determine when and where vehicles passed each other : Automobile A starts from O and accelerates at the constant rate of 0.75 m/s2. A short time later it is passed by bus B which is traveling in the opposite direction at a constant speed of 6 m/s. Knowing that bus B passes point O 20 s after automobi..
Influence the conduct of monetary policy : Ways the regional Federal Reserve banks influence the conduct of monetary policy include ______. Criteria for the Fed choosing a policy instrument includes _______. Standard accounting principles help financial markets work more efficiently by ______..
Angular velocity of the rectangular plate : At the instant shown, bar DE has a constant angular velocity of 35 rad/s clockwise. Determine at that instant (a) The angular velocity of the rectangular plate FBDH,

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd