Module Learning Strategies
The style of the module is based on a series of lectures that present material, refer you to internal and external references and guide you in further study. You will be expected to follow these references and others of your own to build on the body of knowledge presented in the lecture. Electronic learning strategies will be used extensively.
Normally a one-hour lecture, a two-hour tutorial, and a one-hour practical per week.
(1:n) (1:20)3
Module Indicative Content
Comparison of different database environments from the following aspects:
Data dictionaries
Database security and recovery
Query languages including an in-depth study of SQL
Database Administration
Distributed databases
Database Tuning
Data warehousing
Object-oriented databases
Emerging Database Technologies
Module Additional Assessment Details
Examination, 2 hours, 50% (Learning outcomes 1, 2, and 3)
Coursework 50% (Learning outcomes 1 and 2)
A research topic that culminates in an individual report (1500 words) or a group poster display on a chosen aspect of database administration. Note that the choice of assessment method may vary from year to year to be decided by the Module Leader.
In addition each student will be required to submit a critical appraisal (1000 words) of another student's research report or poster, including their own findings.
Module Texts
Database Systems. A Practical Approach to Design, Implementation & Management, Connolly, Begg and Strachan (4th Edition), Addison -Wesley, 2004, ISBN: 0321210255
Database Management Systems, Patricia Ward and George Dafoulas, Thomson Learning, 2006, ISBN: 978-184480-452-8
Database Systems: Design Implementation and Management (international edition) Rob, Coronel and Crockett, Cengage, 2008, ISBN: 978-1-84480-732-1
Module Special Admissions Requirements
None.
Module Resources
Various DBMS environments such as Microsoft Access, Oracle, MySQL etc.