CSC2513 : Database Systems
- Offered for Year: 2019/20
- Module Leader(s): Dr John Colquhoun
- Owning School: Computing
- Teaching Location: Newcastle City Campus
|Semester 2 Credit Value:||20|
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; SQL standard; database logical and physical design; database procedures; database management.
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)
- Transaction management in database systems
|Scheduled Learning And Teaching Activities||Lecture||44||1:00||44:00||Lectures|
|Guided Independent Study||Assessment preparation and completion||48||0:30||24:00||Revision for end of semester exam & exam duration.|
|Guided Independent Study||Assessment preparation and completion||44||1:00||44:00||Lecture follow-up|
|Scheduled Learning And Teaching Activities||Practical||11||1:00||11:00||Practicals|
|Guided Independent Study||Project work||11||1:00||11:00||Coursework|
|Guided Independent Study||Independent study||33||2:00||66:00||Background reading|
Teaching Rationale And Relationship
Lectures will be used to introduce the learning material and for demonstrating the key concepts by example. Students are expected to follow-up lectures within a few days by re-reading and annotating lecture notes to aid deep learning.
This is a very practical subject, and it is important that the learning materials are supported by hands-on opportunities provided by practical classes. Students are expected to spend time on coursework outside timetabled practical classes.
Students aiming for 1st class marks are expected to widen their knowledge beyond the content of lecture notes through background reading.
Students should set aside sufficient time to revise for the end of semester exam.
The format of resits will be determined by the Board of Examiners
|Case study||2||M||30||Extended coursework - application case study. 2000 words max.|
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 exercise develops 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%.