CE53701-6 Database Administration and Management

Various DBMS environments such as Microsoft Access, Oracle etc

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.

There will be a series of practical exercises that build into a portfolio. For example students could be asked to consider a case study a produce and justify an access strategy for various users.

Normally one lecture, one practical per week.
(1:n) (1:25)

Please note that these texts are only indicative reading. Similar texts are appropriate.

Course ILT: Oracle Database 10g: Administration Thomson 2005 ISBN: 1-4188-1107-6
Database Systems. A Practical Approach to Design, Implementation & Management, Connolly, Begg and Strachan, Addison -Wesley, 2nd Edition, 1998, ISBN 0201342871

Introduction to Database Systems, C.J. Date, Addison-Wesley, 7th Edition, 1999, ISBN 0201684195

Examination two hours 50% (LOs 1,2,3)
A portfolio of practical exercises demonstrating knowledge of DBA roles 50% (LO 4)

Review of database architecture and its effect on data base administration and control
DBA tools
Log and diagnostic files, recovery
Data dictionaries and their use to a DBA
Storage structures and table management
Index management
User and resource control to aid security