Course Information

Credit Hours: 3+1
Prerequisites: None
Course Content:

Basic database concepts, Database approach vs file based system, database architecture, three level schema architecture, data independence, relational data model, attributes, schemas, tuples, domains, relation instances, keys of relations, integrity constraints, relational algebra, selection, projection, Cartesian product, types of joins, normalization, functional dependencies, normal forms, entity relationship model, entity sets, attributes, relationship, entity-relationship diagrams, Structured Query Language (SQL), Joins and sub-queries in SQL, Grouping and aggregation in SQL, concurrency control, database backup and recovery, indexes, NoSQL systems.

Grading Policy:

  • Quizzes (LMS): 10%
  • Assignments/ Reports(LMS): 15%
  • Attendance + LMS Log: 10%
  • Discussion Forum / Video / Audio Engagement: 15%
  • Mid Term Exam(Oral Exams and Presentations): 20%
  • Final Exam(Oral Exams and Presentations): 30%


Reference Materials:
  1. Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition by Thomas Connolly and Carolyn Begg.
  2. Database Systems: The Complete Book, 2nd Edition by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom.
  3. Database System Concepts, 6th Edition by Avi Silberschatz, Henry F. Korth and S. Sudarshan.
  4. Database Management Systems, 3rd Edition by Raghu Ramakrishnan, Johannes Gehrke.

Useful Online Resources:
  1. https://www.mysql.com/
  2. http://www.sqlfiddle.com/
  3. https://www.w3schools.com/sql/
  4. https://classroom.udacity.com/courses/ud197
  5. https://www.udacity.com/course/database-systems-concepts-design--ud150
  6. DBMS tutorial on Tutorialspoint 
  7. DBMS tutorial on JavaPoint

Last modified: Saturday, 18 July 2020, 5:17 PM