Module Descriptors
THE MANAGEMENT OF DATABASE ENVIRONMENTS
COIS70829
Key Facts
Faculty of Computing, Engineering and Sciences
Level 7
15 credits
Contact
Leader: Andrew Jones
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
  • COURSEWORK weighted at 50%
  • EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
Module Details
Module Texts
Database Systems. A Practical Approach to Design, Implementation & Management, Connolly, Begg and Strachan (5th Edition), Addison -Wesley, 2010, ISBN: 978-0321523068
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.
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 one-hour tutorial, and a one-hour practical per week.
(1:n) (1:25)2
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.