Consider the following relation R with attributes A, B, C, D, and E and with functional...

 

Transcribed Image Text:

Consider the following relation R with attributes A, B, C, D, and E and with functional dependencies (FDs) as marked. A B C D a) What is the key of R? b) What is an FD from above that violates 2NF? c) What is an FD from above that violates 3NF (but not 2NF)? [ E Is the following relation in Fourth Normal Form, if yes explain why, if not explain why and normalize it into fourth Normal form. Employee Name Mohan Mohan Mohan Mohan Mohan Mohan Skills C Sharp Asp.Net Company Godrej Godrej Godrej H. Lever H. Lever H. Lever SQL Server C Sharp Asp.Net SQL Server Is the following relation in fifth Normal Form, if yes explain why, if not explain why and normalize it into fifth Normal form. Product Soap Shampoo Language Hindi Hindi Hindi Shampoo Soap Shampoo Soap English English English Supplier Mr. Amit Mr. Pavan Mr. Amit Mr. Amit Mr. Pavan Mr. Sachin Consider the following relation R with attributes A, B, C, D, and E and with functional dependencies (FDs) as marked. A B C D a) What is the key of R? b) What is an FD from above that violates 2NF? c) What is an FD from above that violates 3NF (but not 2NF)? [ E Is the following relation in Fourth Normal Form, if yes explain why, if not explain why and normalize it into fourth Normal form. Employee Name Mohan Mohan Mohan Mohan Mohan Mohan Skills C Sharp Asp.Net Company Godrej Godrej Godrej H. Lever H. Lever H. Lever SQL Server C Sharp Asp.Net SQL Server Is the following relation in fifth Normal Form, if yes explain why, if not explain why and normalize it into fifth Normal form. Product Soap Shampoo Language Hindi Hindi Hindi Shampoo Soap Shampoo Soap English English English Supplier Mr. Amit Mr. Pavan Mr. Amit Mr. Amit Mr. Pavan Mr. Sachin