DBM 380 Database Design Report

This report documents the design of a database for the Washington Contemporary Art Museum. It outlines the entities (Artwork, Artist, Location), their attributes (with specified data types), and the selection of primary and foreign keys to establish relationships between the entities. The report emphasizes the importance of the Artist's First Name as the primary key due to its central role in linking artwork to the artist. Foreign keys, Art ID and Location ID, further define the relationships between artwork and artist, and artwork and location within the museum. Constraints are discussed, highlighting the practical implications of key selection for data integrity and efficient querying. The report concludes with a description of the Entity-Relationship Diagram (ERD) illustrating the database structure.

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