Faculty of Engineering Handbook

DATABASE SYSTEMS


Subject Code:	ECP3076
Objective:	To provide a basic understanding of the concepts and types of Computer Database, examine theoretical and pragmatic ideas underlying relational databases, and discuss certain other aspects of database systems - recovery, concurrency, security, and integrity. Upon completion of this course, the students should be able to outline architecture for a database system, define and manipulate data, and understands transactions process of database systems.
Pre-Requisite:	None
Credit Hours:	3
Contact Hours:	54 hours (lectures and tutorials)
Assessment:	Assignment / Project: 15% Test / Quiz: 15% Lab Expreiments / Tutorial: 10% Final Examination: 60%
References:	Peter Rob, Carlos Coronel, “Database Systems: Design, Implementation, and Management”, Course Technology, 6th Edition, 2003 D. Kroenke, " Database Processing: Fundamentals, Design & Implementation" , Prentice-Hall Business Publishing, 1997. C. J. Date, “An Introduction to Database Systems”, Addison Wesley, 6th Edition, 1999 Ramez Elmasri and Shamkant B. Navathe, “Fundamentals of Database Systems”, Benjamin/Cummings Publishing Co., 2nd Edition, 1994 Connolly, T., Begg, C. & Strachan, A., “Database Systems: A Practical Approach to Design, Implementation and Management”, Addison-Wesley, 1999

Course Contents

Introduction
Overview of Database Systems, Database Systems vs. File Systems, Various aspects of Database Systems, Terminology: model, schema, instance.
Three levels of data abstraction, Database Languages, System Architecture of a Database System, Classification of DBMS.
Data modeling
Entity-Relationship(ER) Model, Entities and Entity types, Relationship and Relationship type, Constraints, Weak Entity Types, ER Diagrams. Semantic object model.
Process of database design
Phase 1 : Requirement Analysis
Phase 2: Conceptual Database Design
Phase 3: Database Schema Design
Database and database application design
Database design using entity-relationship and semantic object models, database application design. Terminology in Relational Data Model, Integrity Constraints, Primitive Operations on Relations, Relational Algebra (RA), Relational Algebra Operations, Relational Completeness, Additional Operations on Relations.
Database implementation
Foundations of relational implementation. Structured Query Language (SQL): DML Features in SQL, DDL in SQL, Updates in SQL, Views in SQL,
Embedded SQL, Query-by-Example (QBE). Concurrency, recovery and security issues.
Functional Dependencies
Amstrong’s Inference Rules and Minimum Covers, Normal Forms: First Normal Form, Second Normal Form, Third Normal Form, Boyce-Codd Normal Form
Trends In Database
Current Trends in Database Systems: Client-Server database systems, Open Database Connectivity (ODBC) standard, Knowledge-Based Systems, Object-Based Systems, data warehousing and data mining concepts, Web databases.

Learning Outcome of Subject

At the completion of the subject, students should be able to:·

explain the various types of computer databases.

describe the theoretical and pragmatic ideas underlying relational databases.

apply data modeling concepts in database design.

apply the normalization methodology to evaluate and design good table structures.

use the commands and functions of SQL to implement relational databases.

explain other aspects of database system such as recovery, concurrency, security and integrity.

outline and design the architecture for a database system, manipulate data, and explain the transactions process of database system.

work in a team to produce a database system.

Programme Outcomes (% of contribution)

Ability to acquire and apply fundamental principles of science and engineering. - 60%

Capability to communicate effectively. -10%

Acquisition of technical competence in specialized areas of engineering discipline. -10%

Ability to identify, formulate and model problems and find engineering solutions based on a system approach. -10%

Understanding and commitment to professional and ethical responsibilities. - 5%

Ability to work effectively as an individual and as a member/leader in a team. - 5%