Reference no: EM132495561

FIT9132 Introduction to Databases - Monash University

Assignment - Conceptual Model - Monash Art Union (MAU)

Monash Art Union (MAU) is a company which accepts artworks from artists and offers these artworks to galleries around the country for display and potential sale. The galleries display the artworks supplied by MAU as part of their exhibitions. A registered MAU customer may, while the artwork is being displayed, decide to purchase the item. MAU charge a standard percentage of the price at which the artwork is sold as their commission (note this does not need to be recorded as part of the model). The gallery is paid a standard percentage of the sale price as its commission, this percentage is negotiated per gallery and so may vary from gallery to gallery (this gallery percentage must be recorded as part of the model). The remainder of the sale price goes to the artist.

MAU assign an artist code to each artist which the company represents. MAU record the artist's name, their contact address and telephone number (not all artists supply a telephone number). When an artist has completed an artwork which they wish to sell through MAU, they contact the company and offer the work to be sold by MAU. MAU maintain for each artist the number of works which MAU currently hold in stock for that artist.

All artworks accepted by MAU are assigned an artwork number specific to a particular artist. For example artist 1234 will have artworks 1, 2, 3 etc and artist 4567 will also have artworks 1, 2, 3 etc. The title of the artwork, the date the work was accepted into the MAU system and the minimum price at which the artist is prepared to sell their work are recorded. The work may be sold for any price above this such that the artist receives at least this minimum amount and the gallery and MAU commission requirements are satisfied. A particular item may be classified as a parent style such as "Chinese Art" or one of the child styles of Chinese Art such as "Ink and Wash Painting" (only one such style is attached to each artwork). MAU wish to be able to determine the parent style for any child style MAU have in their system.

Task to complete:

Using LucidChart, prepare a FULL conceptual model (Entity Relationship Diagram) using crow's foot notation for the Monash Art Union (MAU) described above.
• For this FULL conceptual model, include:
? identifiers (keys) for each entity
? all required attributes, and
? all relationships. Cardinality (min and max) and connectivity for all relationships must be shown on the diagram.
• Surrogate keys must not be added to this model.

Attachment:- Introduction to Databases - Case Study.rar