Module Descriptors
DATABASE ADMINISTRATION AND MANAGEMENT (D/L)
COIS51059
Key Facts
Faculty of Computing, Engineering and Sciences
Level 5
15 credits
Contact
Leader: Andrew Jones
Hours of Study
Scheduled Learning and Teaching Activities: 3
Independent Study Hours: 147
Total Learning Hours: 150
Assessment
  • PORTFOLIO weighted at 100%
Module Details
Module Resources
A suitable DBMS environment (e.g. MySQL)
Module Special Admissions Requirements
None.
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 Learning Strategies
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.
Module Additional Assessment Details
100% (LO 1-4) A portfolio of weekly tasks submitted on-line
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