CPT 310 Database Systems and Management Employee Information

Employee Information

CPT 310 Database Systems and Management

Normalizing information is the process of efficiently organizing data in a database (Chapple, 2019). The goal of normalization is to get rid of information that is irrelevant data which could be data that is duplicated throughout the database. You also use normalization to make sure that database only has the information that is needed to be shown within the database. You want to make sure that you are using minimal storage space because when you don’t use this process, you can cause you system to lose vital information that was inside your database.

When normalizing the relational database, the table that is a relation is in 1NF. Each cell can only contain a single value. Every column must be different in the uniqueness of the name, but every entry must be the same kind. Also, no two rows can be the same. The table is two-dimensional with rows and columns. Each row contains data that pertains to some thing or portion of a thing. When you look at the columns, they represent a single attribute of the thing that is being described. Each column below has a unique name and no row is identical.

Empl_ID

Empl_gender

Empl_salary

Empl_Annual_Salary

Depart_Name

Depart_Location

Depart_Head

1

Male

$4,000

$48,000

HR

New York

Chief

2

Female

$3.800

$45,600

Sales

Rhode Island

Executive

3

Female

$2,700

$32,400

Help Desk

Boston

Manager

4

Male

$2,700

$32,400

Help Desk

Boston

Co-Manager

2NF focuses on the removal of duplicating data. As stated earlier in the discussion, the 2NF must meet the requirements of the 1NF. In order to remove duplicating data, the 2NF creates a separate table for the duplicated data. When a new employee is hired to a department, they are then added to the list but in a different table.

Empl_ID

Empl_gender

Empl_salary

Empl_Annual_Salary

Depart_Name

Depart_Location

Depart_Head

1

Male

$4,000

$48,000

HR

New York

Chief

2

Female

$3.800

$45,600

Sales

Rhode Island

Executive

3

Female

$2,700

$32,400

Help Desk

Boston

Manager

4

Male

$2,700

$32,400

Help Desk

Boston

Co-Manager

5

Female

$4,000

$48,000

HR

New York

Sales Chief

6

Male

$3,800

$45,600

Sales

Rhode Island

Co-Executive

3NF will still have anomalies that have been created by problems with keys. Data that doesn't belong in the records will be removed from that table. Breaking the table into two tables solves the transitive dependency issue. The two tables below make up a database that is in the 3NF. Although most relational databases may not move past this normal form, it doesn't hinder the functionality of the database.

Empl_ID

Empl_gender

Empl_salary

Empl_Annual_Salary

1

Male

$4,000

$48,000

2

Female

$3.800

$45,600

3

Female

$2,700

$32,400

4

Male

$2,700

$32,400

Depart_Name

Depart_Location

Depart_Head

HR

New York

Chief

Sales

Rhode Island

Executive

Help Desk

Boston

Manager

Help Desk

Boston

Co-Manager

References

Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management (13th   ed.). Retrieved from https://www.vitalsource.com

Chapple, M. (2019) Database Normalization Basics. Retrieved from https://www.lifewire.com/database-normalization-basics-1019735 

Want latest solution of this assignment

Submit Your Assignment Here

AssignmentHippo Features

On Time Delivery

Our motto is deliver assignment on Time. Our Expert writers deliver quality assignments to the students.

Plagiarism Free Work

Get reliable and unique assignments by using our 100% plagiarism-free.

24 X 7 Live Help

Get connected 24*7 with our Live Chat support executives to receive instant solutions for your assignment.

Services For All Subjects

Get Help with all the subjects like: Programming, Accounting, Finance, Engineering, Law and Marketing.

Best Price Guarantee

Get premium service at a pocket-friendly rate at AssignmentHippo

FREE RESOURCES

  • Assignment Writing Guide
  • Essay Writing Guide
  • Dissertation Writing Guide
  • Research Paper Writing Guide

FREE SAMPLE FILE

  • Accounts
  • Computer Science
  • Economics
  • Engineering

Client Review

I was struggling so hard to complete my marketing assignment on brand development when I decided to finally reach to the experts of this portal. They certainly deliver perfect consistency and the desired format. The content prepared by the experts of this platform was simply amazing. I definitely owe my grades to them.

Tap to Chat
Get instant assignment help