Question Details

[solution] »

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


Brief item decscription

Answer Download


Item details:

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

 


Notice: Undefined index: payment_status in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 248






About this question:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Oct 14, 2020

PRICE: $20

Solution~000176070.zip (18.37 KB)

Buy this answer for only: $20

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

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

Notice: Undefined variable: ip_country in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 456

Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

Order Now