Purpose
In this Assignment, you will use a dependency diagram to create a sample entity-relationships diagram that models the dependency diagram content in 3rd Normal Form (NF). Additionally, data dictionary and sample data content will be created and included in your Assignment submission.
Assignment Part 1: Create Entity-Relationship (ER) Diagram and Complete Database Design
Dependency Diagram
Based on the dependency diagram below, create an ERD in 3NF.
Normalize the Database Design
You will assert your ER modeled database is normalized to 3rd Normal Form (NF). You will build a data dictionary and then provide sample data. See the Module_4 Database Design Sample for an example of the format for the data dictionary and the sample data.
Part 2: Database Design Update and Normalization Assertion
Assert the modeled database is normalized to 3NF. Use the format given here, substituting rules and what is checked for in place of the items in angle brackets.
Normalization:
1NF –
2NF – No
3NF – No
Part 3: Database Documentation
Define the purpose of each table and provide a data dictionary.
Data dictionary
State the table name and the purpose of the table. Then, in a Microsoft Word table (one Word table for each of your tables; see the IT525 Module 4 Database Design Sample document), give the fields, description of each field, data type of each field (including length for character or decimal fields), whether or not each field allows NULL values, and whether the field is a primary key (or part of a primary key) or is a foreign key. Following is a sample part of a data dictionary for an Apartment table.
Apartment – Describes the apartment.
Field
Description
Data Type
Allow Nulls
Key
ApartmentID
Apartment identifier
Char(1)
No
Primary Key
NumberBedrooms
Number of bedrooms
Integer
No
Not a key
NumberFloors
Number of floors
Integer
No
Not a key
NumberBaths
Number of bathrooms
Decimal(3,2)
No
Not a key
GarageSpace
Which garage space goes with the apartment
Varchar(20)
Yes
Not a key
Part 4: Create Sample Data
Convert the schema into tables within a Word document. Each table should have at least 5 tuples/rows but no more than 10 tuples/rows of example data. Take care that your sample data in each column match the data type specified for that column in your data dictionary. Please ensure that any foreign key values match an existing referenced value.
An example of sample data for a table:
Apartment
AptID
Bedrooms
Floors
Baths
Garage
A
3
1
1.75
West Detached
B
2
2
1.5
Middle Detached
C
2
2
1.5
Middle Detached
D
2
2
1.5
Under Building
E
3
2
1.75
East Detached
Assignment Requirements
Be sure to use appropriate APA format and cite your textbook or other sources that you used in your paper.
The paper should contain sufficient information to adequately answer the questions and contain no spelling, grammar, or APA errors. Points deducted from grade for each writing, spelling, or grammar error are at your instructor’s discretion.
For more information on APA style formatting, go to Academic Writer under Academic Tools of this course.
Also review the university policy on plagiarism. If you have any questions, please contact your instructor.
Directions for Submitting Your Assignment
Compose your Assignment in a Microsoft Word document
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|