Can any one now how we solve the question? Please

Advanced Database Design & Implementation First Semester 2017-2018 November 6,2017 Submission Date: November 25, 2017 An Art Museum wants to use a database management system to keep track of information about its collection of items. Assume that the following requirements were collected about the art museum: 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 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