a. Normalization is an important concept for database professionals. Whether you are the designer, database analyst...

Transcribed Image Text:

a. Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. In your opinion discuss the basic issues to be aware of before carrying out the normalization process. CR [4 Marks] b. Given the following relational schema and its functional dependencies: RentalInfo custNo propertyNo custName pAddress rentStart ownerNo OName fd1 fd2 fd4 i. ii. fd3 fd5 Specify candidate keys and state the primary key. EV [2 marks] Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalizing the relational schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your third normal forms. a. Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. In your opinion discuss the basic issues to be aware of before carrying out the normalization process. CR [4 Marks] b. Given the following relational schema and its functional dependencies: RentalInfo custNo propertyNo custName pAddress rentStart ownerNo OName fd1 fd2 fd4 i. ii. fd3 fd5 Specify candidate keys and state the primary key. EV [2 marks] Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalizing the relational schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your third normal forms.

Answer rating: 100% (QA)

a Normalization Normalization is a process of reducing the redunda... View the full answer