CC2006 - Data Modelling and Database Systems (2017/18)
|Module specification||Module approved to run in 2017/18, but may be subject to modification|
|Module title||Data Modelling and Database Systems|
|Module level||Intermediate (05)|
|Credit rating for module||15|
|School||School of Computing and Digital Media|
|Running in 2017/18||No instances running in the year|
Introduces techniques for analysing, designing and implementing database systems. An
understanding of data modelling and design concepts is provided and database programming language skills are taught.The practical aspect of developing database systems is emphasised and use is made of a popular, commercial database system (e.g. Oracle) for this purpose.
Prior learning requirements
Introduction to Programming (CC1006N / CC1F06N)
Business and Information Systems (CC1001C)
The principal graduate attribute focused on in the module is A2.
The module aims to give an introduction to the issues governing the design and implementation
of database systems. The module provides an introduction to both the theoretical aspects of designing sound database systems as well as the practical aspects of implementing such systems. The module, therefore, allows students to understand, and put into practice, the techniques available for analysing, designing and developing database systems [A2].
Databases and Database Management Systems: architectural framework, data independence.
Data analysis and modelling: conceptual data model notation, Entity-Relationship modelling, normalisation theory.
Database models: historical background, hierarchical, network, relational models.
Relational database theory: the model and its terminology, primary/foreign keys, integrity constraints, logical schema transformation.
Relational Database languages: querying, insertion, deletion, update, views and reporting with SQL.
Relational Algebra: algebriac operations, reference to SQL.
Learning and teaching
Formal lectures (1 hour per week) will be delivered where the aim will be to communicate theoretical aspects of data analysis and design. Students will gain knowledge of the techniques available for database design during these lectures. In order to augment the lecture material and give students the opportunity to apply these techniques, there will be weekly tutorial sessions (1 hour) which will be conducted in the form of group discussions or individual exercises – the choice depending on the type of material to be covered.
This module develops practical knowledge of a DBMS and weekly workshop sessions (2 hours) will be designed to ensure that all students receive adequate hands-on experience of an appropriate package. In addition students will spend time on directed, unsupervised learning for which an indication of relevant material (book chapters, journals and other publications) will be given. Students should also explore the software package and gain proficiency at using it.
On successful completion of this module students will be able to:
LO1 - Produce an Entity-Relationship model from a realistic problem specification [A2]
LO2 - Use formal design techniques (e.g. normalisation) to produce a database schema [A2]
LO3 - Design and implement a database system from a conceptual data model [A2]
LO4 - Manipulate and extract data residing in a database using relational algebra and SQL [A2]
LO5 - Discuss the relative merits of the relational environment [A2]
The assessment will consist of two components: an unseen examination (2 hours) and one coursework (10 to 20 learning hours).
The assessment strategy for this module represents the duality of the learning process for this subject. On the one hand, students need to be assessed on their ability to absorb and apply theoretical material such as design notation and modelling. Whilst on the other hand, students also need to be assessed on their ability to demonstrate practical proficiency of a popular DBMS environment. The learning outcomes encompass both theoretical and practical aspects and the assessment strategy needs to reflect both these elements.
The assessment strategy ensures that students can demonstrate practical knowledge (LO3, LO4) which they would have acquired during the workshop sessions, with the use of a practical coursework element. The assessment strategy also allows students to demonstrate their knowledge of theoretical aspects (LO1, LO2, LO5) of the subject area, such as relational algebra, with the use of an unseen examination.
Connolly, T. & Begg, C. Database Systems - A Practical Approach to Design, Implementation, and Management (2nd Ed.) Addison-Wesley 2005
Ritchie, C. Relational Database Principles (2nd Ed.) Continuum, 2002
Kroenke, D. Database Concepts, Prentice Hall 2003
McFadden, F. R., Hoffer, J. A. & Prescott, M. B. Modern Database Management (7th Ed.) Pearson, 2005
Shah, N. Database Systems Using Oracle, Prentice Hall 2002
Kline, K. with Kline, D. SQL in a Nutshell - A Desktop Quick Reference O'Reilly, 2001
Earp, R. & Bagui, S. Learning SQL A Sep-by-Step Guide using Oracle, Addison-Wesley, 2003