normalize the following Table into 3rd Normal Form.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Q9: You are asked to normalize the following Table into 3rd Normal Form.
position salary Hours
Worked
Staff name
No
$1500 Tom Daneils Supervisor
S0003 Sally Adams Manager
S0010 Mary Martin Analyst
$1500 Tom Daneils
$2250 Robert Chin
S0415 Sally Stern
S3250 Art Peter
S0010 Mary Martin
S0415 Sally Stern
a.
b.
C.
d.
e.
Which of the following relations will NOT be part of the solution in the 3nd
Normal Form?
position
Toy
staffNo
Alien
Alien
Alien
Car
Car
branch No
branch No
staffNo
Products Table
3500 20
Supervisor 4500 24
Manager 5000 11
Engineer 3000 14
4500 30
Supervisor
Analyst
3500 23
Engineer 3000 21
Engine
Engine
4500 12
5000 10
Part
salary
ন
HoursWorked
branchAddress
name
branchTelNo
Branch Branch
No
Address
B001
B001
B001
B004
8Th road, London, UK
8th road, London, UK
8th road, London, UK
5th road, Leeds, UK
Central London, UK
Central London, UK
Avenue, Manch, UK
5th road, Leeds, UK
B002
B002
B003
B004
B003 Avenue, Manch, UK
Q10: Based on the following TWO Tables (Products and Parts), how many
records the below query will return?
head
2
alien body 1
tentacle 10
car body 1
wheel
4
wheel
6
funnel
1
position
Number Colour
branch No
green
purple
green
blue
red
blue
red
SELECT P.TOY, MAX (T. WEIGHT)
FROM PRODUCTS P, PARTS T
WHERE P.PART = T.PART
GROUP BY P.TOY
HAVING MAX (T. WEIGHT) > 60
C. TWO RECORDS
C. THREE RECORDS
branch TelNo
salary
44-456-778, 44-356-356
44-456-778, 44-356-356
44-456-778, 44-356-356
44-999-432, 44-999-111
44-256-654, 44-256-214
44-256-654, 44-256-214
44-566-333, 44-546-343
44-999-432, 44-999-111
44-566-333, 44-546-343
Parts Table
Part
Weight
tentacle 15
alien body 75
wheel
25
car body 60
funnel
20
head
40
b. ONE RECORD
d. FOUR RECORDS
Transcribed Image Text:Q9: You are asked to normalize the following Table into 3rd Normal Form. position salary Hours Worked Staff name No $1500 Tom Daneils Supervisor S0003 Sally Adams Manager S0010 Mary Martin Analyst $1500 Tom Daneils $2250 Robert Chin S0415 Sally Stern S3250 Art Peter S0010 Mary Martin S0415 Sally Stern a. b. C. d. e. Which of the following relations will NOT be part of the solution in the 3nd Normal Form? position Toy staffNo Alien Alien Alien Car Car branch No branch No staffNo Products Table 3500 20 Supervisor 4500 24 Manager 5000 11 Engineer 3000 14 4500 30 Supervisor Analyst 3500 23 Engineer 3000 21 Engine Engine 4500 12 5000 10 Part salary ন HoursWorked branchAddress name branchTelNo Branch Branch No Address B001 B001 B001 B004 8Th road, London, UK 8th road, London, UK 8th road, London, UK 5th road, Leeds, UK Central London, UK Central London, UK Avenue, Manch, UK 5th road, Leeds, UK B002 B002 B003 B004 B003 Avenue, Manch, UK Q10: Based on the following TWO Tables (Products and Parts), how many records the below query will return? head 2 alien body 1 tentacle 10 car body 1 wheel 4 wheel 6 funnel 1 position Number Colour branch No green purple green blue red blue red SELECT P.TOY, MAX (T. WEIGHT) FROM PRODUCTS P, PARTS T WHERE P.PART = T.PART GROUP BY P.TOY HAVING MAX (T. WEIGHT) > 60 C. TWO RECORDS C. THREE RECORDS branch TelNo salary 44-456-778, 44-356-356 44-456-778, 44-356-356 44-456-778, 44-356-356 44-999-432, 44-999-111 44-256-654, 44-256-214 44-256-654, 44-256-214 44-566-333, 44-546-343 44-999-432, 44-999-111 44-566-333, 44-546-343 Parts Table Part Weight tentacle 15 alien body 75 wheel 25 car body 60 funnel 20 head 40 b. ONE RECORD d. FOUR RECORDS
Expert Solution
steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY