The questions can come in any order, so make sure you are selecting right option for all questions.
1. What is the purpose of decomposing a relation into Fifth Normal Form (5NF)?
(c) To eliminate redundancy caused by specific constraints and join dependencies
2. How is a join dependency represented?
(a) {R1, R2, ..., Rn} ⟶ R
3. Consider a relation involving suppliers, parts, and projects:
Initial Table (SupplierPartsProjects)
| Supplier | Part | Project |
|---|---|---|
| S1 | P1 | J1 |
| S1 | P2 | J1 |
| S1 | P1 | J2 |
| S2 | P2 | J2 |
Assume the following constraints:
i. Every part supplied for a project is supplied by all suppliers supplying any part for that project.
ii. Every part supplied by a supplier is supplied by that supplier for all projects to which that supplier supplies any part.
In the given example, what join dependencies exist on the table "SupplierPartsProjects"?
(d) All of the above
4. Which normal form is related to Join Dependency in DBMS?
(d) 5th Normal Form (5NF)
5. What is a Join Dependency in DBMS?
(b) When a relation can be recreated by joining various tables, each consisting of a subset of the table's attributes