``Learning without thinking is labour lost; thinking without learning is perilous''. Confucius, Analects, II, 17.
Course Description:
This course is designed to introduce students to the foundations of database systems, focusing on basics such as the relational algebra and data model, query optimization, query processing, and transactions. This course is on database design or SQL programming. It is designed for students who have knowledge of Computer Organization and Object Oriented Programming and UML; no prior database experience is assumed.
Course Outcome:
Ability to define a problem at the view level & ability to understand the physical structure of the database to handle data.
Students would be able to implement the logic by using tools like ERD.
Ability to normalize the database & understand the internal data structure.
Students would clearly understand the transaction system & could extract data efficiently.