Module Descriptors
THE MANAGEMENT OF DATABASE ENVIRONMENTS (D\L)
COIS70692
Key Facts
Digital, Technology, Innovation and Business
Level 7
15 credits
Contact
Leader: Euan Wilson
Email: E.D.Wilson@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 3
Independent Study Hours: 147
Total Learning Hours: 150
Assessment
- PORTFOLIO weighted at 30%
- ASSIGNMENT weighted at 70%
Module Details
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
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
100% in course assessment.
Assignment weighted at 70%. (Learning outcomes 1, 2 and 3). In course assessment, 3000 words written design proposal for a databases scenario.
A portfolio weighted at 30% (learning outcomes 1, 2 and 3). A variety of tasks will be undertaken which can be built up into an on-line portfolio. Short tests administered through Blackboard will be used where appropriate.
Assignment weighted at 70%. (Learning outcomes 1, 2 and 3). In course assessment, 3000 words written design proposal for a databases scenario.
A portfolio weighted at 30% (learning outcomes 1, 2 and 3). A variety of tasks will be undertaken which can be built up into an on-line portfolio. Short tests administered through Blackboard will be used where appropriate.
Module Learning Strategies
On-line materials will exemplify topical issues and best practice case studies.
The practical nature of the module is emphasised by the provision of practical portfolio tasks and an assignment which reflects all the elements of the module.
Using the capabilities of a browser on the Internet, you will learn how to manage database environments. Appropriate software applications for supporting databases will be used.
On-line, telephone and email support will be provided as necessary.
Within this module you will be introduced to and/or be able to develop your:
- Intellectual skills
- Problem solving
- Personal skills for Lifelong Learning
The practical nature of the module is emphasised by the provision of practical portfolio tasks and an assignment which reflects all the elements of the module.
Using the capabilities of a browser on the Internet, you will learn how to manage database environments. Appropriate software applications for supporting databases will be used.
On-line, telephone and email support will be provided as necessary.
Within this module you will be introduced to and/or be able to develop your:
- Intellectual skills
- Problem solving
- Personal skills for Lifelong Learning
Module Texts
Database Systems: A Practical Approach to Design, Implementation and Management, 5/E 2009, Thomas M. Connolly, University of Paisley, Carolyn E. Begg, University of Paisley, ISBN-10: 0321523067, ISBN-13: 9780321523068, Publisher: Addison-Wesley
Database Management Systems 2e 2008, Patricia Ward, Middlesex University, ISBN-13: 9781408007686, ISBN-10: 1408007681, Published by: Cengage Learning EMEA
Database Management Systems 2e 2008, Patricia Ward, Middlesex University, ISBN-13: 9781408007686, ISBN-10: 1408007681, Published by: Cengage Learning EMEA
Module Resources
Access to online library resources
Module website via Blackboard VLE
Access to Internet
Various DBMS environments such as Microsoft Access or MySQL.
Module website via Blackboard VLE
Access to Internet
Various DBMS environments such as Microsoft Access or MySQL.
Module Special Admissions Requirements
None.