《数据库系统设计》Lab3AdvancedDatabaseDesign.pdf

Lab3 Advanced Database Design Lab3(a): Design 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, an Artist (if known), a Year (when it was 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 their type. There are three main types: PAINTING, SCULPTURE, and STATUE, plus another type called OTHER to accommodate objects that do not fall into one of the three main types.  A PAINTING has a PaintType (oil, watercolor, etc.), material on which it is DrawnOn (paper, canvas, wood, etc.), and Style (modern, abstract, etc.).  A SCULPTURE has a Material from which it was created (wood, stone, etc.), Height, Weight, and Style. And a STATUE has some similar characters.  An art object in the OTHER category has a Type (print, photo, etc.) and Style.  ART_OBJECTs are also categorized as PERMANENT_COLLECTION that are owned by the museum (which has information on the DateAcquired, whether it is OnDisplay or stored, and Cost) or BORROWED, which has information on the Collection (from which it was borrowed), DateBorrowed, and DateReturned.  ART_OBJECTs also have information describing their country/culture using information on country/culture of Origin (Italian, Egyptian, American, Indian, etc.), Epoch (Renai ssance, Modern, Ancient, etc.).  The museum keeps track of ARTIST ’s information, if known: Name, DateBorn,