Objective: this assignment is designed to let you have a hands-on experience with normalization. A normalized schema provides a good starting point for further development of a database application and easier maintenance it later on. Normalization is a process of modifying an existing database schema to bring its component tables into compliance with a series of normal forms. The goal of the normalization is to ensure that every non-key attribute in every table is directly dependent on the whole candidate key (nothing else but the key) Consider a relation R with five attributes A, B, C, D, E. You are given the following dependences: 1. C? E Is{(ABCE)j a candidate key of this relation? If not, is (ABC)]? Justify your answer Answer: 2. Consider the relation F with six attributes F,R,I,D,A,Y with the following dependences: FY -> A, and a) List all keys for F and justify your answer Answer: Objective: this assignment is designed to let you have a hands-on experience with normalization. A normalized schema provides a good starting point for further development of a database application and easier maintenance it later on. Normalization is a process of modifying an existing database schema to bring its component tables into compliance with a series of normal forms. The goal of the normalization is to ensure that every non-key attribute in every table is directly dependent on the whole candidate key (nothing else but the key) Consider a relation R with five attributes A, B, C, D, E. You are given the following dependences: 1. C? E Is{(ABCE)j a candidate key of this relation? If not, is (ABC)]? Justify your answer Answer: 2. Consider the relation F with six attributes F,R,I,D,A,Y with the following dependences: FY -> A, and a) List all keys for F and justify your