Module Description
The aims of this module are to extend the principles of SQL database modelling laid down in the first year, to describe the field of Information Retrieval, to introduce the concept of NoSQL databases and hence to compare the strengths and weaknesses of all three approaches to information access.
Learning Outcomes
After completing this module, students will be expected to be able to:
1. Understand SQL database modelling and normalisation;
2. Appreciate the principles of Information Retrieval;
3. Apply and evaluate IR in a practical context;
4. Discuss differences between models such as SQL, IR and NoSQL.
Outline Syllabus
• Inference Rules for Functional Dependencies
• Closure of Attributes and Keys
• Relational design by analysis
• Theory of normalisation, functional and join dependencies
• Multivalued dependencies and higher normal forms
• Projecting Functional Dependencies
• Validation and security in databases
• Analytical databases and business intelligence
• Introduction to NoSQL Databases
• Principles of Information Retrieval
• Comparison of SQL, IR and NoSQL paradigms
Learning & Teaching Methods
Lectures, Laboratories and Classes
Assessment
This module is 70% Exam and 30% Coursework