University of Management and Technology
Course Outline
Course code… CC2141...... Course title…Database systems………………
BSCS, BSSE
Program
4 (3+1)
Credit Hours
16 Weeks
Duration
Data Structure
Prerequisites
Shakra Mehak
Resource Person
NA
Counseling Timing
(Room# 30)
Shakra.mehak@skt.umt.edu.pk
Contact
Chairman/Director signature………………………………….
Dean’s signature…………………………… Date………………………………………….
Course Outline Page 1
Learning Objective:
At the end of this course, students will be able to:
Students will be able to understand the Database System environment
Students will be able to Design and Implement a Relational database for real life
problems
Students will be Expertise in writing SQL queries
Students will have Good concepts of modeling techniques (ERD)
Students will be able to suggest a Centralized Distributed system according to
organizational needs
Students will be able to design and implement solutions for the small business
organizations
Learning Methodology:
Material for this course will be presented using multiple teaching approaches: lecture and
discussion, exploration and inquiry, field experiences, cooperative group work, demonstrations,
role plays, labs, and/or presentations.
Grade Evaluation Criteria
Following is the criteria for the distribution of marks to evaluate final grade in
a semester.
Letter Grade Grade points
A+/A 4.0
A- 3.7
B+ 3.3
B 3.0
B- 2.7
C+ 2.3
Course Outline Page 2
C 2.0
C- 1.7
F 0.0
P (Pass) -
I (Incomplete) -
W (Withdrawal) -
SA (Short Attendance) -
Marks Evaluation Marks in percentage
Quizzes 10%
Assignments 10%
Mid Term 25%
Term Project 10%
Term Project Presentations 5%
Final exam 40%
Total 100%
Recommended Text Books:
Thomas Connally * Carolyn Begg “Database Systems 4th Edition
Reference Books:
Fundamentals of Database by ElMasri 6th Ed
“Database Systems” Design, Implementation, Management by Peter Rob and
Carlos Coronel, 5th Ed
Course Outline Page 3
Calendar of Course contents to be covered during semester
Course code… CC2141...... Course title…Database systems………………
Week Course Contents Reference Chapter(s)
File Systems and Databases: Introducing the Database; Chapter 1
Historical roots of the database; Files and File system, A
File system Critique; File System Data Management,
1
Structural and Data dependence, Field Definitions and
Naming Conventions, Data Redundancy, Database
Systems: Database system Environment, Roles in Database
Environment: Types of Database Management Systems,
DBMS Functions, Managing the Database System ,History of
Database Management Systems, Advantages and
Disadvantages of DBMS
Functions of DBMS; Components of DBMS; Multi-User DBMS; Chapter 2
Architectures, Teleprocessing, File-Server, Client-Server
Database Design and Modeling: ANSI-SPARC Architecture,
2
Database Models: Hierarchical Model, Network Model,
Relational Model, Entity. Relationship Data Model, Object-
Oriented Model, Database Languages: Data Definition
Language (DDL), Data Manipulation Language (DML)
Introduction to RDBMS: A logical view of Data; Entities and Chapter 3
Attributes, Tables and their Characteristics, Keys. History of
Relational Model: Terminologies: Relational Data Structures,
3
Mathematical Relation; Database Relations, Relational Keys,
Representing. Relational Database Schemas.
Course Outline Page 4
Relational Integrity: Null; Entity Integrity; Enterprise Chapter 3
constraints.
Relational Algebra: Unary Operations, Set Operations, Join Chapter 4
Operations, Division Operations, Tuple Relational Calculus;
Domain Relational Calculus
5
Structured Query Language (SQL): Chapter 5
Introduction to SQL; Objective of SQL; History of SQL;
6 Importance of SQL, SQL: Introduction to Data Definition
Commands, Data Manipulation Commands, Data control
Language
SQL: Data Manipulation Commands, Data Entry, Saving the
Table Contents, Listing the Table Contents, Making a
Correction, Restoring the Table Contents, Deleting Table
Rows. Group Functions.
SQL: Joins, Natural join, Theta Join, Outer Join, Left outer Join, Chapter 6
Right Outer Join,
Self-Join; Sub Queries: Single Row and multiple Row.
7
Database Design: Entity Relationship (E-R) Modeling: Chapter 11
Basic Modeling Concepts;
Data Models; Degrees of Data Abstraction; Conceptual Model,
Internal Model, External Model, Physical Model. Entity
8
Relationship (E-R) Model: Entities, Attributes, Relationships,
Connectivity
and Cardinality, Relationship Strength (Existence
Course Outline Page 5
Dependency), Relationship
Participation, Relationship Strength and weak entities,
Relationship Degree
Midterms
Specialization/Generalization For EERD: Chapter 12
Super Classes & Sub Classes; Super Class / Sub Class
Relationships; Attributes
10 Inheritance; Specialization Process; Generalization Process;
Constraints on
Specialization/Generalization; Aggregation Composition
Normalization: Process of Normalization: First Normal Form, Chapter 13
Second Normal
11 Form: Full Functional Dependency, Third Normal Form:
Transitive Dependency
Course Outline Page 6
Procedural SQL: Triggers, Stored Procedures, PL/SQL Stored Chapter 20
Functions. Complex Queries and SQL Functions;
12
Transaction Management and Concurrency Control:
What is a Transaction; Evaluating Transaction Results,
Transaction Properties, Transaction Management with
SQL, Transaction Log, Transaction Types. Concurrency
Control: Lost Updates, Un-committed Data, Inconsistent
Retrievals, Dirty Data, Fuzzy Read, Scheduler
DDBMS: Comparison of Centralized and Distributed Chapter 22
Databases: Evolution,
Advantages & Disadvantages. Distributed processing and
13
distributed databases. What is a DDBMS?
Data Warehousing(DWH): Introduction to Data Chapter 31
Warehousing, Data warehouse
Architecture, Data warehouse Information flow;
14
Data Warehousing(DWH):Data warehousing tools and Chapter 31
technologies, Data Marts,
Designing Data warehouses. Revision
15
Course Outline Page 7
