Unity University
Course Number COSC2072
Course Title Fundamentals of Database Management
System
Degree Program BSc. In Computer Science
Credits/Contacts 3/4
Prerequisite COSC2071
Semester 2nd Semester / Year II
Status of Course Compulsory
Course Description This course introduces students with database
concepts, architecture for database systems,
implications of file organization and storage
structures, database models (Hierarchical,
Network, and Relational data model), database
design, basics of Relational Algebra and
relational calculus; SQL, and QBE.
Course Objectives At the end of the Course students should be able
and Competences to to:
be acquired
Understand the role of a database in an
organization
Identify the different Relational Database
Management Systems( RDBMS)
Explain the different models of database,
Identify requirements for database design
Be able to Design Conceptual data Model
Be Able to map a conceptual data model to
a logical data model
Be able to normalize a logical data model
Be able to transform a logical data model
to a physical data model
Write statements for data creation and
manipulation purposes,
Distinguish and use relational model and
relational algebra,
Course Contents 1 Introduction
1.1 Overview of Database
1.2 Manual file handling systems and
limitations
1.3 Traditional File based systems
1.4 Database approach
1.5 Functions and Components of DBMS
1.6 Database Development Lifecycle
1.7 Roles in database design environment
1.8 Database Languages (DDL, DML, DCL,
TCL)
2 Relational Model
2.1 Terminology
2.2 Data models
2.3 Relational Constraints
2.4 Relational languages and views
2.5 Relational DBMS
3 Conceptual Database Design – E-R
modeling
3.1 Basic concepts of E-R model
3.2 Structural constraints
3.3 Problem with E-R models
3.4 Enhanced E-R models
4 Logical Database Design
4.1 Normalization
4.2 Purpose of normalization
4.3 Functional dependencies
4.4 Different Normal Forms
4.5 Process of normalization
5 Physical Database Design
5.1 Design considerations
5.2 Physical database design process
5.3 Database design and implementation for
relational databases
6 Query Languages
6.1 Relational algebra
6.2 Relational calculus
6.3 Structured Query Languages
Teaching and Lecture, Reading Assignments and
learning Methods Presentations
Class Works
Laboratory Sessions
Project work
Assessment/ Theoretical Tests (10%)
Evaluation and Assignments (10%)
Grading System
Practical Tests (15%)
Project Work (15%)
Final Exam (50%)
Text Books 1. Database Systems: A Practical Approach to
Design, Implementation, and Management
(6th Edition)by Thomas Connolly and Carolyn
Begg | 2014
Reference Materials 1. Fundamentals of Database Systems (7th
Edition)by Ramez Elmasri and Shamkant B.
Navathe , 2015
2. Database Systems: Introduction to
Databases and Data Warehouses
by NenadJukic , Susan Vrbsky, et al. , 2016
3. Database Systems: A Practical Approach to
Design, Implementation, and Management
(6th Edition)by Thomas
Connolly and Carolyn Begg | 2014
4. Abraham Silberschatz, Henry F. Korth, S.
Sudarshan. 2010. Database System
Concepts (6th ed). ISBN-10 0071244763.
1024 p.
5. Database Processing. Fundamentals,
Design and Implementation by David M.
Kroenke, 13th Ed. 2013
