The role and use of Databases and Information Systems in Organisations
Introduction to data modelling and entity relationship diagrams
Set Theory and Venn Diagrams
Introduction to the corresponding documentation around data modelling
entity descriptions, Data dictionaries, entity life histories
CASE tools
Introduction to the concept and use of Database Management systems (DBMS)

• SQL, DML, DDL and DCL
• Developing applications with database tools
•I nformation Retrieval
• Levels of Information
• Data and Information Management
• Systems Architectures

Database Administration
Database security and recovery

Module Launch (10 hours)
There will be a module launch during which 10 hours of face to face contact will be devoted to tasks which are designed to provide useful insights into the module content and purpose. This module launch will include group work and the investigation of case study scenarios.

Guided Learning (11 hours)
A module tutor who is part of the teaching team of the module will be allocated to you and you will meet them during the launch. Following the launch, there will be some materials on the VLE which are designed to guide your learning. Additionally, there will be at least one hour per week of contact time for the eleven weeks following the launch. This will be used for learning guided led by your module tutor. It will be a face to face presentation if you are on day release. For online learners it will be flipped classroom approach with group (up to 20) seminars.

Reviews:
• Tutorial reviews for online learners (0.5 hour per student)
Online learners will have 2 tutorial sessions with their module tutor during the course of the module. These will be individual or small group sessions during which your module tutor will be able to answer any queries that you have regarding module work. The review weeks are listed in the module handbook and mentors will be invited to join the call and provide feedback.

• Tutorial sessions for day release learners (at least 0.5 hours per student)
There will scheduled tutorial sessions (up to 20 students) during the 11 weeks following the launch which will take the place of the tutorial reviews for day release students.

Independent learning (128.5 hours)
The module leader will provide resources through the virtual learning environment which will include videos and presentations as well as links to useful websites. Other academic learning will be achieved through reading around the subject area. Module tutors will suggest useful texts, though many others will be suitable and can be found in our e-library. If you require help understanding any of the concepts, you may contact your module tutor for assistance.

Part of your independent learning will take place in your workplace under the guidance of your mentor. You will complete a work-based learning agreement to ensure that arrangements are in place at your workplace to facilitate this work-based learning. You are encouraged to endeavour to apply your growing academic knowledge to improve your work practice and to reflect on your work-based experiences to improve your learning.

You will be required to complete assignment work during independent learning time. Assignment work for a 15 credit module at level 4 should take around 50 hours to complete.

Additional help with learning
You will have access to the departmental librarian and you will also have an academic coach who will organise group coaching sessions to guide you through your academic journey with us. As a student, you are more than welcome to visit the university at any time and to use the resources. During time at the university, you may arrange to meet your module tutor or academic coach for additional help.

COURSEWORK WEIGHTED AT 100%
Group work: 60% Learning outcomes 1-3
A structured report (2000 words) containing:
• Analysis documentation
• Design models and associated documentation
• A working database which corresponds to the design
• A User Manual
• A report containing a requested query statements and their output with discussion relating to the level and use of the information retrieved

A 1 hour class test covering database administration (40%) Learning outcome 4

You will need access to these resources:

The VLE
An ICT Workplace environment. A Work-Based Learning Agreement will be completed for this module to ensure that the student will have access to the required resources in the workplace.

The Internet and office software
Staffordshire University has subscriptions to electronic book services such as Safari Tech Books, Ebrary and Netlibrary. There are titles in each of the collections that will support students studying this module.

Access to PHPmyadmin (or similar) environment
Use of a case tool such as QSee Superlite

Systems Analysis and Design : Techniques, Methodologies, Approaches, and Architectures (Available as e-book in University library), Chiang, Roger Siau, Keng Hardgrave, Bill C. 2009 , M.E. Sharpe, Inc (Edition: 4)

Designing Effective Database Systems (Available as e-book in University library), Riordan, R.M., 2005, Addison-Wesley Professional, ISBN-10: 0321290933 (Edition: 1)

Information Systems Development: Methodologies, Techniques and Tools, Avison, G., Fitzgerald D.,2006. McGraw-Hill, ISBN-10: 0077114175 (Edition: 4)

Database Systems. A Practical Approach to Design, Implementation & Management, Connolly, Begg and Strachan, Addison -Wesley, 2nd Edition, 1998

Introduction to Database Systems, C.J. Date, Addison-Wesley, 7th Edition, 1999

Database Systems Concepts, Korth & Silberschatz, McGraw Hill, 4th Edition, 2001

1. DEMONSTRATE KNOWLEDGE AND UNDERSTANDING OF DATABASE ARCHITECTURE AND THE METHODOLOGIES APPROPRIATE FOR THE ANALYSIS AND DESIGN OF DATABASES
Knowledge & Understanding

2. APPLY APPROPRIATE METHODS AND CREATE DOCUMENTATION COVERING ALL ASPECTS OF ANALYSIS AND DESIGN OF A DATABASE USING A SUITABLE CASE TOOL AND MEETING APPROPRIATE STANDARDS. Analysis
Application
Problem Solving

3. CONSTRUCT A DATABASE WHICH CONFORMS TO THE DESIGN MODEL USING A STANDARD SET OF TECHNIQUES.
Application
Problem Solving

4. DEMONSTRATE THE ABILITY TO MANAGE DATA, RETRIEVE INFORMATION AND PRESENT IT IN AN APPROPRIATE WAY.
Knowledge & Understanding
Application