Overview of Database Management Systems (DBMS); Entity-Relationship Data Model; Relational Data Model; Functional Dependencies (FD) and Normalization; Relational Algebra; Structured Query Language (SQL); Storage of Relational Data; Indexing Techniques; Query Processing and Optimization; Transaction Management and Concurrency Control
| Academic Units | 3 |
| Exam Schedule | Mon Dec 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time) 09:00-11:00 |
| Grade Type | Letter Graded |
| Department Maintaining | CSC(CE) |
| Prerequisites | CZ1007 & CZ2001(Corequisite) OR CE1007 & CE2001(Corequisite) OR CE1007 & CZ2001(Corequisite) OR CE2001(Corequisite) & CZ1007 OR CE2101(Corequisite) OR CZ2101(Corequisite) |
| Mutually Exclusive | |
| Not Available to Programme | BCE, BCG |
| Not Available to All Programme | (Admyr 2021-onwards) |
| Not Available as PE to Programme | REP(ASEN), REP(BIE), REP(CBE), REP(CE), REP(CVEN), REP(EEE), REP(ENE), REP(MAT), REP(ME) |
| Index | Type | Group | Day | Time | Venue | Remark |
|---|---|---|---|---|---|---|
| 10436 | LEC/STUDIO | SCL2 | THU | 1230-1320 | ONLINE | Teaching Wk10 |
| 10436 | LEC/STUDIO | SCL2 | THU | 1230-1320 | LT3 | Teaching Wk1-9,11-13 |
| 10436 | LEC/STUDIO | SCL2 | MON | 1630-1720 | ONLINE | Teaching Wk10 |
| 10436 | LEC/STUDIO | SCL2 | MON | 1630-1720 | LT3 | Teaching Wk1-9,11-13 |
| 10436 | TUT | SDAF | MON | 1530-1620 | TR+18 | Teaching Wk2-9,11-13 |
| 10436 | TUT | SDAF | MON | 1530-1620 | ONLINE | Teaching Wk10 |
| 10436 | LAB | SDAF | TUE | 1430-1620 | SWLAB1 | Teaching Wk1,3,5,7,9,11,13 |
0930
1030
1130
1230
1330
1430
1530
1630
1730
CZ2007
TUT | TR+18
Teaching Wk2-9,11-13
CZ2007
LEC/STUDIO | ONLINE
Teaching Wk10
CZ2007
TUT | ONLINE
Teaching Wk10
CZ2007
LEC/STUDIO | LT3
Teaching Wk1-9,11-13
CZ2007
LAB | SWLAB1
Teaching Wk1,3,5,7,9,11,13
CZ2007
LEC/STUDIO | ONLINE
Teaching Wk10
CZ2007
LEC/STUDIO | LT3
Teaching Wk1-9,11-13
We would encourage you to review with the following template.
AY Taken: ...
Assessment (Optional): ...
Topics (Optional): ...
Lecturer (Optional): ...
TA (Optional): ...
Review: ...
Final Grade (Optional): ...