Question 1: Normalization Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has the following functional dependencies (X is one table with the attributes W, Y, S, M, F, E):WS è YMFES è YMEE è M In what normal form is relation X? Explain why? Is it possible to decompose X into a number of relations in order to achieve a higher normal form? Explain how (this means using English sentences and a diagram showing the final relation(s)). officeNoofficeAddresstelNomgrStaffNonameB0018 Jefferson Way, Portland, ME 97201503-555-3618S1500Tom DanielsB002City Center Plaza, Seattle, WA 98122206-555-6756S0010Mary MartinezB00314 – 8th Avenue, New York, NY 10012212-371-3000S0145Art PetersB00416 – 14th Avenue, Seattle, WA 98128206-555-3131S2250Sally Stern Primary key: officeNo Why the above table is not in 3NF?Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF).c) Identify the primary and foreign keys in your 3NF relations.

Answered: Question 1: Normalization Consider…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Question 1: Normalization

Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has the following functional dependencies (X is one table with the attributes W, Y, S, M, F, E):

WS è YMFE

S è YME

E è M

In what normal form is relation X? Explain why?

Is it possible to decompose X into a number of relations in order to achieve a higher normal form? Explain how (this means using English sentences and a diagram showing the final relation(s)).

officeNo	officeAddress	telNo	mgrStaffNo	name
B001	8 Jefferson Way, Portland, ME 97201	503-555-3618	S1500	Tom Daniels
B002	City Center Plaza, Seattle, WA 98122	206-555-6756	S0010	Mary Martinez
B003	14 – 8th Avenue, New York, NY 10012	212-371-3000	S0145	Art Peters
B004	16 – 14th Avenue, Seattle, WA 98128	206-555-3131	S2250	Sally Stern

Primary key: officeNo

Why the above table is not in 3NF?
Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF).
c) Identify the primary and foreign keys in your 3NF relations.

Expert Solution