COMSATS University Islamabad
Department of Computer Science
Course Description Form (CDF)
Course Information
Course Code: CSC270 Course Title: Database Systems
Credit Hours: 4(3,1) Lecture Hours/Week: 3
Lab Hours/Week: 3 Pre-Requisites: None
Course Objective
• To explain the basic database concepts, information retrieval and relational theory;
• To develop the relational data model;
• To develop an enterprise data model that reflects the organization's fundamental business rules;
• To apply normalization techniques;
• To discuss the basics of transaction management, concurrency controls, query mechanisms, security
and quality issues;
• To apply database programming languages and physical database design to gain experience in term
project.
Course Content
This course introduces the fundamental concepts of database systems. Topics include: Introduction to
Databases & Information Systems; Evolution of Database Systems; Components; Architecture; Functions;
Relational Model; Relational Algebra; Relational Calculus; Data Modeling; Relational Data Model;
Relational Algebra & Calculus; Integrity Constraints; Conceptual Models; Entity-Relationship (E-R) Model;
Enhanced E-R Model; Mapping Conceptual Schema to Relational Schema; Functional Dependency &
Normalization; Structured Query Language (SQL); Views; Materialized Views; Non-Relational/No SQL
Databases; MongoDB as NoSQL Database; Document Model; and Transaction Management.
Unit wise Major Topics:
No. of Teaching
Unit Topic
Hours
Databases & Information Systems: Basic Concepts, Evolution,
Advantages & Disadvantages, Database Environment, Approaches &
1. 6
Roles; Components; Architecture; Functions; Data Dependences, and
Applications.
Relational Model: Relation, Domains, Properties, Attributes; Relational
2. 3
Keys; DB Schema; and Integrity Constraints.
Relational Algebra (Operations): Unary, Set, Join, Division,
3. 6
Aggregation & Grouping; and Relational Calculus: Domain & Tuple.
Data Modeling: Conceptual Models, Relational Database Design; E-R
4. 9
Model; and Enhanced E-R Model.
Normalization: Purpose, Data Redundancy & Anomalies; Process: First
5. Normal Form, Second Normal Form, Third Normal Form, and Boyce- 7.5
Codd Normal Form.
SQL: DDL, DML, DCL; Views; Materialized Views; and Database
6. 4.5
Authorization.
Non-relational / No SQL Databases: MongoDB as NoSQL Database;
7. 4.5
MongoDB Sharing & Replication; and Document Model.
8. Transaction Management: Support, Failure & Recovery, Concurrency 4.5
1
Control, and Transaction & Storage.
45
Total Contact Hours
Mapping of CLOs and SOs
Blooms
Sr.# Unit # Course Learning Outcomes Taxonomy GA
Learning Level
CLO’s for Theory
CLO-1 1 Explain database concepts and principles. Understanding 2
Apply the concept of domain and tuple relational
CLO-2 2-3 Applying 2,3
calculus.
Apply data modeling and normalization
CLO-3 4-5 techniques to design database for small to Applying 3,4
medium size enterprise
Describe the principles of transaction
CLO-4 8 Understanding 2
management.
CLO’s for Lab
Apply data processing operations on both
CLO-5 6-7 Applying 3,5,10
relational and non-relational DBMS.
Develop a database system for medium size
CLO-6 1-8 enterprise in a team environment. Creating 1-6, 10
CLO Assessment Mechanism
Assessment
CLO-1 CLO-2 CLO-3 CLO-4 CLO-5 CLO-6
Tools
Quizzes Quiz 1 Quiz 2 Quiz 3 Quiz 4 - -
Lab
Assignments - Assignment 1 Assignment 2-4 - -
Assignments
Mid Term Mid Term Mid Term Mid Term Lab Mid Term
- -
Exam Exam Exam Exam Exam
Lab
Project/
Final Term Exam Final Term Exam -
Lab Final
Term Exam
Text and Reference Books
Textbooks:
1. Database systems: A Practical Approach to Design, Implementation, And Management, Thomas
Connoll y, Carolyn Begg, Pearson, 2015.
2. MongoDB: The Definitive Guide, Shannon Bradshaw, Eoin Brazil, Kristina Chodorow, O'Reilly
Media, 2019.
Reference Books:
1. Fundamentals of Database Systems, Elmasri, R, Navathe, Pearson, 2016.
2. Database System Concepts, Silberschatz, Korth, Sudarshan, McGraw Hill, 2019.