Please see attachmentPart 1: In relational database design, the process of organizing data to...

Question

Please see attachmentPart 1: In relational database design, the process of organizing data to minimize redundancy usually involves dividing a database into two or more tables and defining relationships between the tables. In your initial post, list the first three normal forms, and describe the criteria required to satisfy each one of them. Support your analysis with practical examples. Part 2:  Database normalization is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity. Denormalization is the reverse process of the normalization process. Denormalization works by adding redundant data or grouping data to optimize the performance. For this assignment: · Denormalize the following three tables, into one table called tbl_location: · tbl_state contains (state_id,state_name) · tbl_county contains (conty_id,county_name) · tbl_city contains (city_id,city_name). · Discuss the steps you took to create the new tbl_location table and if the new table design increased or decreased the performance of the query. Take a screen shot of the new combined table and attach it (via a Word document) with your response in your initial post.

Ankur · Accepted Answer

Assignment: To discuss and explain database normalisation 
	Requirement Specification: 
1. Database normalisation steps
2. Denormalize a given table stricture
	Application and Implementation:
In order to achieve the above assignment, MySQL database has been used. In order to deformalize, the fields of following tables:
· tbl_state contains
· tbl_county
· tbl_city
have been combined into one single table - tbl_location
querying operations will be efficient till the time records are comparatively less however as the table will start growing, it will result is slow processing. So, its always better to keep the tables in normalised state.
Screenshot:
3 Normal forms
Database normalization is the process of organizing and storing data in tables so that chances of data anomaly and repetitions are reduced and data storage is logical and efficient. To achieve this, Normal Forms are used. Normal forms are sequential steps, that are taken to break a large table into smaller, manageable tables that are associated with each other with the concept of relation. Each normal form must fulfil certain criteria, that are discussed below:
A sample table
	Name
	Address
	Movies on rent
	Salutation
	John
	¼, Brooklyn
	Good will hunting, Avengers, 12 Angry Men, Rambo
	Mr.
	Alice
	2231, Walters
	Seven, Hollow Man
	Ms.
	Roger
	41, 5th Avenue
	Jaws, Jurrasic Park, Anaconda
	Mr.
We can see that movies on rent column has more than one value; now we have to re-arrange this table to 1st normal form.
1st Normal Form
· Each cell of a table shouldn’t contain more than a single value. Only a single value is allowed.

Please see attachment

Answer To: Please see attachment

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment