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
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
Related questions
Question
100%
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps