I have most of this project completed, I just need some help with the final. I've created the ER
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
Notice: Undefined index: payment_status in /home/aceyourh/studycourse.fun/wp-content/themes/premier/page-templates/paper-detail.php on line 248
This question was answered on: Oct 14, 2020
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)
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.