Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 1 branchNo branchAddress telNos 503-555-3618, 503-555-2727, 503-555-6534 B001 8 Jefferson Way, Portland, OR 97201 B002 City Center Plaza, Seattle, WA 98122 206-555-6756, 206-555-8836 B003

image text in transcribed

Table 1 branchNo branchAddress telNos 503-555-3618, 503-555-2727, 503-555-6534 B001 8 Jefferson Way, Portland, OR 97201 B002 City Center Plaza, Seattle, WA 98122 206-555-6756, 206-555-8836 B003 14 - 8th Avenue, New York, NY 10012 212-371-3000 B004 16 - 14th Avenue, Seattle, WA 98128 206-555-3131, 206-555-4112 1.) Why is this table not in INF? 2.) Show below how you would make it INF Table 2 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 3.) Is this table in INF? 4.) Why is this table not in 2NF? 5.) Show below how you would make it 2NF

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

Students also viewed these Databases questions