Module Descriptors
RELATIONAL DATABASE SYSTEMS DEVELOPMENT (D/L)
COIS50361
Key Facts
Faculty of Computing, Engineering and Sciences
Level 5
15 credits
Contact
Leader: Jonathan Westlake
Email: J.C.Westlake@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 3
Independent Study Hours: 147
Total Learning Hours: 150
Assessment
- ASSIGNMENT weighted at 50%
- PORTFOLIO weighted at 50%
Module Details
Module Additional Assessment Details
An ASSIGNMT weighted at 50%. A PORTFOLIO of tasks weighted at 50%.
Portfolio of online tasks and short tests (50%) administered through Blackboard. Learning outcomes 1 and 3.
Assignment 50%. Students will produce a prototype database system including table, relationships, queries, forms, reports and macros. They will also present their results in a 15 minute on-line presentation. Learning outcomes 2 and 4. The system produced would normally be relevant to the student's place of work or occupation.
Portfolio of online tasks and short tests (50%) administered through Blackboard. Learning outcomes 1 and 3.
Assignment 50%. Students will produce a prototype database system including table, relationships, queries, forms, reports and macros. They will also present their results in a 15 minute on-line presentation. Learning outcomes 2 and 4. The system produced would normally be relevant to the student's place of work or occupation.
Module Texts
Access 2007 in Easy Steps. Unswairth, Andrew (2007) Computer Step ISBN 1-84078-320-6
SQL in Easy Steps. McGrath, Mike (2005) Computer Step ISBN 1-84078-296
SQL in Easy Steps. McGrath, Mike (2005) Computer Step ISBN 1-84078-296
Module Indicative Content
The module will concentrate on:
The fundamentals of RDBMS (Relational Database management System) and related ADE (Application Development Environments)
Analysis and Design using ERDs (Entity Relationship Diagrams)
Logical data modelling (definition of tables and relationships).
Data typing and validation
Table Normalisation
Data manipulation using query design and SQL
Forms design including: forms accessing multiple tables, sub-forms and HCI aspects of form design.
Report design including reports accessing multiple tables and data grouping.
Basic Relational ADE automation including: design of toolbars and linking objects (eg, forms, reports, toolbars) together using a programming language.
Students will demonstrate their abilities in the above areas in practical terms by the production of an exemplar application which they submit in the assignment.
In addition the module will provide a basic and theoretical introduction to the following topics:
RDBMS performance (tuning)
Referential integrity (management)
RDBMS administration (of multi-user systems)
RDBMS security (of multi-user systems)
The fundamentals of RDBMS (Relational Database management System) and related ADE (Application Development Environments)
Analysis and Design using ERDs (Entity Relationship Diagrams)
Logical data modelling (definition of tables and relationships).
Data typing and validation
Table Normalisation
Data manipulation using query design and SQL
Forms design including: forms accessing multiple tables, sub-forms and HCI aspects of form design.
Report design including reports accessing multiple tables and data grouping.
Basic Relational ADE automation including: design of toolbars and linking objects (eg, forms, reports, toolbars) together using a programming language.
Students will demonstrate their abilities in the above areas in practical terms by the production of an exemplar application which they submit in the assignment.
In addition the module will provide a basic and theoretical introduction to the following topics:
RDBMS performance (tuning)
Referential integrity (management)
RDBMS administration (of multi-user systems)
RDBMS security (of multi-user systems)
Module Resources
Access to a PC and Internet connection.
MS ACCESS 2007 or MySOL
VBA-SQL
Blackboard. Access to the on-line library and web-based resources.
Note: resources need to be available at home or in the workplace
MS ACCESS 2007 or MySOL
VBA-SQL
Blackboard. Access to the on-line library and web-based resources.
Note: resources need to be available at home or in the workplace
Module Special Admissions Requirements
None.
Module Learning Strategies
On-line resources will be used to present the information through Blackboard which will include activities and formative questions to help the student's assimilation of the module material.
Practical tasks will be set to develop the necessary knowledge and skills. These will be suitable for the student to complete at home or in their place of work.
On-line, telephone and email support will be provided as necessary. Students will be welcome to visit their tutors at the University by arrangement but this will not be required.
Practical tasks will be set to develop the necessary knowledge and skills. These will be suitable for the student to complete at home or in their place of work.
On-line, telephone and email support will be provided as necessary. Students will be welcome to visit their tutors at the University by arrangement but this will not be required.