skip to content



Business Computing BSc (Hons)


Module CM0429 - Relational Databases

(20.00 Credits)



SYNOPSIS This module aims to introduce the student to the theoretical and practical elements of relational databases. It will cover the creation and management of relational databases. It will include different kinds of querying and data manipulation in order to extract required data from a relational database. It will include relational database systems (e.g. Oracle, MySQL, Access) to allow the student to understand their purpose and varying suitabilities. Teaching and learning will take the form of a series of lectures supported by practical workshop sessions and self study tasks. The workshop sessions are designed to provide an opportunity for the student to gain practical experience based on the material covered in the lectures and will support the assessment of the module via formative feedback. The assessment will be a series of practical tasks (50%) scheduled throughout the two semesters, plus a final exam (50%).


INDICATIVE READING LIST OR OTHER LEARNING RESOURCES Core text The Relational Databases Lecture Notes and Workshop Exercises Additional reading Date,C.J. (2005) Database in Depth: Relational Theory for Practitioners O’Reilly Stanzyk, S. Champion, B. Leyton, R. (2001)Theory and Practice of Relational Databases. (2nd ed.) CRC Press Oracle Technology Network (2007) Available at: http://www.oracle.com/technology/index.html (Accessed:13 June 2007) Date,C.J. (2004) An Introduction to Database Systems. 8th edn. Addison-Wesley Elmasri,R. & Navathe,S.B. (2007) Fundamentals of Database Systems. 5th edn. Addison-Wesley Connolly,T. & Begg,C. (2005) Database Systems: A Practical Approach to Design, Implementation & Management. 4th edn. Addison-Wesley van der Lans, R. (2007) Introduction to SQL: Mastering the Relational Database Language. 4th edn. Addison-Wesley


OUTLINE SYLLABUS • Databases: nature, purpose, use and administration (20%) • The Relational Database Model and Design (including ERDs and similar methodologies) (25%) • Structured Query Language (SQL) (45%) • Relational database management system considerations (10%)


AIMS OF MODULE To introduce the concept of the relational model and to provide an understanding of how to develop, query and maintain the relational model in a database management system (DBMS).


LEARNING OUTCOMES By the end of the module students should be able to: 1 Recognise and describe the main features of the Relational Database Model and how to implement it using Structured Query Language (SQL) 2 Understand a given relational database design (e.g. ERD) and implement it using SQL 3 Maintain a relational database 4 Design queries using Relational Algebra and implement them using SQL


LEARNING, TEACHING AND ASSESSMENT STRATEGY Teaching and learning will take the form of a series of lectures supported by practical workshop sessions. There will also be a self study document with exercises to support the relational and SQL elements. The workshop sessions are designed to provide an opportunity for the student to gain practical experience based on the material covered in the lectures. Students will be expected to undertake a program of directed study to support the taught sessions. Small example databases will be used where appropriate to reinforce the theories being taught. The student’s practical understanding of the principles covered throughout the module will be assessed by a series of small practical milestone tasks. These are scheduled throughout the two semesters and are worth 50% of the module marks There is a final examination at the end of semester 2 to assess the students’ theoretical understanding of the principles covered throughout the module. The exam plays an important role in ensuring assessment integrity, and its emphasis is upon the application of knowledge. It contributes the final 50% of the module marks.


IMPLICATIONS FOR CHOICE Pre-requisite for CM0552 Database Programming


ASSESSMENT STRATEGY Assessments A Series of small problems 50% Semester 1 (LOs 1 - 4) Semester 2 B Exam (LOs 1, 2, 3, 4) 50% Semester 2



Other Modules within Business Computing BSc (Hons)


Year 1

Year 2

Year 3

Year 4

 

 Back to Previous Page   |   Advanced Course Search   |   Browse All Courses


Was this page useful to you?

Northumbria University has taken reasonable care to ensure that the information published is accurate at the time of publication. However, the University gives no warranty or representation as to the quality, accuracy or completeness of the information.



Share this page |