Course Title Fundamentals of Database Systems
Course Code SEng4021
CP 5 (2hr Lecture, 3hr Lab)
Module Title Database Management Systems
Module Number 04
Pre-requisites None
Year II
Semester I
Status of Course Compulsory
Course Description:
Database concepts related to data handling techniques, definition of a database and benefits of
database systems, functions and components of DBMS. Architecture for database systems: ANSI
SPARC architecture architectures, data model concepts and basic types of data models
(Hierarchical, Network and Relational data models). Emphasize on Relational data model: data
structures and integrity rules. Three levels Database design: (Conceptual, Logical and Physical
Database designing). Basics of Relational Languages (Relational Algebra, Relational calculus and
SQL).
Learning Outcomes:
At the end of the Course students should be able to:
▪ Explain what a Database System is, and be able to identify its characteristics and
applications,
▪ Explain the different models of database,
▪ Design ER models from specifications and interpret them into relational tables,
▪ Write SQL statements for data creation and manipulation purposes,
▪ Describe how to optimize databases to the most efficient form,
▪ Distinguish and use relational model and relational algebra,
▪ Identify and fix the possible problems that may occur in securing data.
COURSE CONTENT:
Topic Duration (Week)
Chapter 1: Introduction 1-2
1.1. Data Handling approaches
1.2. Roles in Database Design & Development
1.2.1. Data and Database Administrator
1.2.2. Database Designer
1.2.3. Application Programmer
1.2.4. End-Users
1.3. The ANSI-SPARC Architecture
1.4. Functions of DBMS
1.5. Data models and conceptual models
1.6. Database Languages (DDL, DML, DCL)
Chapter 2: Relational Data Model 3-4
2.1. Terminologies
2.2. Relational Constraints
2.3. Relational Integrity
2.4. Key constraints
2.5. Referential constraints
2.6. Relational languages and views
2.7. Relational DBMS
Chapter 3: Conceptual Database Design- E-R Modeling 5-7
3.1. Database Development Life Cycle
3.2. Basic concepts of E-R model
3.3. Problem with E-R models
3.4. Enhanced E-R models
Chapter 4: Logical Database Design 9-10
4.1. Normalization
4.2. Process of normalization (1NF, 2NF, 3NF)
Chapter 5: Physical Database Design 11-12
5.1. Physical database design process
5.2. Database design and implementation for relational databases
Chapter 6: Query Languages 13-14
6.1. Relational Algebra
6.2. Relational calculus
6.3. Structured Query Languages (SQL)
Chapter 7: Advanced Database Concepts 15
7.1. Integrity and security
7.2. Integrity
7.3. Data security
7.4. Client-server systems
7.5. Distributed Database Systems
7.6. Data warehousing and data Mining
Summary of Teaching Learning Methods:
The learning–teaching methodology will be student-centered with appropriate guidance of
instructor/s during the students ‘activities. There will be Lecture, Demonstrations, Lab work
Tutorials, Reading assignments and Group Discussions
Summary of Assessment Methods: - As per the academic regulation.
References:
▪ Connolly T., Beg C. and Strachan A.: Database Systems, 2nd, 3rd and 4th ed. Addison-
Wesley Publishing Company.
▪ RamezElmasri, Shamkant B. Navathe , Fundamentals of Database Systems( 4thed ) , USA,
Addison-Wesley, 2004
▪ C.J. DATE, Introduction to Database systems (8thed), USA, Addison Wesley, 2003
Abraham Silberschatz, Henry F.
▪ Korth, S. Sudarshan, Database System Concepts (4thed), USA, McGraw Hill Inc.,
2002.