Although you dream to become and artist, you have been successful at being an expert on database. Your old love is still present, however, so you set up an ArtDistrict database company that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. The following information describes the situation that the AtDistrict database must model: Artists are identified by their unique names, birthplaces, birthdate, age, and style of ant An artist may have more than one style of art For each artwork, the artist, the year it was made, its unique title, its type of art (e.g. painting, lithograph, sculpture, photograph), and its price must be stored. Each artwork is classified into groups of various kinds (e.g. portraits, landscapes). A given artwork may belong to more than one group. Each group is identified by a unique name. The group landscapes must have at least 5 artworks. Galleries keep information about customers such as their name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer likes. The name includes first name, last name, and middle initial. Some of the customers do not have a middie name. When a customer purchases an artwork, the purchase date and the payment method (e.g. visa, mastercard, american express, paypa) are stored. . rtDistrict database. Your EERD must be By hand, draw an EER diagram in 3NF for A included in this document (insert->pictures->browse for the image file). Be sure to indicate the following: a. [5 points] Indicate the name of the schema b. [10 points] Indicate all participating entities c. [10 points] Indicate all attributes constraints d. [10 points] Indicate all relationships between the participating entities identified in b. e. [10 points] Indicate all cardinality and participation constraints f. [10 points) Respect EERD Chen's notations g 15 points) EERD is in 3NF. Explain any changes that you had to make Although you dream to become and artist, you have been successful at being an expert on database. Your old love is still present, however, so you set up an ArtDistrict database company that builds a product for art galleries. The core of this product is a database with a schema that captures all the information that galleries need to maintain. The following information describes the situation that the AtDistrict database must model: Artists are identified by their unique names, birthplaces, birthdate, age, and style of ant An artist may have more than one style of art For each artwork, the artist, the year it was made, its unique title, its type of art (e.g. painting, lithograph, sculpture, photograph), and its price must be stored. Each artwork is classified into groups of various kinds (e.g. portraits, landscapes). A given artwork may belong to more than one group. Each group is identified by a unique name. The group landscapes must have at least 5 artworks. Galleries keep information about customers such as their name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer likes. The name includes first name, last name, and middle initial. Some of the customers do not have a middie name. When a customer purchases an artwork, the purchase date and the payment method (e.g. visa, mastercard, american express, paypa) are stored. . rtDistrict database. Your EERD must be By hand, draw an EER diagram in 3NF for A included in this document (insert->pictures->browse for the image file). Be sure to indicate the following: a. [5 points] Indicate the name of the schema b. [10 points] Indicate all participating entities c. [10 points] Indicate all attributes constraints d. [10 points] Indicate all relationships between the participating entities identified in b. e. [10 points] Indicate all cardinality and participation constraints f. [10 points) Respect EERD Chen's notations g 15 points) EERD is in 3NF. Explain any changes that you had to make