Answered step by step
Verified Expert Solution
Question
1 Approved Answer
THIS IS QUESTION 3: THIS ARE THE INSTRUCTIONS BELOW: Create a Data Dictionary for this database. Universal Museum has a large collection of art objects
THIS IS QUESTION 3:
THIS ARE THE INSTRUCTIONS BELOW:
Create a Data Dictionary for this database.
Universal Museum has a large collection of art objects from all over the world. In order to manage this collection of valuable art objects efficiently, the management of Universal Museum considered of hiring a consulting firm to develop and install a database application The database should contain information about different art collections, specific art objects in the collections, ownership of the objects, the artists who created them, the curators who look after them, insurance contracts for these art objects. Following are requirements for this database Each art object of the museum is part of a specific collection. An art collection has an identification number, a theme, and the display location. A number of characteristics of a specific art object in a collection are kept in the database. An art object has an identification number and a title. Its value and creation date are also specified in the database The artist who created the art object(s) is also represented in the database. An artist has an identification number, and his/her name year of birth, country of origin (For an antique object, the name of the artist will be the name of country of origin.) Page 1 of3 The museum sometimes borrows art objects from other institutions / estates for special exhibitions, then information of the lender is kept in the database. The borrowing date and returning date are recorded The database keeps information about the curators who look after the art objects. Information on curator includes identification number name, office location and his/her pager number. Each curator is responsible for many art objects. One of the curators is assigned as the supervisor of a specific collection. All the art objects (owned as well as borrowed) in the museum are insured. The database contains information about the insurance companies including the company name, address, and phone number. It is noted that a company may provide insurances for many art objects of the museum. Due to its high value, an art object could be insured by many insurance companies. Information on insurance contract such as insured value, premium paid, and expiration date are kept in the databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started