Customer Service Chat
Get quote & make Payment
Database management, computer science, Basic Computer Science
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
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..
Education and society, mention the aims of education in present scenario
mention the aims of education in present scenario
Drawing Karnaugh Maps, Where can I get free software for drawing K maps
Where can I get free software for drawing K maps
Excell, grades computation
Read world population data file. store the values in multipl, Read World Po...
Read World Population Data File. Store the values in multiple vectors. Sort them by most populated region and output the results ext file is here : please">http://www.csupomona.
Data autonomous transmission, DATA AUTONOMOUS TRANSMISSION: This could ...
DATA AUTONOMOUS TRANSMISSION: This could be the possible replacement for the ARINC 429 standard and will be annotated the standard - ARINC 629. In the DATAC system, the contro
Gui design, how to load a video using push button in gui design click
how to load a video using push button in gui design click
Artificial intelligence-intelligence performanc of computer , "Just how are...
"Just how are we capable to get a computer to performe intelligent tasks?" One thing to answer the question is to tell that: Logic generate a science out of many forms of re
What do you mean by the term "robotics", Question 1 What do you mean by se...
Question 1 What do you mean by semantic networks? Explain inheritance in semantic networks Question 2 Explain Partitioned semantic networks with an example Question
Data mining analysis, Using Weka 3.6 (basketball or cloud data set). Using ...
Using Weka 3.6 (basketball or cloud data set). Using the EM clustering method, how many clusters did the algorithm decide to make? If we change from "Use Training Set" to "Percenta
Analogue computers, ANALOGUE COMPUTERS A computer is basically a proble...
ANALOGUE COMPUTERS A computer is basically a problem-solving device. In aircraft radio systems the problem to be solved is concerned with navigation, in that given certain inf
Accounting Assignment Help
Economics Assignment Help
Finance Assignment Help
Statistics Assignment Help
Physics Assignment Help
Chemistry Assignment Help
Math Assignment Help
Biology Assignment Help
English Assignment Help
Management Assignment Help
Engineering Assignment Help
Programming Assignment Help
Computer Science Assignment Help
Why Us ?
~24x7 hrs Support
~Quality of Work
~Time on Delivery
~Privacy of Work
Human Resource Management
Literature Review Writing Help
Follow Us |
T & C
Copyright by ExpertsMind IT Educational Pvt. Ltd.