Module Descriptors
DATABASE ADMINISTRATION AND MANAGEMENT
COIS60814
Key Facts
Faculty of Computing, Engineering and Sciences
Level 6
15 credits
Contact
Leader: Andrew Jones
Hours of Study
Scheduled Learning and Teaching Activities: 24
Independent Study Hours: 126
Total Learning Hours: 150
Assessment
  • COURSEWORK weighted at 50%
  • EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
Module Details
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 one lecture and one practical per week.
(1:n) (1:25)
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, 3 and 4)
Coursework 50% comprising a research topic that culminates in an individual report (3000 words) or a group poster display on a chosen aspect of database administration (Learning outcome 4). Note that the choice of assessment method may vary from year to year to be decided by the Module Leader.
Module Special Admissions Requirements
None.
Module Texts
Database Systems. A Practical Approach to Design, Implementation & Management, Connolly, Begg and Strachan, Addison -Wesley, 5th Edition, 2010, ISBN: 9780321523068
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 Resources
Various DBMS environments such as Microsoft Access, Oracle, MySQL etc.