This course introduces the students to the overview, design and implementation of database systems. At the end of this course, students will be able to: 

• Understand what database is, database system and DBMS .
• Differentiate database system from file system .
• Identify the pros and cons of manual approach, file based approach and database approach .
• Understand the basic principles of database design systems using different database models .
• Appreciate the use of database system in the real world. 
• Design different types of databases .
• Understand database normalization & functional dependency .
• Understand the principles of relational database management systems and their languages .
• Understand file organizations and storage management, and index structure for files.
• Demonstrate queries in the relational algebra. 
• Demonstrate queries in the tuple relational calculus. 
• Create a relational database schema in SQL that incorporates key, entity integrity, and referential integrity constraints.