Computers and Technology

Create an E-R Diagram for the following: An art museum owns a large volume of works of art. Each work of art is described by an item code, 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 ID, name, date of birth, and date of death (which is null for living artists) is recorded for each artist. Only data about artists for works currently owned by the museum are kept in the database. At any point in time, the status of 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, the art's location within the museum is recorded. If the art work is in storage, storage date and return date from storage are recorded. A traveling show is described by a 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 need be represented in the database. Finally, the museum wants to retain a complete history of loaning a work of art to other galleries; a gallery ID, name, and city are recorded for other galleries. Each time a work of art is loaned, the museum wants to record the date the work was loaned and the date it was returned

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 21:00, depression4eternity
The average cost of one year at a private college in 2012-2013 is $43,289. the average grant aid received by a student at a private college in 2012-2013 is $15,680. โ€ƒ what is the average student contribution for one year at a private college in 2012-2013?
Answers: 3
image
Computers and Technology, 24.06.2019 08:00, ineemorehelp
Arah has entered data about football players from team a and team b in a worksheet. she enters names of players from team a with details about each player in different columns of the worksheet. similarly, she enters details of all the players from team b. which option will her view the data for team a and team b in two separate sections after printing? a. page break view b. freeze pane view c. split screen view d. full screen view e. zoom out view
Answers: 1
image
Computers and Technology, 24.06.2019 15:00, marelinatalia2000
When a presentation is being planned, it is important to ensure that it covers all available information. appeals to the audience. uses multimedia tools. entertains the audience.
Answers: 1
image
Computers and Technology, 24.06.2019 20:00, diangeloortiz
Which element will you include to present numerical on a slide? a: graph b: text c: flowchart d: shapes
Answers: 1
Do you know the correct answer?
Create an E-R Diagram for the following: An art museum owns a large volume of works of art. Each w...

Questions in other subjects:

Konu
Mathematics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
Physics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01
Konu
English, 17.09.2020 14:01
Konu
Mathematics, 17.09.2020 14:01