Given below is a case study for an art museum database. The museum has a collection of ART_OBJECTs. Each ART_OBJECT has a unique IdNo, an Artist, a Year when it was created, 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.