Explain the fundamental concepts of database systems and the relational model.
Design and implement relational databases using SQL data definition and manipulation statements.
Write complex SQL queries involving joins, subqueries, views, and set operations.
Apply transaction management and concurrency control techniques to ensure data integrity.
Analyze and resolve issues related to deadlock and weak consistency levels.
Derive candidate keys from functional dependencies and normalize database schemas.
