Given below is a case study for an art museum database. The museum has a collection of ART_OBJECTs.

Given below is a case study for an art museum database. The museum has a collectionof ART_OBJECTs. Each ART_OBJECT has a unique IdNo, an Artist, a Year when itwas created, a Title and a Description. The art objects are categorized in several waysas discussed below. ART_OBJECTs are categorized based on their type. There arethree main types: PAINTING, SCULPTURE and STATUE, plus another type calledOTHER to accommodate objects that do not fall into one of the three main types.