Module Descriptors
DATABASE ADMINISTRATION AND MANAGEMENT (D/L)
COIS60965
Key Facts
School of Digital, Technologies and Arts
Level 6
15 credits
Contact
Leader: Janet Francis
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 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 Special Admissions Requirements
None
Module Resources
A suitable DBMS environment (e.g. MySQL)
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 Additional Assessment Details
A portfolio (100%) of weekly tasks submitted on-line which will assess Learning Outcomes 1-4.
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