Module Catalogue 2017/18

CSC2024 : Database Technology

  • Offered for Year: 2017/18
  • Module Leader(s): Dr Paolo Missier
  • Lecturer: Dr John Colquhoun
  • Owning School: Computing
  • Teaching Location: Newcastle City Campus
Semesters
Semester 2 Credit Value: 20
ECTS Credits: 10.0
Pre Requisites
Code Title
CSC1022Programming II
CSC1026Website Design and Construction
Pre Requisite Comment

N/A

Co Requisites
Co Requisite Comment

N/A

Aims

To introduce the fundamentals of database system design and use.

The module introduces the fundamentals of database systems. You will understand and be able to apply the relational data model and be proficient in manipulating database systems. Among the topics covered are: Principles of data models and multi-level architectures; relational data model; user requirements; database conceptual design; relational algebra and calculus; SQL standard; database logical and physical design; transactions; embedded SQL; web interaction (JDBC, Java persistence, front-end design); database management; query processing and optimization; object-relational mapping and associated technology.

Outline Of Syllabus

Information Management – database systems
- Motivation for database systems
- Components of database systems
- DBMS functions
- Database architecture and data independence
- Use of a declarative query language
- Query processing and optimization
Information Management – data modeling
- Data modeling
- Conceptual models (such as entity-relationship)
- Relational data model
Information Management – indexing
- The massive impact of indexes on query performance
- The basic structure of an index;
- Keeping a buffer of data in memory;
- Creating indexes with SQL;
Information Management – relational databases
- Mapping conceptual schema to a relational schema
- Entity and referential integrity
- Relational algebra
Information Management – query languages
- Overview of database languages
- SQL (data definition, query formulation, update sublanguage, constraints, integrity)
- Embedding non-procedural queries in a procedural language
- Stored procedures
Information Management – relational database design
- Database design
- Functional dependency
- Decomposition of a schema; lossless-join and dependency-preservation properties of a decomposition
- Candidate keys, superkeys, and closure of a set of attributes
- Normal forms (1NF, 2NF, 3NF, BCNF)
Others
- Controlling databases from Java programs:
- JDBC
- models and technology for object-relational mapping (Hibernate)
- DBMS architecture and functional components
- query processing, query plans, indexing, query optimisation
- transaction management. Lock-based and timestamp-based concurrency control. Logging and Database Recovery
- database views
- database security and administration issues

Learning Outcomes

Intended Knowledge Outcomes

To be able to describe and discuss:
- the role of database systems in modern computing science.
- approaches to database design.
- models, processes and techniques used in database design.
- fundamentals of database technology.

Intended Skill Outcomes

To be able to:
- produce complex data models and to design corresponding relational database schemas.
- control a database from client applications using embedding techniques with high-level languages such as Java.
- use basic DBA skills.

Graduate Skills Framework

Graduate Skills Framework Applicable: Yes
  • Cognitive/Intellectual Skills
    • Critical Thinking : Present
    • Data Synthesis : Present
    • Active Learning : Present
    • Numeracy : Present
    • Literacy : Present
    • Information Literacy
      • Source Materials : Assessed
      • Synthesise And Present Materials : Present
      • Use Of Computer Applications : Present
  • Self Management
    • Self Awareness And Reflection : Present
    • Planning and Organisation
      • Goal Setting And Action Planning : Present
      • Decision Making : Present
    • Personal Enterprise
      • Innovation And Creativity : Present
      • Initiative : Present
      • Independence : Present
      • Problem Solving : Present
      • Adaptability : Present
  • Interaction
    • Communication
      • Oral : Present
      • Interpersonal : Present
  • Application
    • Occupational Awareness : Present
    • Commercial Acumen
      • Governance Awareness : Present
      • Business Planning : Present
    • Social Cultural Global Awareness : Present
    • Legal Awareness : Present

Teaching Methods

Teaching Activities
Category Activity Number Length Student Hours Comment
Guided Independent StudyAssessment preparation and completion441:0044:00Lecture follow-up
Scheduled Learning And Teaching ActivitiesLecture441:0044:00Lectures
Guided Independent StudyAssessment preparation and completion480:3024:00Revision for end of Semester exam & exam duration
Scheduled Learning And Teaching ActivitiesPractical111:0011:00Practicals
Guided Independent StudyProject work111:0011:00Coursework
Guided Independent StudyIndependent study332:0066:00Background reading
Total200:00
Jointly Taught With
Code Title
CSC2513Database Systems
Teaching Rationale And Relationship

Techniques and theory are presented in lectures. Classroom-based practicals provide experience of designing and building database applications. Further practical work takes place during the private study hours.

Reading Lists

Assessment Methods

The format of resits will be determined by the Board of Examiners

Exams
Description Length Semester When Set Percentage Comment
Written Examination1202A80N/A
Exam Pairings
Module Code Module Title Semester Comment
CSC2513Database Systems2N/A
Other Assessment
Description Semester When Set Percentage Comment
Practical/lab report2M10database programming exercise (10 hours)
Practical/lab report2M10database programming exercise (10 hours)
Assessment Rationale And Relationship

In the written examination the questions will assess fundamental knowledge and understanding of theory and application of database design and usage.
The coursework exercises develop knowledge and competence with the various modelling techniques and other skills acquired during the course.

N.B. This module has both “Exam Assessment” and “Other Assessment” (e.g. coursework). If the total mark for either assessment falls below 35%, the maximum mark returned for the module will normally be 35%.

Timetable

Past Exam Papers

General Notes

N/A

Disclaimer: The information contained within the Module Catalogue relates to the 2017/18 academic year. In accordance with University Terms and Conditions, the University makes all reasonable efforts to deliver the modules as described. Modules may be amended on an annual basis to take account of changing staff expertise, developments in the discipline, the requirements of external bodies and partners, and student feedback. Module information for the 2017/18 entry will be published here in early-April 2017. Queries about information in the Module Catalogue should in the first instance be addressed to your School Office.