Prepare a FULL conceptual model (Entity Relationshlp Dlagram) using crow's foot notation for the Monash Art...

Transcribed Image Text:

Prepare a FULL conceptual model (Entity Relationshlp Dlagram) using crow's foot notation for the Monash Art Union (MAU) described above. • For this FULL conceptual model, include: o identifiers (keys) for each entity o all required attributes, and o all relationships. Cardinality (min and max) and connectivity for all relationships must be shown on the diagram. Surogate keys must not be added to this model. 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. All artworks are assigned a style which represents the style of the work. The artwork styles used by MAU are listed here: https://www.wikiart.org/en/paintings-by-style. 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. Each artwork is also assigned a media description as listed here: https://www.wikiart.org/en/paintings-by-media (only one media description is applied to each artwork). A gallery is identified by a gallery id. MAU record the name of the gallery, the gallery manager's name, the address of the gallery and the contact phone number for the gallery (all galleries are required to provide a contact number). Art collectors who are interested in purchasing an artwork must register with MAU as a customer before they are able to make any purchase. Each customer is identified by their customer id. The customer's name, address and contact phone number are recorded. If the customer is a business customer their business name is also recorded. A gallery considers the artworks which MAU has on offer and then requests and exhibits (displays) the artwork in its gallery with the intention of generating a sale. The date at which the exhibit starts is recorded. If the item generates little interest then the gallery will return the artwork to MAU. At a later date, after it is back at MAU, the gallery might request and display the same artwork again. When an artwork from MAU stock is sold, the sale is assigned a unique sale id. The artwork, date of the sale, sale price and customer who purchased the item is recorded. MAU is interested in identifying which exhibit generates a particular sale. Prepare a FULL conceptual model (Entity Relationshlp Dlagram) using crow's foot notation for the Monash Art Union (MAU) described above. • For this FULL conceptual model, include: o identifiers (keys) for each entity o all required attributes, and o all relationships. Cardinality (min and max) and connectivity for all relationships must be shown on the diagram. Surogate keys must not be added to this model. 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. All artworks are assigned a style which represents the style of the work. The artwork styles used by MAU are listed here: https://www.wikiart.org/en/paintings-by-style. 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. Each artwork is also assigned a media description as listed here: https://www.wikiart.org/en/paintings-by-media (only one media description is applied to each artwork). A gallery is identified by a gallery id. MAU record the name of the gallery, the gallery manager's name, the address of the gallery and the contact phone number for the gallery (all galleries are required to provide a contact number). Art collectors who are interested in purchasing an artwork must register with MAU as a customer before they are able to make any purchase. Each customer is identified by their customer id. The customer's name, address and contact phone number are recorded. If the customer is a business customer their business name is also recorded. A gallery considers the artworks which MAU has on offer and then requests and exhibits (displays) the artwork in its gallery with the intention of generating a sale. The date at which the exhibit starts is recorded. If the item generates little interest then the gallery will return the artwork to MAU. At a later date, after it is back at MAU, the gallery might request and display the same artwork again. When an artwork from MAU stock is sold, the sale is assigned a unique sale id. The artwork, date of the sale, sale price and customer who purchased the item is recorded. MAU is interested in identifying which exhibit generates a particular sale.

Answer rating: 100% (QA)

From the given problem statement the name of the database will be MAU Com... View the full answer