CS403P Lab Attendance Quiz No. 8 Fall 2024

Here are the questions and answers for the CS403P Database Management Systems (Practical) quiz:

1. A relation is in second normal form if and only if ______________ and all the non-key attributes are fully functionally dependent on the key.

   • Answer: It is in first normal form

2. If a relation CLASS (crId, stId, stName, fId, room, grade) has the following Functional Dependencies:

   • crId, stId → stName, fId, room, grade
     Which of the following functional dependency is in the above functional dependency?
   • Answer: Partial dependency

3. In functional dependency, if one attribute is a determinant of all other attributes of the relation then the relation has at least __________.

   • Answer: Super key

4. 2nd Normal Form is based on which of the following dependency?

   • Answer: Partial dependency

5. ______________ is a step-by-step process to reduce data redundancy and improve data integrity to build a more efficient and accurate database design.

   • Answer: Normalization

Let me know if you need further assistance!