1. Tables in second normal form (2NF):

Answer. Eliminate all hidden dependencies

2. Which-one ofthe following statements about normal forms is FALSE?
• BCNF is stricter than 3 NF
• Lossless, dependency -preserving decomposition into 3 NF is always possible
• Loss less, dependency – preserving decomposition into BCNF is always possible
• Any relation with two attributes is BCNF

Answer. Loss less, dependency - preserving decomposition into BCNF is always possible

3. The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into
• employee1 (ID, name)
• employee2 (name, street, city, salary)
• This type of decomposition is called

Answer. None of the mentioned

4. Inst_dept (ID, name, salary, dept name, building, budget) is decomposed into instructor (ID, name, dept name, salary) department (dept name, building, budget) This comes under

Answer. Both Lossy and Lossy-join decomposition

5. R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
• A->B, B->CD
• A->B, B->C, C->D
• AB->C, C->AD
• A->BCD

Answer. A->BCD

6.Class (course id, title, dept name, credits, sec id, semester, YEAR, building, room NUMBER, capacity, TIME slot id) The SET OF functional dependencies that we require TO hold ON class are: course id->title, dept name, credits building, room number->capacity course id, sec id, semester, year->building, room NUMBER, TIME slot id A candidate KEY FOR this schema IS {course id, sec id, semester, YEAR} Consider the above conditions. Which of the following relation holds?

Answer. Course id-> title, dept name, credits

7. The main task carried out in the __________ is to remove repeating attributes to separate tables.

Answer. First Normal Form

8. Which of the normal form is based on multivalued dependencies?

Answer. Fourth

9. "A many-to-many relationship set" has each related entity set has its own schema and there is an additional schema for the relationship set true or false ?

Answer. true

10. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

Answer. A multivalued attribute of an entity set