Question 1: Normalization Please TYPE IF POSSIBLE OR WRITE CLEARLYConsider 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)).

Answered: Please TYPE IF POSSIBLE OR WRITE…

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

Please TYPE IF POSSIBLE OR WRITE CLEARLY

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)).

Expert Solution