The School of Computing and Data Science (https://www.cds.hku.hk/) was established by the University of Hong Kong on 1 July 2024, comprising the Department of Computer Science and Department of Statistics and Actuarial Science.

Courses Offered

COMP3278 Introduction to database management systems

COMP3278 Introduction to database management systems

2024-25
Instructor(s):Cheng Reynold
(Class A) No. of credit(s):6
Luo Ping
(Class B)
Chen Yi
(Class C)
Recommended Learning Hours:
Lecture: 31.0
Tutorial: 8.0
Pre-requisite(s):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 aPLO bPLO cPLO dPLO ePLO fPLO gPLO hPLO iPLO j
CLO 1T,PT,PT,P
CLO 2T,PT,P
CLO 3T,P
CLO 4T,PT,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 model1
Relational model1
Database normalization1
Query languages Mapped to CLOs
Query languages: relational algebra and SQL2
System Design Mapped to CLOs
Data storage3
Indexing3
Query evaluation3
Transaction management3
Application Development Mapped to CLOs
Application Development4

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

Teaching Plan

Please refer to the corresponding Moodle course.

Moodle Course(s)

Don't have an account yet? Register Now!

Sign in to your account

Don't have an account yet? Register Now!

Sign in to your account