Posted: June 7th, 2021

Normalized Database Design Assignment

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

A relational database must be designed and normalized before it can be created, populated with data, and used. Database design depends on the business scenario(s) a database architect needs to model, but all relational database designs benefit from being normalized.
Download and follow the instructions on the Normalized Database Design document. NOTE: See Instructor’s Notes at the bottom of this section for clarification of the University’s requirements for this assignment!

Here’s the crux of the assignment.  
Fill out the last table on page 3 (the one with the UNF, 1NF, 2NF, 3NF headers) by doing the following:
1.   Create an un-normalized list of entities
1.   Identify nouns, which will be potential keys. Any ID numbers that uniquely identify something are potential keys.
2.   Identify repeating values. A class name, for example, may appear numerous times.
3.   Identify unique identifiers for the repeating values.
2.   Convert to 1NF
3.   Convert to 2NF
4.   Convert to 3NF
5.   Identify an appropriate name for the entity that will identify the 3NF column.

No plagiarism APA format Scenario and Normalized Database Design Templet attached

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: