Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please normalize this table up to 3 normal form. You need to show functional dependencies. (Ex. Sname --> Saddress) Proj_num Proj_name Emp_num Emp_name Job_class Chg_hour

Please normalize this table up to 3 normal form. You need to show functional dependencies. (Ex. Sname --> Saddress)

Proj_num Proj_name Emp_num Emp_name Job_class Chg_hour Hours
15 Evergreen 103 June E Arbough Elec. Engr 84.50 23.8
15 Evergreen 101 John G news Database designer 105.00 19.4
15 Evergreen 105 Alice K johnson database designer 105.00 35.7
15 Evergreen 106 Willam smithfield programmer 35.75 12.6
15 Evergreen 102 David h senior system analyst 96.75 23.8
18 Amberwave 114 Annelise jones application designer 48.10 24.6
18 Amberwave 118 James J frommer general support 18.36 45.3
18 Amberwave 104 Anne k Ramoras system analyst 96.75 32.4
18 Amberwave 112 Darlene M smithson dss analyst 45.95 44.0
22 Rolling tide 105 Alice k johnson database designer 105.00 64.7
22 Rolling tide 104 Anne k Ramoras system analyst 96.75 48.4
22 Rolling tide 113 Delbert k Joenbrood application designer 48.10 23.6
22 Rolling tide 111 Geoff B wabash clerical support 26.87 22
22 Rolling tide 106 William smithfield programmer 35.75 12.8
25 Starflight 107 Maria D alonzo programmer 35.75 24.6
25 Starflight 115 Travis B bawangi system analyst 96.75 45.8
25 Starflight 101 John G news database designer 105.00 56.3
25 Starflight 114 Annelise jones application designer 48.10 33.1
25 Starflight 108 Ralph washington system analyst 96.75 23.6
25 Starflight 118 James j frommer general support 18.36 30.5
25 Starflight 112 Darlene M smithson dss analyst 45.95 41.4

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions

Question

1. Identify what positions are included in the plan.

Answered: 1 week ago