1 Define redundancy? Knowledge 5 2 Define functional dependency? Why are some functional dependencies trivial? Knowledge 5 3 Discuss normalization? Understand 5 4 Illustrate functional dependency with example? Apply 5 5 Illustrate fully functional dependency with example? Apply 5 6 Demonstrate transitive dependency? Give an example? Apply 5 7 Discuss Domain-Key Normal Form? Understand 5 8 Define Armstrong axioms for FD's? Knowledge 5 9 Define First Normal Form? Knowledge 5 10 Define Second Normal Form? Knowledge 5 11 Define Third ormal Form? Knowledge 5 12 Define Fourth ormal Form? Knowledge 5 13 List out the Problems related to decompositions? Knowledge 5 14 Explain about Loss less-join dependency? Understand 5 15 Explain about BC F? Understand 5 16 Explain about multi-valued dependencies? Understand 5 17 Define join dependency and fifth normal form? Knowledge 5 18 Exp ain the concept scheme refinement in database design? Understand 5 19 Define dependency preserving decomposition? Knowledge 5 20 Exp ain about inclusion dependency? Understand\

Consider a relation scheme R = (A, B, C, D, E, H) on which the following 1 functional dependencies hold: {A->B, BC-> D, E->C, D->A}. Write the Apply 5 candidate keys of R? Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) the following are functional dependencies: 2 a. Title Author --> Catalog_no b. Catalog_no --> Title Author Publisher Year c. Publisher Title Year --> Price d. Assume {Author, Title} is the key for both schemes. Apply the appropriate normal form for Book and Cancellation? Consider a schema R (A, B, C, D) and functional dependencies A -> B and C ->D. 3 Solve and find whether the decomposition of R into R1 (A, B) and R2(C, D) Apply 5 belongs to which one or both (dependency preserving and loss less join)? 4 Show that: if and then Apply 5