Question

Please normalize the following table [example from “Microsoft Office 2010: Advanced (Shelly Cashman Series)]. If you read the textbook carefully, you will be able to normalize this table below. If you properly normalize, you will have two tables as answers.

Client Num	Client Name	Street	City	State	Current Due	Recruiter Number	Last Name	First Name	Commission
AC34	Alys Clinic	134 Central	Berridge	CO	$17,500.00	21	Kerry	Alyssa	$17,600.00
BH72	Berls Hospital	415 Main	Berls	CO	$0.00	24	Reeves	Camden	$19,900.00
BL12	Benton Labs	12 Mountain	Denton	CO	$38,225.00	24	Reeves	Camden	$19,900.00
EA45	ENT Assoc.	867 Ridge	Fort Stewart	CO	$12,750.00	27	Fernandez	Jaime	$9,450.00
FD89	Ferb Dentistry	34 Crestview	Berridge	CO	$12,500.00	21	Kerry	Alyssa	$17,600.00
FH22	Family Health	123 Second	Tarleton	CO	$0.00	24	Reeves	Camden	$19,900.00

Answer 1

Normalization is a method which is used to normalize the puzzled data and organize data into database in a standard way so that users of system can eaily understand the data inside the database. In database data organizes in form of tables and table consists of number of rows and columns. this data is about a specific topic and these tables holds the related data of specific topic. It means that tables used to store the normalized data in the form of rows and columns in the database.

Normalization is an important process in any kind of data storage units, if data is normalized and store in systematic way then it is easy to understand by new users.

Here in this above example: there are two tables are included into one table one table is about the recuiters details and the second table is about the address.

First table recuiters includes columns as: First name , Last name,Recuiter number and current due.

Second table is Address table includes columns name : State,city,street,client number,client name and commision.