A course on fundamentals of database systems. Database Management Systems (DBMS) are an integral component of modern computing environment and applications. This is a first course in databases at the undergraduate level covering fundamentals concepts, aspects of database design, database languages and database system implementation. Students are taught concepts and algorithms in a general setting that is not tied to one particular database system.
The course emphasizes both theory and application of database systems. Topics covered in the course are: introduction to the relational model, introduction to SQL, intermediate and advanced SQL, database design using entity relationship approach, data storage and querying, indexing and hashing and transaction management.
1. Students are able to design and develop an efficient solution for an application using RDBMS concepts.
2. Students are able to write intermediate and advanced SQL queries.
3. Students are able to understand internal working of a DBMS including indexing, transaction processing, concurrency control and recovery.