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)
In Sql Language 2a Which Of The Following Is A Fundamental Operation In Relational Algebra Set Intersection Cartesian 1 (34.36 KiB) Viewed 37 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!