Answered You can hire a professional tutor to get the answer.
You are asked to design a database for art galleries. This database will capture all the information that galleries need to maintain.
You are asked to design a database for art galleries. This database will capture all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. One artist can have different styles of art. For each piece of 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. An artwork can be produced by only one artist. Pieces of artwork are also classified into groups of various kinds, namely, portraits, still lifes, works by Picasso, and works of the 19th century; a given piece can belong to only one group. Finally, galleries keep information about those customers who have bought an artwork. For each customer, galleries keep their unique name, address, and the artists and groups of art that each customer tends to like. Draw the Entity Relationship diagram for the database. Illustrate all entities, attributes, relationships, cardinalities and other constraints.
