Access to a PC and Internet connection.

Various DBMS environments such as Microsoft Access, VBA-SQL.

Blackboard. Access to the on-line library and web-based resources.

Note: resources need to be available at home or in the workplace.

None.

A portfolio of tasks to be submitted o-line 50% (Learning outcomes 1, 2, 3 and 4)
A report (1,500 words) on chosen aspects of database administration 50% (Learning outcomes 1, 2 and 3)

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.

The style of the module is based on a series of on-line worksheets 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 worksheets. You will build up an on-line portfolio as you proceed. Electronic learning strategies will be used extensively.

The 3 hours contact time will typically include provision of On-line, telephone and email support as necessary. Students will be welcome to visit their tutors at the University by arrangement but this will not be required.

Please note that these texts are only indicative reading. Similar texts are appropriate.
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
Database Systems Concepts, Korth & Silberschatz, McGraw Hill, 4th Edition, 2001, ISBN 0071217622