Courses Offered

COMP3278 Introduction to database management systems

COMP3278 Introduction to database management systems

2020-21
Instructor(s):Lam Carmen
(Class A) No. of credit(s):6
Luo Ping
(Class B)
Recommended Learning Hours:
Lecture: 31.0
Tutorial: 8.0
Pre-requisite(s):COMP2119 or ELEC2543
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