Assignment
Each question should be answered in 2 paragraphs.
1. The relational set operators UNION, INTERSECT, and MINUS work properly only if the relations are union-compatible. Discuss union-compatible with at least 3 examples for each and how would you check for this condition.
2. Use examples to demonstrate the connection between SQL commands and transactions, discuss the role of transaction log.
3. What is the difference between ODBC and JDBC database interfaces? Why is it important to have effective and powerful interfaces like these for databases?
4. Discuss the differences between database and data warehouse. Why we need data warehouse when database is available?