Answer Happy

In SQL Language
2a)
Which of the following is a fundamental operation in relational
algebra?
Set intersection
Cartesian product
Outer join
Division
2b)
Tables in second normal form (2NF):
Eliminate all dependencies
Eliminate update anomalies
Have a composite key
No partial dependencies on any column in primary key
2c)
A table S(A, B, C, D, E, P, G) with the following functional dependencies: AB → CD DE →P CE P→C B → G is considered in not in 2NF BCNF 3NF 2NF