Scribd
Upload
4 views7 pages

Employee Salary and Department Data

The document contains employee information including names, departments, salaries, and department heads, organized in various formats. It also includes data on books, their authors, and associated points, along with records of taken and brought dates. Additionally, it outlines the normalization of data into First, Second, and Third Normal Forms.

Uploaded by

Zion Santos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4 views7 pages

Employee Salary and Department Data

The document contains employee information including names, departments, salaries, and department heads, organized in various formats. It also includes data on books, their authors, and associated points, along with records of taken and brought dates. Additionally, it outlines the normalization of data into First, Second, and Third Normal Forms.

Uploaded by

Zion Santos
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Name Department Salary Department_head

ram,shyam,hari,krishna IT 8000, 1000, 9000,8000 Krishna


kripa,sujan HR 8000, 9000 sujan

Employee
Name Department Salary Department_head
Ram IT 8000 Krishna
Shyam IT 1000 Krishna
Hari IT 9000 Krishna
Krishna IT 8000 Krishna
Kripa HR 8000 Sujan
Sujan HR 9000 Sujan

Employee
ID Name Salary Department_Id
1 Ram 8000 1
2 Shyam 1000 1
3 Hari 9000 1
4 Krishna 8000 1
5 Kripa 8000 2
6 Sujan 9000 2

Employee
ID Employee_Id
1 1
2 2
3 3
4 4
5 5
6 6
Department_Location
Pokhara
Kathmandu

Department_location
Pokhara
Pokhara
Pokhara
Pokhara
Kathmandu
Kathmandu

Department
ID Department_head Department_location Department
1 4 Pokhara IT
2 6 Kathmandu HR
Name
Ram, Hari, Shyam, Krishna

Student
Name
Ram
Hari
Shyam
Krishna

Student
Id
Book Name Points
A Daughter of the Snows,The Freakshow Murders,Hard Times,A Plot for Murder 20,30,40,30

Book Name Points


A Daughter of the Snows 20
The Freakshow Murders 30
Hard Times 40
A Plot for Murder 30

Name
Taken Date Brought Date
5/5/2018,6/6/2018,7/5/2018,6/8/2018 6/5/2018,8/5/2018,9/5/2018,10/8/2018

Taken Date Brought Date


5/5/2018 6/5/2018
6/6/2018 8/5/2018
7/5/2018 9/5/2018
6/8/2018 10/8/2018
Name Book Name Page Count Type
Jack, Isaac,Ruth,Frederic A Daughter of the Snows199,298,90,321 Guide,Journals,Diaries,Guide

First Normal Form


Author
Name Book_Name Page_Count Type
Jack A Daughter of the Snows 199 Guide
Isaac Hard Times 298 Journals
Ruth A Plot for Murder 90 Diaries
Frederic A Modern Instance 321 Guide

Second Normal Form


Author Book
Id Name Id Book_Name
1 Jack 1 A Daughter of the Snows
2 Isaac 2 Hard Times
3 Ruth 3 A Plot for Murder
4 Frederic 4 A Modern Instance

Third Normal Form


Author Book
Id Name Id Book_Name
1 Jack 1 A Daughter of the Snows
2 Isaac 2 Hard Times
3 Ruth 3 A Plot for Murder
4 Frederic 4 A Modern Instance
Page Count Type Author_ID
199 Guide 1
298 Journals 2
90 Diaries 3
321 Guide 4

Type
Page Count Type Author_ID Id Type
199 1 1 1 Guide
298 2 2 2 Journals
90 3 3 3 Diaries
321 1 4

You might also like