Art gallery management system -- 2

Art gallery management system is an application which is used to maintain the information of the gallery. This application allows the artists to showcase their art. Other users can also view the art and know the details of the art like name of the artist, art type, time to which art belonged. A customer can buy the art and the details of the customer purchases along with the contribution and donation is also recorded. Hence the application is used for the management of multiple galleries. The Entities are 1) Artist: The details of the artist are mentioned which contains name, birth place, art type. He can add the art. 2) Guest: The Guest can just view all the art and can know about the details. 3) Customer: Customer can buy or donate to the gallery. 4) Manager: Manager manages the gallery to check the details. 5) Art work: It describes about the art like type of art. 6) Art: Art has the details like size, type, artist, canvas use etc. 7) Gallery: gallery has the art it has a manager and the no of art pieces in it. 8) Exhibition: The events where a gallery or an artist can exhibit their art. 9) Donations: this entity contains the info of all the donations 10) Shipping: Contains all the shipping details Database Qurries are provided to create the table and the data