Centralised Online Undergraduates Registration System (CORS)


Module Detailed Information for [CS4221]
Academic Year : 2018/2019 Semester : 2
Correct as at 21 Feb 2019 05:00

Back to Module Information Listing
Module Information
Module Code :
Module Title : Database Applications Design and Tuning
Module Description : This module addresses the design and performance tuning of database applications. The syllabus focusses on relational database applications implemented with relational database management systems. Topics covered include normalisation theory (functional, multi-valued and join dependency, normal forms, decomposition and synthesis methods), entityrelationship approach and SQL tuning (performance evaluation, execution plan verification, indexing, de-normalization, code level and transactions tuning). The syllabus optionally includes selected topics in the technologies, design and performance tuning of non-relational database applications (for instance, network and hierarchical models and nested relational model for an historical perspective, as well as XML and NoSQL systems for a modern perspective).
Module Examinable : -
Exam Date : No Exam Date.
Modular Credits : 4
Pre-requisite : CS3223
Preclusion : CS5421
Module Workload (A-B-C-D-E)* : 2-1-0-3-4
Remarks : Nil
* A: no. of lecture hours per week
B: no. of tutorial hours per week
C: no. of laboratory hours per week
D: no. of hours for projects, assignments, fieldwork etc per week
E: no. of hours for preparatory work by a student per week

Lecture Time Table
Class TypeWeek TypeWeek DayStartEndRoom

Tutorial Time Table
Attention: The tutorial timetables could be updated from time to time. Students are advised to check regularly for the latest update on the change of tutorial timing.
Class TypeWeek TypeWeek DayStartEndRoom Iteration
Available in Tutorial Balloting [Iteration 2].

  NUS Help NUS Home Search Site Map Contact NUS Legal