This is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this company so that they won't be retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Code Project Project Employee Employee Department Department Hourly Project Manager Budget Name Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Attendance Mr. Rajesh 710700 S137 No. Name No. Rate PC010 120500 S100 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 PC011 Mrs. Charu 500500 s103 Pavan D03 Database Testing 18.50 PC011 Mrs. Charu 500500 s104 Jitendra D02 Pooja 17.00 23.50 PC011 Mrs. Charu 500500 S315 D01 IT PC012 Rahul D03 Database 21.50 System Attendance PC012 Mr. Rajesh 710700 S218 Avneesh D02 Testing 15.50 System Attendance PC012 Mr. Rajesh 710700 S109 Vikas D01 IT 20.50 System

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
This is a simple list table of a company trying to keep track of employee assignment to company
protects (In other words, not a database but a flat one table file). You will design a database for this
company so that they won't be retying on a simple I table list system to keep track of their data
Looking at the table below, produce the 3Nf of the data
Normalize to the first three normal forms
Project
Project
Project
Project Employee Employee Department Department Hourly
Manager Budget
Name
Reservation Mr. Ajay
System
Reservation Mr. Ajay
System
Reservation Mr. Ajay
System
HR System
HR System
HR System
Code
Budget
No.
120500 S100
Name
No.
Name
Rate
PC010
Mohan
D03
Database
21.00
PC010
120500 S101
Vipul
D02
Testing
16.50
PC010
120500 S102
Riyaz
D01
IT
22.00
500500 S103
500500 S104
500500 S315
710700 S137
PC011
Mrs. Charu
Pavan
D03
Database
18.50
Jitendra
Pooja
PC011
Mrs. Charu
D02
Testing
17.00
PC011
Mrs. Charu
D01
IT
23.50
PC012
Attendance
Mr. Rajesh
Rahul
D03
Database
21.50
System
Attendance
PC012
Mr. Rajesh
710700 S218
Avneesh
D02
Testing
15.50
System
Attendance Mr. Rajesh
PC012
710700 S109
Vikas
D01
IT
20.50
System
Transcribed Image Text:This is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this company so that they won't be retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Project Project Project Employee Employee Department Department Hourly Manager Budget Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Code Budget No. 120500 S100 Name No. Name Rate PC010 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 500500 S103 500500 S104 500500 S315 710700 S137 PC011 Mrs. Charu Pavan D03 Database 18.50 Jitendra Pooja PC011 Mrs. Charu D02 Testing 17.00 PC011 Mrs. Charu D01 IT 23.50 PC012 Attendance Mr. Rajesh Rahul D03 Database 21.50 System Attendance PC012 Mr. Rajesh 710700 S218 Avneesh D02 Testing 15.50 System Attendance Mr. Rajesh PC012 710700 S109 Vikas D01 IT 20.50 System
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Types of Database Architectures
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education