Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
normalize the following Table into 3rd Normal Form.

normalize the following Table into 3rd Normal Form.

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
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

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS