Database Systems Course Outline - University of Sargodha

Course Title: Database Systems
Course Code: CMP-3450
Course Structure: Lectures: 3/ Labs: 1
Credit Hours: 4
Prerequisites: None

Course Objectives:

The course aims to introduce basic database concepts, different data models, data storage and
retrieval techniques and database design techniques. The course primarily focuses on relational
data model and DBMS concepts.

Course Syllabus:

Basic Concept: File Processing & Database Approach, Database Applications, Advantages of the
DB, Components of the DB Environment, and Evolution of DBs. Database Architecture: DB
Development Process, Three Schema Architecture, Data Modeling. Logical Design: E-R
Modeling (Entities, Attributes, Relationships; Cardinality Constraints). RDBMS: Logical View of Data, Relational Data Model, Constraints, Transforming ERD/EERD into Relations. The

Relational Model: Types, Relations, Relational Algebra, Relational Calculus, Integrity.
Normalization. EE-R Diagrams: Development & Constraints, DB Design Life Cycle. DB
Development & Management: Introduction to SQL and Basic Commands, SQL Integrity
Constraints. Physical DB Design, DB architecture, Query Optimization. SQL Commands:
Saving, Listing, Editing, Restoring Table Contents; Logical Operators, Management Commands,
Arithmetic Operators, Complex Queries and SQL Functions, Aggregate Function, Grouping
Functions, Virtual Tables, Views, Indexes, Joins. Clint-Server & Distributed Environment,
ODBC, Bridges, and Connectivity Issues. Concurrency Control with Locking, Serializability,
Deadlocks, Database Recovery Management.Distributed Processing and Distributed Databases,
DDBMS: Evolution, Architecture, Components, Advantages, Security and Authorization.
Physical Design: Storage and File Structure, Efficiency and Tuning.

Course Outline:

1.      Databases Overview: Basic Concept; File Processing & Database Approach, Database
Applications, Advantages of the DB, Components of the DB Environment, Evolution of
DBs.

2.      Database Architecture: DB Development Process, Three Schema Architecture, Data
Modelling, E-R Modelling (Basic Concepts)

3.   Logical Design: E-R Modelling (Entities, Attributes, Relationships; Cardinality

Constraints), RDBMS: Logical View of Data; The Relational Data Model

4.      Logical Design:Constraints, Transforming ERD/EERD into Relations

5.      The Relational Model: Types, Relations, Relational Algebra, Relational Calculus,
Integrity

6.      Normalization: First Normal Form, Second Normal Form

7.      Normalization: Third Normal Form (3NF), Boyce Codd Normal Form (BCNF)

8.      EE-R Diagrams: Development & Constraints, DB Design Life Cycle,

9.      DB Development & Management: Introduction to SQL and Basic Commands, SQL
Integrity Constraints.

10.  Physical DB Design, DB architecture, Query Optimization

11.  SQL Commands: Saving, Listing, Editing, Restoring Table Contents; Logical Operators,
Management Commands

12.  Arithmetic Operators, Complex Queries and SQL Functions, Aggregate Function,
Grouping Functions

13.  Virtual Tables, Views, Indexes, Joins

14.  Clint-Server & Distributed Environment, ODBC, Bridges, and Connectivity Issues.

15.  Concurrency Control with Locking, Serializability, Deadlocks, Database Recovery
Management.

16.  Distributed Processing and Distributed Databases,DDBMS: Evolution, Architecture,
Components, Advantages, Security and Authorization. Physical Design: Storage and File
Structure, Efficiency And Tuning

Textbook(s):

1. Modern Database Management by Fred McFadden, Jeffrey Hoofer, Mary Prescott, Prentice Hall; 11^thEdition (July 26, 2012). ISBN-10: 0132662256
2. Database Systems A Practical Approach to Design, Implementation, and Management, 4^thEdition, Thomas Connolly, Carolyn Begg, Addison Wesley, 2005. 

3. Introduction to Oracle: SQL and PL/SQL ISBN-10: 0131453203
Reference Material:

•         Database Design and Relational Theory: Normal Forms and All That Jazz by C. J. Date,
O'Reilly Media; 1^stEdition (April 24, 2012). ISBN-10: 1449328016

•         Fundamentals of Database Systems by R. Elmasri and S. Navathe. 6^thEdition, Addison-
Wesley (2010). ISBN-10: 0136086209

•         Database System Concepts by Abraham Silberschatz, Henry F. Korth and S. Sudarshan.
McGraw-Hill; 6^th Edition (2010). ASIN: B004Y3YXK2

•         Database Systems: a Practical Approach to Design, Implementation and Management by
T.Connolly and C.Begg, Addison-Wesley; 5^th Edition (2009). ISBN-10: 0321523067

•         Modern Database Management System by Fred, Jeffery A. Hoffer and Fred McFadden;
Prentice Hall; 7^thEdition (April 6, 2004). ISBN-10: 0131453203

Note: This content is obtained from official documents of University of Sargodha and applied on BS Computer Science for Main Campus, Sub Campuses, and Affiliated Colleges.