Prepare a FULL conceptual model (Entity Relationshlp Dlagram) using crow's foot notation for the Monash Art...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Answer rating: 100% (QA)
From the given problem statement the name of the database will be MAU Com... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
Using Crows Foot notation and Visio, draw an Entity Relationship Diagram that captures the business rules given below. For each problem, you will build upon the ERD from the previous problem. As you...
-
Shown here is a partial entity relationship diagram of a purchase system. Describe the business rules presented by the cardinalities in thediagram. ENTITY RELATIONSHIP DIAGRAM Updates Contains...
-
Max Corporation has a wholly owned subsidiary, Min Ltd., which was formed several years ago. Both Max and Min are in the same business, but in different geographic areas. Mins initial capital was...
-
The monochromatic emissivity of a diffuse-surface at 1600 K varies with wavelength in the following manner : = 0.4 for 0
-
Sketch the root locus plot of ms2 + 12s + 10 = 0 for m 2. What is the smallest possible dominant time constant, and what value of m gives this time constant?
-
Explain ways to choose the best words for a business message.
-
Water to run a Pelton wheel is supplied by a penstock of length \(\ell\) and diameter \(D\) with a friction factor \(f\). If the only losses associated with the flow in the penstock are due to pipe...
-
1. How is cultural communication in India similar to that of Europe and North America? How is it different? 2. What kind of managerial relationships could you assume exist between the American...
-
3 6 C C (Simplify your answer. Type a fraction.)
-
Prepare the Annual Reconciliation of Employer Wage Tax for Philadelphia, using the blank. For lines 1, 3, and 4, use gross wages and salaries per general ledger less exempt wages paid to Russell...
-
Suppose we want to generate assembly code for the following C function: int shift_left2_rightn(int x, int n){ x<<= 2; x>>= n; return x; } The code that follows is a portion of the...
-
1. Two cars are meeting at an intersection and want to proceed as indicated by the arrows in the following Figure: Each Driver can proceed or move. If both proceed, there is an accident. A would have...
-
Iodine is sparingly soluble in pure water. However, it does ` dissolve ' in solutions containing excess iodide ion because of the following reaction: I - ( aq ) + I 2 ( aq ) = I 3 - ( aq ) K = 7 1...
-
12. (0 points) Design a 4-bit arithmetic combinational circuit that performs the following operations: Control Inputs M Mo 0 0 0 1 1 1 0 1 if(A/4 = = 0) then S = A + B; else S = A - B if(A
-
Q2 Round trips 10 Points Host A is transferring a file of size S to host B using TCP. A sends the file data in fixed size packets equal to the Maximum Segment Size (MSS), a predetermined value. B...
-
T/F The variance of an asset's return can be less than the standard deviation of that asset's return. If an investor owns two stocks, one whose standard deviation is 0.21 and the other whose standard...
-
Discuss the major differences in how to use QuickBooks to manage recording of sales transactions for a building contractor versus a coffee shop. Explain the key steps involved for each. Examine the...
-
Figure displays a 12.0 V battery 3 four uncharged capacitors of capacitances C1 = 4.00F, C2 = 6.00F, and C3 = 3.00F. The switch is thrown to the left side until capacitor 1 is fully charged. Then the...
-
The maximum weights and mean life expectancies of dogs are shown in Table 16 for various dog breeds. Let L = f (W) be the mean life expectancy (in years) of a dog breed with maximum weight W pounds....
-
Access the data about earthquakes, which are available at MyMathLab and at the Pearson Downloadable Student Resources for Math & Stats website. a. Construct a pie chart of the states where...
-
In 1797, a researcher shot a gun with various amounts of gunpowder and measured the forces of the fired gunpowder (see Table 57). Let y be the force (in newtons) of x milligrams of fired gunpowder....
-
(a) Is the magnitude of the gravitational force exerted by Earth on a ball greater than, equal to, or smaller than the magnitude of the gravitational force exerted by the ball on Earth? (b) Is the...
-
Two objects 1 and 2, of mass \(m_{1}\) and \(m_{2}\), are released from rest far from Earth, at a location where the magnitude of the acceleration due to gravity is much less than \(g=9.8 \mathrm{~m}...
-
A communications satellite orbits \(1.4 \times 10^{7} \mathrm{~m}\) from Earth's center, at a location where the magnitude of Earth's gravitational field is \(2.0 \mathrm{~N} / \mathrm{kg}\). (a) If...
Study smarter with the SolutionInn App