MEDICAL TECHNOLOGY
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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 Instructions
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 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 <The three rules for 1NF should be stated and it should be asserted that these are met by all tables.>
2NF No <state what is checked for> exist in any of the tables.
3NF No <state what is checked for> exist in any of the relations.
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 instructors 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
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds