Module Descriptors
RELATIONAL DATABASE SYSTEMS DEVELOPMENT
COIS50861
Key Facts
Digital, Technology, Innovation and Business
Level 5
15 credits
Contact
Leader: Tomasz Bosakowski
Email: T.Bosakowski@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
- GROUP ASSIGNMENT weighted at 50%
- EXAMINATION- UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
Module Details
Module Indicative Content
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 present in assignment 1) as well as in the exam.
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 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 present in assignment 1) as well as in the exam.
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 Learning Strategies
Weekly Lecture (1 hour/week).
Lab Work (1 hour/week)
Weekly Tutorial (1 hour/week)
Group Work
(1:n) (1:25) (1:25)
Lab Work (1 hour/week)
Weekly Tutorial (1 hour/week)
Group Work
(1:n) (1:25) (1:25)
Module Resources
Suitable RDBMS and associated interface software e.g Microsoft Access, Online Tutorials.
Module Texts
Grauer, R. & Lockley, M., (2008), Exploring Microsoft Access 2007, Comprehensive, Prentice Hall, ISBN 0131567888
Roman, S. (2002), AccessDatabase Design and Programming, 3rd edition, O'Reilly. ISBN 0-59600-273-4
Roman, S. (2002), AccessDatabase Design and Programming, 3rd edition, O'Reilly. ISBN 0-59600-273-4
Module Special Admissions Requirements
None.
Module Additional Assessment Details
Exam 50% - 1.5 hours. Learning outcomes 1, 3 and 4.
Group 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 presentation. Learning outcomes 1, 2 and 4.
Group 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 presentation. Learning outcomes 1, 2 and 4.