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
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
CC: William McKown
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
Size Genre Data Types
Photos Date Created
Artist Name First Name Integer
String DATABASE DESIGN AND ERD CREATION
Last Name String
Amount of Art
Location Section Start 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).
?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.
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
Bamberger, A. (2016). Navigating the art world. Retrieved from
Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
About this QuestionSTATUS
Oct 14, 2020EXPERT
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).
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.