Question Details

(Solved by Expert Tutors) Example 4.21Design a database to keep track of information for an>


art museum. Assume that the following requirements were collected.?The museum has a collection of ART_OBJECTS. Each art object has a unique IDNo, and Artist, if known, a Year (When created, if known) a Title and a Description. The art objects are categorized in several ways, as discussed below.?ART_OBJECTS are categorized based on types. There are three main types, Painting, Sculpture and Statue, plus an Other category for those that don?t fit into one of the categories above.?A PAINTING has a PaintType (oil, watercolour, etc) a material on which it is drawn (paper, canvas, wood) and Style (modern, abstract, etc)?A SCULPTURE or a STATUE has a Material from which it was created (wood, stone, etc), Height, Weight and Style.?An art object in the OTHER category has a Type(print, photo, etc) and Style.?ART_OBJECTS are also categorized as PERMANENT_COLLECTION, which are owned by the museum (these have information on the DateAcquired, whether it is on display or stored and Cost) or BORROWED which has information on the Collection (where it was borrowed from), Date Borrowed, and Date Returned.?ART_OBJECTS also have information describing their country/culture using information on country/culture of Origin (Italian, Egyptian, American, Indian, etc) and Period (Renaissance, Modern, Ancient)?The museum keeps track of Artist?s information, if known: Name, DateBorn, DateDied, CountryOfOrigin, Period, MainStyle and Description. The name is assumed unique.?Different EXHIBITIONS occur, each having a Name, StartDate and EndDate. EXHIBITIONS are related to all the art objects that were on display during the exhibition.?Information is kept on other COLLECTIONS with which the museum interacts, including Name (unique), Type (museum, personnel, etc), Description, Address, Phone and ContactPerson.Draw an EER schema for this application. Record any assumptions you make.

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Apr 19, 2020

EXPERT

Tutor

ANSWER RATING

YES, THIS IS LEGAL

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now