Courses Offered

COMP3278 Introduction to database management systems

2025-26

Instructor(s):

Chen Yi

(Class A)

No. of credit(s):

Luo Ping

(Class B)

Fang Juanru

(Class C)

Recommended Learning Hours:

Lecture:	31.0
Tutorial:	8.0

Pre-requisite(s):

COMP2118 or COMP2119 or COMP2502 or ELEC2543 or FITE2000

Co-requisite(s):

Mutually exclusive with:

IIMT3601

Remarks:

Course Learning Outcomes

1.	[Information Modeling] Able to understand the modeling of real-life information in a database system.
2.	[Query Languages] Able to understand and use the languages designed for data access.
3.	[System Design] Able to understand the design issues of an efficient and reliable database system.
4.	[Application Development] Able to implement a practical application on a real database.

Mapping from Course Learning Outcomes to Programme Learning Outcomes
	PLO a	PLO b	PLO c	PLO d	PLO j
CLO 1	T,P	T,P			T,P
CLO 2			T,P		T,P
CLO 3				T,P
CLO 4				T,P	T,P

T - Teach, P - Practice
For BEng(CompSc) Programme Learning Outcomes, please refer to here.

Syllabus

Calendar Entry:
This course studies the principles, design, administration, and implementation of database management systems. Topics include: entity-relationship model, relational model, relational algebra, database design and normalization, database query languages, indexing schemes, integrity and concurrency control.

Detailed Description:

Database design	Mapped to CLOs
Entiry-relationship model	1
Relational model	1
Database normalization	1
Query languages	Mapped to CLOs
Query languages: relational algebra and SQL	2
System Design	Mapped to CLOs
Data storage	3
Indexing	3
Query evaluation	3
Transaction management	3
Application Development	Mapped to CLOs
Application Development	4

Assessment:
Written Examination: 50%
Continuous Assessment: 50%

Teaching Plan

Please refer to the corresponding Moodle course.

Moodle Course(s)

Courses Offered

COMP3278 Introduction to database management systems

Sign in to your account

Sign in to your account