Database Systems
 
 
Subject Code: ECP3076
Aim of Subject: 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.
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.
  • Applying data modeling concepts in database design.
  • Applying 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:
  • Ability to acquire and apply fundamental principles of science and engineering(60%)
  • Capability to communicate effectively(10%)
  • Acquisition of technical competence in specialised areas of engineering discipline(10%)
  • Ability to identify, formulate and model problems and find engineering solutions based on a systems 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%)
Assessment Scheme:
  • Lab Experiments/Tutorials - oral assessment at the end of lab(10%)
  • Project / Assignment - group assignment,focus group discussion at tutorial to enhance understanding of basic concepts in lecture(15%)
  • Test Quiz - written exam(15%)
  • Final Exam - written exam(60%)
Teaching and Learning Activities: 54 hours (lectures and tutorials)
Credit Hours: 3
Pre-Requisite: None
References:
  • Peter Rob, Carlos Coronel, “Database Systems: Design, Implementation, and Management”, Course Technology, 5th 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, 1995.
  • 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.

Subject 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.