Module Catalogue 2020/21

CSC2024 : Database Technology (Inactive)

  • Inactive for Year: 2020/21
  • Module Leader(s): Professor 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.

Teaching Methods

Module leaders are revising this content in light of the Covid 19 restrictions.
Revised and approved detail information will be available by 17 August.

Reading Lists

Assessment Methods

Module leaders are revising this content in light of the Covid 19 restrictions.
Revised and approved detail information will be available by 17 August.

Timetable

Past Exam Papers

General Notes

N/A

Disclaimer: The information contained within the Module Catalogue relates to the 2020/21 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 2021/22 entry will be published here in early-April 2021. Queries about information in the Module Catalogue should in the first instance be addressed to your School Office.