| Course Description |
In this module, the student acquires an understanding of the capabilities and limits of database systems and develops skills in designing databases that perform efficiently and fulfill the user requirements.
After completing this module, the students should be able to:
•translate a prose specification, which may be ambiguous and vague, into an explicit data model,
•evaluate various database storage schemes for their appropriateness, given the expected access behaviour of database application,
•normalize data schema to eliminate redundancies,
•write efficient query code,
•apply semantic rules to transform high level queries into low level ones,
•write database application in high level languages using appropriate language bindings,
•indentify critical query sequences that must be transactionalized.
|
