Database design and erd creation

Assignment Help Database Management System

Reference no: EM13832583

Database Design and ERD Creation

Subject: We will discuss the logical design, data definition and relationship between the tables of database.

Logical Design

A logical design is a conceptual & abstract design. In Logical database, you have deal with only defining the types of information that you need. Basically it is process to define logical relation between entities and attributes.

In our database, we have three table; Art, Artist and Art location and all tables have 4-4 field.

Art table

It contains five fields; Size, Genre, Value, Date Created, ART_ID (a primary key).

Artist Table

It contains five fields: ARTIST_ID (primary key), ART_ID (Foreign key), Name, Address, Telephone, and Amount of Art.

Art Location Table

It contains size fields; ID (PK), Section, Location, Start Date, End Date, and ART_ID (FK).

Data Types for Table

Data types, Key selection the most important things to do in database designing. In our, There are three tables. Data types, key definition of each table are given below:

Art Table

Field	Data Type	Key	Constraint
ART_ID	INT	PK	Auto Increment, Not Null
Size	INT		Not Null
Genre	VARCHAR(40)		Not Null
Value	VARCHAR(40)		Not Null
Date Created	Date/Time		Not Null

Artist Table

Field	Data Type	Key	Constraint
ARTIST_ID	INT	PK	Auto Increment ,Not null
ART_ID	INT	FK	Not null
Name	VARCHAR(50)		Not null
Address	VARCHAR(250)		Null
Telephone	VARCHAR(12)		Not null
Amount of Art	INT		Not null

Art Location Table

Field	Data Type	Key	Constraint
ID	INT	PK	Auto Increment, Not null
Section	VARCHAR(50)		not null
Location	VARCHAR(100)		not null
Start Date	Date/Time		not null
End Date	Date/Time		not null
ART_ID	INT	FK	not null

ERD Diagram

140_ERD Diagram.jpg

The following assignment is based on the database environment designed in the Week Two Individual Assignment.

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).

Reference no: EM13832583

Questions Cloud

Discuss the risk-taking appetite and ability of organization : Discuss the risk-taking appetite and ability of an organization and its importance to an effective risk management program. Identify the key financial and non-financial factors used to determine per-occurrence and aggregate retention amounts.

Law assumes that with no change in unemployment : The version of Okun’s law assumes that with no change in unemployment, real GDP (RGDP) normally grows by 3 percent over a year. If RGDP last year was $12,375 and the unemployment rate fell by 1 percentage point from last year to this year, what would..

Chlorine reacts with potassium bromide to produce potassium : Chlorine reacts with potassium bromide to produce potassium chloride and bromine

Create a new best practice for hr management : Create a list of three best practices recruiters should use when screening potential candidates for a HR management position. Justify your selections. Create a new best practice for HR management based on the information that you learned in this co..

Database design and erd creation : Subject: We will discuss the logical design, data definition and relationship between the tables of database.

Explain the four leadership ethical behaviors : Explain the guidelines in evaluating the ethics of a decision. Use a personal example of an ethical decision that you can relate to the question. Explain the four leadership ethical behaviors. Give an example of each from your personal experience

How dose lock-and-key mechanism relate to hormones : How dose lock-and-key mechanism relate to hormones

What country-specific factors account for the differences : What country-specific factors account for the differences? What impacts would they have on your management operations

Perform a life cycle costing calculation using value method : Perform a Life Cycle Costing calculation using the Net Present Value method to determine its life cycle costs, over a period of 6 years. The vehicle is NOT to be obtained by leasing or by loan.

User Account

All Pages