Question Details

[solution] »

I have most of this project completed, I just need some help with the final.  I've created the ER


Description

Answer Download


The Question

I have most of this project completed, I just need some help with the final.  I've created the ERD and I believe I have it to 2NF, but I need the 3NF.  It should be an easy task.

Your database project must meet the following assessment requirements:

  • Design a database using professional principles and standards.
  • Provide a logical design of the database. As a part of the design, normalize the database to the 3NF
  • Use Microsoft Visio or another tool to create this diagram to normalize the ERD to third normal form (3NF).

Running head: DATABASE DESIGN AND ERD CREATION Database Design and ERD Creation

 

Robin Mathers

 

Database Concepts

 

BSBB1L8AS8

 

October 03, 2016

 

William McKown 1 DATABASE DESIGN AND ERD CREATION 2 Database Design and ERD Creation MEMORANDUM

 

TO: Art Museum Database Administrator

 

FROM: Robin Mathers

 

DATE: September 26, 2016

 

SUBJECT: Logical Design Database for The Jacksonville Museum of Art Without

 

Normalization

 

CC: William McKown

 

Logical Design

 

This Memo will discuss the new database system at the Jacksonville Museum of Art. It will

 

discuss the entities and attributes as well as the primary keys and foreign keys, and also any

 

constraints of the database. Currently the museum has no way to track their art if it is on loan,

 

and this database will also enable tracking of art pieces.

 

Entities and Attributes

 

Below I?ve listed the entities and attributes as well as the appropriate data type for each function.

 

As you can see, some of them are ?integers? such as Art Work Value and Value of Art. I am

 

using ?characters? for the size value, the section of the library, and phone number. I will be

 

using ?date? for all dates, and ?string? values for inputs where extra data is needed. I wanted to

 

use ?characters? for the telephone numbers in case there was any math done within the database,

 

I didn?t want the phone numbers included in this. Entities

 

Art Work Attributes

 

Value

 

Size Genre Data Types

 

Small

 

Medium

 

Large

 

Paintings

 

Prints

 

Photos Date Created

 

Art Id

 

Artist Name First Name Integer

 

Character

 

Character

 

Character

 

String

 

String

 

String

 

Date

 

String

 

String DATABASE DESIGN AND ERD CREATION

 

Last Name String

 

String

 

Character

 

Integer A

 

B

 

C

 

D Character

 

Character

 

Character

 

Character

 

Date

 

Date

 

String Address

 

Telephone

 

Amount of Art

 

Location Section Start Date

 

End Date

 

Location Id 3 I am using the First Name as the primary key for the artists. My foreign keys are Art ID (which

 

will contain the first name of each artist as well as the number of art works for each artist). I?m

 

also using Location ID as a foreign key because that will have the location of each work of art

 

(Section A, B, C, or D).

 

Constraints

 

?As astounding as this may seem, there's a structure and order to the art world, and to the gallery

 

system in particular; it's a system that's been in place pretty much as long as buying and selling

 

art has been around, and it's not about to change? (Bamberger, 2016, para. 1). Knowing the art

 

world has specific places for each type of art will help not only with location locally and on loan,

 

but also the relationship each museum has with each artist. The Primary and Foreign keys I?ve

 

selected will show these relationships and help the library employees to understand why

 

locations were picked as they were.

 

ERD Diagram

 

This is my ERD Diagram which shows all relationships and attributes, along with all their

 

relations. DATABASE DESIGN AND ERD CREATION 4 DATABASE DESIGN AND ERD CREATION

 

References

 

Bamberger, A. (2016). Navigating the art world. Retrieved from

 

http://www.artbusiness.com/osoquugalsys.html 5

 


Solution details

Solution #000176070

[solution] »

I have most of this project completed, I just need some help with the final.  I've created the ER.zip

Uploaded by: Tutor

Answer rating:

This paper was answered on 14-Oct-2020

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Oct 14, 2020

EXPERT

Tutor

ANSWER RATING

BEST TUTORS

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

STUCK WITH YOUR PAPER?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now