Solve please

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

Given the relations employee(name,salary,deptno) 3 department (deptno, deptname, address) Apply 10 Solve which query cannot be expressed using the basic relational algebra Operations(U, -,x , ,p)? 4 Write SQL Query to find second highest salary of Employee from Employee Apply 10\

\

Illustrate different set operations in Relational algebra with an example? Apply 8 2 Define Join? Explain different types of joins? Knowledge 10 3 Discuss about Domain Relational calculus in detail? Understand 8 4 Define trigger and explain its three parts? Differentiate row level and statement Knowledge 10 level triggers? 5 Illustrate Group by and Having clauses with examples? Apply 10 6 Discuss about Complex integrity constraints in SQL? Understand 6 7 Discuss different types of aggregate operators with examples in SQL? Understand 10 8 a. Define a nested query? Knowledge b. nested query to find the names of sailors who have reserved both a red and green boat? 10 c. nested query to find the names of sailors who have reserved all boats? 9 a. Discuss correlated nested queries? Understand b. query to find the names of sailors who have reserved a red boat? 10 c. query to find the names of sailors who have not reserved a red boat? 10 a. Explain Relational calculus? Understand b.TRC query to find the names of sailors who have reserved boat 103? 10 c. DRC query to find the names of sailors who have reserved boat 103?