National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
COURSE DESCRIPTION FORM
INSTITUTION _University of Sialkot____________
Information Technology
PROGRAM (S) TO BE
EVALUATED
A. Course Description Database Systems is a course in which Database design is the main focus.
What are Database, Database Management Systems, and Structured query language, these are the
three major pilgrims of the course. Moreover, the Database environment is the basic part to learn.
Database design models are used to design the database. The normalization technique is the way to
remove anomalies from the database. Structural constraints, Keys, Attributes, Indexes, and Views are
used to develop the database. The structured query language is used to manipulate the data the and
Oracle server is the tool to develop the database.
Course Outcomes: At the end of the course the students will be able to
Explain fundamental database concepts. (Understand).
Design conceptual, logical, and physical database schemas using different data models. (Design)
Identify functional dependencies and resolve database anomalies by normalizing database tables.
(Analysis)
Use Structured Query Language (SQL) for database definition and manipulation in any DBMS
(Implement).
Database System 4(3-1)
Learning Objectives
This course will enable the students to design a database system according to the
requirements and manage the data in an efficient way.
Course Learning Outcomes
At the end of the course the students will be able Domain BT Level* PLO
to:
Explain fundamental database concepts. C 2 2
1 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Design conceptual, logical, and C 5 2
physical database schemas using
different data models.
Identify functional dependencies and C 2 4
resolve database anomalies by
normalizing database tables
Use Structured Query Language (SQL) C 4 4
for database definition and manipulation
in any DBM
* BT= Bloom’s Taxonomy, C=Cognitive domain, P=Psychomotor domain, A= Affective
Domain
SDGS addressed in the course: 9 (Industry, Innovation, and Infrastructure)
Teaching Mode: the course will be taught in hybrid learning mode offering a substantial
A portion of contents and course activities online through a learning management system
Course Contents
Theory
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.
Practical
Teaching Methodology:
Lectures, Written Assignments, Practical labs, Semester projects, Presentations
Course Assessment:
Sessional Exam Home Assignments, Quizzes, Project, Presentations, Final Exam
Text Book:
1. Database Systems: A Practical Approach to Design, Implementation, and Management,
6th Edition by Thomas Connolly and Carolyn Begg.
Suggested Readings:
1. Database System Concepts, 6th Edition by Avi Silberschatz, Henry F. Korth and S.
Sudarshan.
2. Database Management Systems, 3rd Edition by Raghu Ramakrishnan, Johannes Gehrke
2 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Topics Covered in Week [1]
the Course, with
Introduction of Database Approach:
Number of Lectures
on Each Topic Introduction of Database
Introduction of DBMS CLO1
Traditional file System
Database Environment:
Data and Database Administrators
Database Designers
Application Developers CLO1
End-Users
Week [2]
ANSI-SPARC Architecture:
External Level
Conceptual Level CLO1
Internal Level
Database System Models:
Concept and evaluation of database CLO2
Flat file model, Hierarchical model
Network Model, Relational model
Object-relational model
Object-Based data model
3 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Week [3]
Overview of Information Engineering Methodology
Planning
Analysis CLO1
Develop a Conceptual data model
Implementation
Maintenance CLO2
Database Planning
Uses of fact-finding techniques
What facts are collected
Week [4]
Database Design:
Approaches to database design
Data Modeling
Phases of database design CLO2
Conceptual database design
PRIMARY KEY Constraint
CLO3
UNIQUE Constraint
IDENTITY Property
DEFAULT Definition
FOREIGN Key Constraint
CHECK Constraint
NOT NULL
Constraint Rules
4 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Week [5]
Structural Constraints:
Relationships
CLO2
Introduction to Entity-relational model
Attributes
Simple and composite attributes
Single and multi-valued attributes CLO3
Multi-valued attributes
Derived attributes
Introduction to EERD
Week [6]
Database design:
Logical Database design
Normalization
Data redundancy
Process of Normalization CLO3
Third Normal form
Transitive Dependency
Boyce codd Normal form
Fourth normal form CLO4
Multivalued dependency
5th normal form
Week [7]
Introduction to SQL:
Data redundancy
Objective of SQL
Categories of SQL Commands CLO3
Data Definition:
CLO4
Create a Database
Creating Tables
Altering Table
5 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Dropping Table
Week [8]
Midterm
Week [9]
CLO2
Aggregate Functions in SQL
CLO3
The GROUP BY Clause
The HAVING Clause
Querying from Multiple Tables
UNIION
Sub Query
CLO1
Week [10] CLO2
Types of Sub Query
Nested Sub query
Single row sub query
Multiple row sub query
Correlated Sub query Parameters Queries
Week [11]
Types of Joins CLO4
Inner join
Outer Join
Left outer join
Right outer join
Week [12]
Views CLO2
Creating Views CLO4
Removing views
Restrictions on Views
Updating Views
6 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Advantages and Disadvantages
View Materialization
Week [13]
CLO4
Changing the Content of Tables using Action Queries CLO3
The INSERT table Statement
The DELETE table Statement
The UPDATE table Statement
Append Action Query
Week [14] CLO4
CLO2
Indexes
Types of Indexes
Indexed Sequential Files
Secondary indexes
Multilevel indexes
B+ trees
Clustered, Non-Clustered Indexes
Week [15] CLO4
Backup / Recovery
Index
No Sql System
Week [16]
Presentations
Laboratory The lab will be conducted for projects
Projects/Experiments
Done in the Course
Programming Assignments Done As above
in the Course
Class Time Spent on (in credit Theory Problem Solution Social and Ethical
hours) Analysis Design Issues
40% 20% 30% 10%
7 NCEAC.FORM.001.D
National Computing Education Accreditation Council
NCEAC
NCEAC.FORM.001-D
Oral and Written Communications
Instructor Name: Mr. Jabar Mahmood, Mr. Intakhab Alam, Mr. Faizaan Khursheed
Instructor Signature ____________________________
Date ___________________________
8 NCEAC.FORM.001.D
