Database Design and ERD Creation

The assignment content discusses the design of a database system for the Washington Contemporary Art Museum, including the selection of primary keys, foreign keys, and other constraints. The database consists of several entities such as 'Art Work', 'Artist', and 'Location' with their respective attributes. The primary key is the 'First Name' of the Artist, while the foreign keys are 'Art Id' and 'Location Id'. The ERD diagram shows the relationships between these entities and their attributes.

Running Head: DATABASE DESIGN AND ERD CREATION 1
Database Design and ERD Creation
DJ Lemak
DBM 380
June 27, 2016
Craig Rose

Running Head: DATABASE DESIGN AND ERD CREATION 2
Memorandum
To: Whom It May Concern
From: DJ Lemak
Date: June 27, 2016
Subject: Database Design and ERD Creation
Introduction
The Washington Contemporary Art Museum has new database system. All the entities
and attributes of this database system are discussed in this paper along with the selection of
primary keys, foreign keys and other constraints related to this database. In a museum where art
work is displayed which is related to an artist who made it and the location of art work is related
to the art.
Entities and Attributes
Following are the details of entities and attributes along with appropriate data type for
each attribute and for its category. Integer data type is chosen for amount and telephone number
attributes. Character data type is chosen for size and section of museum attributes because they
are represented by single character. While String data type is chosen for those text which is of
more than one character. Date data type is used for date attributes like date created, start data and
end date etc. in database.
Entities Attributes Data Types
Art Work Value Integer

Running Head: DATABASE DESIGN AND ERD CREATION 3
Size Small Character
Medium Character
Large Character
Genre Paintings String
Prints String
Photos String
Date Created Date
Art Id String
Artist Name First Name String
Last Name String
Address String
Telephone Integer
Amount of Art Integer
Location Section A Character
B Character
C Character
D Character
Location Side String
Front String
Start Date Date
End Date Date
Location Id String
Primary Key for this database is the First Name of Artist. Because art work is related to
an artist which make that art work. While the foreign keys are Art Id (Which contain the first

Running Head: DATABASE DESIGN AND ERD CREATION 4
name of artist in addition of number of art work of particular artist) and Location Id (Which
contain Art Id in addition of section A, B, C or D).
Constraints
If we use primary key other than this then it is little bit difficult to relate other tables of
art work and location of art work in museum. Primary and foreign key shows practically the
relationship of artwork with artist and artwork with location of museum. An art is made by artist
and when art is displayed in museum then the location has relationship with art work which is to
be displayed at particular location of museum.
ERD Diagram
Below is the detailed ERD diagram for the normalized database of museum. Which show
the entities and their attributes and their relation also.

Running Head: DATABASE DESIGN AND ERD CREATION 5