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  identification, an artist (if known), a year (when it was created, if known), a title, an  epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are  classified in the museum in several ways as discussed below:  Arts objects are categorized based on their type. The main types are: painting and  sculpture, plus another type they called “other” to accommodate objects that do not  fall into one of the two main types.   A painting has a paint type (oil, watercolor, etc.), material on which it is draw on  (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.).   A sculpture has a material from which it was created (wood, stone, iron, etc.), height,  weight, and style.   An art object in the other category has a type (print, photo, etc.) and a style.  Art objects are also categorized as permanent collection that are owned by the  museum (which has information on the date acquired, whether it is on display or  stored, and cost) or borrowed, which has information on the collection (from which it  was borrowed) date borrowed, and date returned.  The museum keeps track of artist’s information, if known: name, date of birth, date of  death (if not living), country of birth, epoch, main style, description. The name is  assumed to be unique.    Different exhibitions occur, each having a name, a start date, an end date, and 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, personal, etc.), description, address, phone, and  current contact person.

1.. 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 
identification, an artist (if known), a year (when it was created, if known), a title, an 
epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are 
classified in the museum in several ways as discussed below:

 Arts objects are categorized based on their type. The main types are: painting and 
sculpture, plus another type they called “other” to accommodate objects that do not 
fall into one of the two main types.

  A painting has a paint type (oil, watercolor, etc.), material on which it is draw on 
(paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.).

  A sculpture has a material from which it was created (wood, stone, iron, etc.), height, 
weight, and style.

  An art object in the other category has a type (print, photo, etc.) and a style.

 Art objects are also categorized as permanent collection that are owned by the 
museum (which has information on the date acquired, whether it is on display or 
stored, and cost) or borrowed, which has information on the collection (from which it 
was borrowed) date borrowed, and date returned.

 The museum keeps track of artist’s information, if known: name, date of birth, date of 
death (if not living), country of birth, epoch, main style, description. The name is 
assumed to be unique.

   Different exhibitions occur, each having a name, a start date, an end date, and 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, personal, etc.), description, address, phone, and 
current contact person.