Examine the table shown below and answer the questions below: StaffNo branchNo branchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza, Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 S5723 B005 23 Pitt Street, Sydney Donald Duck TeaBoy 25 i. Identify the primary key for the above relation. ii. Why is this table not normalised? What normal form is it in? i. Identify the functional dependencies for this relation. Is hoursperweek position one of them? Why, or why not? ii. Describe and illustrate the process of normalizing
Please do not give solution in image format thanku
2. Examine the table shown below and answer the questions below: StaffNo branchNo branchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 – 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza, Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 – 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10 S5723 B005 23 Pitt Street, Sydney Donald Duck TeaBoy 25 i. Identify the primary key for the above relation. ii. Why is this table not normalised? What normal form is it in? i. Identify the functional dependencies for this relation. Is hoursperweek position one of them? Why, or why not? ii. Describe and illustrate the process of normalizing
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
