Course Information
COMP3278 Introduction to database management systems

COMP3278 Introduction to database management systems

2017-18
Instructor(s):Chui C K
(Class A) No. of credit(s):6
Chui C K
(Class B)
Recommended Learning Hours:
Lecture: 31.0
Tutorial: 8.0
Pre-requisite(s):COMP2119 or CSIS1119 or ELEC1502 or ELEC1503 or ELEC2543
Co-requisite(s):  
Mutually exclusive with:BUSI0052 or 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)

COMP3278A
COMP3278B