Suppose you are designing a database for an art museum that owns a large volume of works of art. Each work of art is described by a unique item code, a title, a type, and a size. The 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 a unique artist ID, a name, a date of birth, and possibly a date of death. Data are maintained about an artist only if that artist has works currently owned by the museum. 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 unique show ID, 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 are to be represented in the database. Finally, another gallery is described by a unique gallery ID, its name, and its city. The museum wants to retain a complete history of lending for each work of art to other galleries, and, for each time a work is lent, the museum wants to know the date the work was lent and the date on which it was returned. Drawing manually (but neatly, in pencil), try to construct an E-R diagram for this database.

Posted Date: 2/23/2012 12:45:51 AM | Location : United States

Ask an Expert

Related Discussions:- Database management, computer science, Assignment Help, Ask Question on Database management, computer science, Get Answer, Expert's Help, Database management, computer science Discussions

Write discussion on Database management, computer science
Your posts are moderated

Write your message here..

Related Questions

Multi-valued attribute dbms, Multi-valued Attribute DBMS Each multi valued ... Multi-valued Attribute DBMS Each multi valued attribute maps into a separate table. Include also an attribute for the primary key of the entity and relationship type which the attr

Briefly explain main parts of the camera, Question 1 Briefly explain main ... Question 1 Briefly explain main parts of the Camera Question 2 Write a note on: Ripple Edit Tool, Rate Stretch Tool & Track Selection Tool Question 3 What is Pixel

Program and programming language, Program and Programming Language : ... Program and Programming Language : A Program is defined as a collection of statements/ instructions that enable the computer to solve a problem. The process of writing a prog

Central processing unit, Central Processing Unit: A Central Processing... Central Processing Unit: A Central Processing Unit (CPU) in a computer system is an extremely fast device as compared to the main memory, but it can not work on its own. It de

C++, how to use expressions in c++ program with examble how to use expressions in c++ program with examble

Cpu modes of operation, fully detailed of cpu modes of operation fully detailed of cpu modes of operation

Output design, Discuss the factors considered during output design Discuss the factors considered during output design

Artificial intelligence-environments, Artificial Intelligence-Environments ... Artificial Intelligence-Environments   We have seen that intelligent agents should take into description sure information when   choosing  a rational act,  including inform

What is deadlock ?Differentiate two types of resources ?, • A set of proce... • A set of process is in a deadlock state if each process in the group is waiting for an event that can be caused by only another process in the set. In other words, each member of

Write a note on dect, Question 1 Explain Tropospheric Refraction Qu... Question 1 Explain Tropospheric Refraction Question 2 Write a note on DECT Question 3 Explain mobile integrated radio systems (MIRS) Question 4 What are ap