Microsoft Access - Relationships

Based on the information given, please complete task 4 below.

----------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------

TASKS:

1. Draw an Entity Relationship Diagram (ERD) with all related attributes- to represent the conceptual model for the art collection database at Universal Museum.

2. Translate this ERD into a Relational Data Model.

3. Create a Data Dictionary for this database.

4. Use Microsoft Access to implement this database, how does the Access Relationship Window look like?

Universal Museum 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.) Universal Museum 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.)