Assignment: a) Is this table in 1NF? Why or why not? b) Describe and illustrate the process of normalizing the data shown in this table, from first to third normal form (1NF-3NF). c) Identify the primary, alternate, and foreign keys in the 3NF relations. StaffBranch Table staffNo name position level salary $1500 Tom Daniels Manager 3 46000 B001 S0003 Sally Adams Assistant 1 30000 B001 S0010 Mary Martinez Manager 5 S3250 Robert Chin Supervisor 1 50000 B002 32000 B002 S2250 Sally Stern Manager 4 48000 B004 S0415 Art Peters Manager 2 41000 B003 503-555-3618 503-555-2727 206-555-8836 206-555-6756 206-555-4112 hours supervisor 45 S0010 36.5 $2250 38 S0415 28 S0010 212-371-3000 37 S2250 branchNo branchAddress 8 Jefferson Way, Portland, OR 97201 8 Jefferson Way, Portland, OR 97201 City Center Plaza, Seattle, OR 98122 City Center Plaza, Seattle, OR 98122 16-14th Avenue, Seattle, OR 98128 14-18th Avenue, New York, NY 10012 telNo

icon
Related questions
Question
100%
Assignment:
a) Is this table in 1NF? Why or why not?
b) Describe and illustrate the process
of normalizing the data shown in this table,
from first to third normal form (1NF-3NF).
c) Identify the primary, alternate, and foreign keys
in the 3NF relations.
StaffBranch Table
staffNo
name
position
level salary
$1500
Tom Daniels
Manager
3
46000 B001
S0003
Sally Adams
Assistant
1
30000 B001
S0010
Mary Martinez
Manager
5
S3250
Robert Chin
Supervisor
1
50000 B002
32000 B002
S2250
Sally Stern
Manager
4
48000 B004
S0415
Art Peters
Manager
2
41000 B003
503-555-3618
503-555-2727
206-555-8836
206-555-6756
206-555-4112
hours supervisor
45 S0010
36.5 $2250
38 S0415
28 S0010
212-371-3000
37 S2250
branchNo branchAddress
8 Jefferson Way, Portland, OR 97201
8 Jefferson Way, Portland, OR 97201
City Center Plaza, Seattle, OR 98122
City Center Plaza, Seattle, OR 98122
16-14th Avenue, Seattle, OR 98128
14-18th Avenue, New York, NY 10012
telNo
Transcribed Image Text:Assignment: a) Is this table in 1NF? Why or why not? b) Describe and illustrate the process of normalizing the data shown in this table, from first to third normal form (1NF-3NF). c) Identify the primary, alternate, and foreign keys in the 3NF relations. StaffBranch Table staffNo name position level salary $1500 Tom Daniels Manager 3 46000 B001 S0003 Sally Adams Assistant 1 30000 B001 S0010 Mary Martinez Manager 5 S3250 Robert Chin Supervisor 1 50000 B002 32000 B002 S2250 Sally Stern Manager 4 48000 B004 S0415 Art Peters Manager 2 41000 B003 503-555-3618 503-555-2727 206-555-8836 206-555-6756 206-555-4112 hours supervisor 45 S0010 36.5 $2250 38 S0415 28 S0010 212-371-3000 37 S2250 branchNo branchAddress 8 Jefferson Way, Portland, OR 97201 8 Jefferson Way, Portland, OR 97201 City Center Plaza, Seattle, OR 98122 City Center Plaza, Seattle, OR 98122 16-14th Avenue, Seattle, OR 98128 14-18th Avenue, New York, NY 10012 telNo
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer