Module Descriptors
DATABASE ADMINISTRATION AND MANAGEMENT
COIS60962
Key Facts
School of Digital, Technologies and Arts
Level 6
15 credits
Contact
Leader: Janet Francis
Email: J.Francis@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 24
Independent Study Hours: 126
Total Learning Hours: 150
Assessment
  • EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 100%
Module Details
Module Additional Assessment Details
A two hour examination covering all of the learning outcomes.
In addition there will be weekly formative assessment exercises
Module Resources
A suitable DBMS environment (e.g. MySQL)
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 Texts
Database Systems. A Practical Approach to Design, Implementation & Management, Connolly and Begg, 2010, Addison -Wesley, 5th Edition, , ISBN: 9780321523068

Database Principles: Fundamentals of Design, Implementation and Management (international edition) Coronel, Morris, Rob and Crockett, 2013 Cengage Learning, ISBN: 978-1-4080-4863-4
Module Special Admissions Requirements
None
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. 13 lectures and 13 practicals