Reference no: EM133422732
Question: A museum has asked for help to design a database to improve their management. They provided a summary of requirements as below.
- An exhibition is identified by its exhibition id. It is characterized by its name, type and duration which consists of start date and end date. The exhibition displays zero or more artworks. Thus, we also need to record the number of artworks displayed.
- An artwork is identified by its artwork id. We record its name, description, type. An artwork is created by at least one artist. An artwork could be displayed at multiple exhibitions. Thus, we also need to store the available status to avoid conflict.
- An artist is identified by its artist id. We also record the name, nationality, and birth year. An artist can create zero or more artworks.
- A manager is responsible for all the management of an exhibition. She/he is identified by the manager id. We also record her/his name, phone number, and multiple emails.
- A manager can manage multiple exhibitions. Each exhibition should be managed by one manager.
- A curator is in charge of the collection of the artworks. She/he is identified by the curator id. We record her/his name, phone number, job type (e.g., full-time, part-time) and employment date. Every curator must be hired by a manager. A manager can hire zero or more curators.
- A curator takes care of multiple artworks. An artwork is handled by at most one curator.
- Some artworks are delicate and fragile. Thus, these artworks need to be packed and transported by a group of special workers. A worker is identified by the worker id. We also record the name, job description of a worker. Note that a worker is only present for the transportation of a specific artwork.
Draw an ER diagram to represent the scenario, clearly state any reasonable assumptions that you choose to make. Reasonable relation names are acceptable
|
Explain with details, relating the scientific facts
: what happens to your body, and why? Remember this is an essay question, so you need to explain with details, relating the scientific facts and vocabulary
|
|
What are the benefits of cloud computing for abc hospice
: Do you believe that ABC Hospice has made the right choice and What is cloud computing - What are the general risks that result from utilizing cloud computing
|
|
Explain the difference between a basic solution and a base
: Explain the relationship between hypotheses and the observations in Step 4 of the scientific method. . Explain the difference between a basic solution
|
|
Write the swot analysis now that you have identified
: Write the SWOT Analysis Now that you have identified the organization you will analyze and complete a SWOT table listing the strengths, weaknesses
|
|
Draw an er diagram to represent the scenario
: Draw an ER diagram to represent the scenario, clearly state any reasonable assumptions that you choose to make. Reasonable relation names are acceptable
|
|
What your considered thought or recommendation might be
: Justify your response. Examine what you have learned in the textbook, online video lessons and provide references, textual quotes and/or links to the materials
|
|
Determine a numeric upper bound for the error
: Determine a numeric upper bound for the error using the Trapezoid error formula by determining the max value in the interval [0,p/2] of the derivative
|
|
Discuss aquinas cosmological proof for the existence of god
: Discuss Aquinas' cosmological proof for the existence of God. According to Aquinas, what do these proofs teach us about God?
|
|
Is the death penalty a morally permissible practice
: Many states and countries have banned the practice. In the assigned reading, Louis Pojman has an interesting defense.
|