|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.
- 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%)
- 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%)
||54 hours (lectures and tutorials)
- 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.
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.
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.
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.
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.