ICS 311 - Database Management Systems Assignment 5 Due: See Syllabus Question 1: Normalization Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has...


please explain better way .


Thank You.


ICS 311 - Database Management Systems<br>Assignment 5<br>Due: See Syllabus<br>Question 1: Normalization<br>Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X.<br>Assume X has the following functional dependencies (X is one table with the attributes W, Y, S,<br>М, F, E):<br>1.1)<br>WS > YMFE<br>S> YΜΕ<br>E > M<br>a) In what normal form is relation X? Explain why?<br>b) Is it possible to decompose X into a number of relations in order to achieve a higher normal<br>form? Explain how (this means using English sentences and a diagram showing the final<br>relation(s)).<br>

Extracted text: ICS 311 - Database Management Systems Assignment 5 Due: See Syllabus 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, М, F, E): 1.1) WS > YMFE S> YΜΕ E > M a) In what normal form is relation X? Explain why? b) 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)).

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here