CS1DBNU: Databases
Module code: CS1DBNU
Module provider: Computer Science; School of Mathematical, Physical and Computational Sciences
Credits: 20
Level: Level 1 (Certificate)
When you'll be taught: Double Presentation: Semester 1 / 2
Module convenor: Dr Luis Patino, email: j.l.patinovilchis@reading.ac.uk
NUIST module lead: Ruyun Tian, email: tianry@nuist.edu.cn
Pre-requisite module(s):
Co-requisite module(s):
Pre-requisite or Co-requisite module(s):
Module(s) excluded:
Placement information: NA
Academic year: 2024/5
Available to visiting students: No
Talis reading list: No
Last updated: 21 May 2024
Overview
Module aims and purpose
This module is designed to introduce students how to design a database through applying specific data models, implement a database in a relational environment, and manage a database system to effectively structure, store, access and retrieve data. A database development takes the methodological steps of identify the entities and their attributes, create entity table and define relationships between the tables, set constraints for ensuring data integrity and consistency, populate the tables with data, create virtual views of the data to users, and create indexes for frequent queries in the data table.
Students will also be able to demonstrate their abilities in:
- creative problem-solving and critical thinking;
- end-user needs awareness and testing; and
- teamworking in developing solutions.
Module learning outcomes
By the end of the module, it is expected that students will be able to:
- Create data schema for relational database and describe relational algebra for operating data;
- Implement a relational database as back-end of software applications based on requirements of a domain context;
- Use a suite of Structured Query Language (SQL), including DDL, DML, DCL and TCL sub-languages, to perform data manipulation and data retrieval in relational databases; and
- Apply data security measures to ensure the confidentiality, integrity, and availability of the data stored in the database.
Module content
The module covers the following topics:
- Introduction to databases and a role of databases played in software applications
- Relational databases modelling using Entity-Relationship (E-R) design technique
- Normalization in relational database, i.e., 1NF, 2NF, 3NF, for optimal database performance
- Relational database programming, e.g., algebraic and logical query language, SQL suite, constraints and triggers
- Validation of databases for accuracy, consistency, and completeness
- Other popular types of databases, e.g., NoSQL and Object-Oriented DB
Structure
Teaching and learning methods
This module will take a problem-based learning approach. The lectures will introduce students the theories, concepts and underpinning principles specified in the module content. Students will be supervised in the practical sessions to apply the concepts and principles to a given problem context and develop a database solution. The lectures and practical sessions will enable students to inquiry innovative solutions, and critically apply the database design and implementation methods and techniques.
There will also be learning materials in digital forms when they are required to support learning.
There are two types of assessment (i.e., formative assessment and summative assessment) which will support and reinforce students’ learning. A formative assessment is carried out through weekly learning activities. Summative assessment consists of one piece of written coursework assignment which requires students to demonstrate both individual and group achievements. Appropriate feedback will be timely communicated with students for enhancing learning.
This module is taught twice to two different cohorts of students - first in Semester 1 and then repeated in Semester 2. The 200 study hours are listed for the first iteration of teaching in Semester 1, and these same study hours are repeated for the second iteration of teaching in Semester 2.
Study hours
At least 44 hours of scheduled teaching and learning activities will be delivered in person, with the remaining hours for scheduled and self-scheduled teaching and learning activities delivered either in person or online. You will receive further details about how these hours will be delivered before the start of the module.
Scheduled teaching and learning activities | Semester 1 | Semester 2 | Summer |
---|---|---|---|
Lectures | 22 | ||
Seminars | |||
Tutorials | |||
Project Supervision | |||
Demonstrations | |||
Practical classes and workshops | |||
Supervised time in studio / workshop | |||
Scheduled revision sessions | 22 | ||
Feedback meetings with staff | |||
Fieldwork | |||
External visits | |||
Work-based learning | |||
Self-scheduled teaching and learning activities | Semester 1 | Semester 2 | Summer |
---|---|---|---|
Directed viewing of video materials/screencasts | |||
Participation in discussion boards/other discussions | |||
Feedback meetings with staff | |||
Other | |||
Other (details) | |||
Placement and study abroad | Semester 1 | Semester 2 | Summer |
---|---|---|---|
Placement | |||
Study abroad | |||
Independent study hours | Semester 1 | Semester 2 | Summer |
---|---|---|---|
Independent study hours | 156 |
Please note the independent study hours above are notional numbers of hours; each student will approach studying in different ways. We would advise you to reflect on your learning and the number of hours you are allocating to these tasks.
Semester 1 The hours in this column may include hours during the Christmas holiday period.
Semester 2 The hours in this column may include hours during the Easter holiday period.
Summer The hours in this column will take place during the summer holidays and may be at the start and/or end of the module.
Assessment
Requirements for a pass
Students need to achieve an overall module mark of 40% to pass this module.
Summative assessment
Type of assessment | Detail of assessment | % contribution towards module mark | Size of assessment | Submission date | Additional information |
---|---|---|---|---|---|
In-person written examination | Exam | 50 | 2 hours | Semester 1, Weeks 17-20 | Answer 3 out of 4 questions |
Written coursework assignment | Technical report | 50 | 20 hours, 7 pages (excluding appendices), | Semester 1, Week 11 |
Penalties for late submission of summative assessment
The Support Centres will apply the following penalties for work submitted late:
Assessments with numerical marks
- where the piece of work is submitted after the original deadline (or any formally agreed extension to the deadline): 10% of the total marks available for that piece of work will be deducted from the mark for each working day (or part thereof) following the deadline up to a total of three working days;
- the mark awarded due to the imposition of the penalty shall not fall below the threshold pass mark, namely 40% in the case of modules at Levels 4-6 (i.e. undergraduate modules for Parts 1-3) and 50% in the case of Level 7 modules offered as part of an Integrated Masters or taught postgraduate degree programme;
- where the piece of work is awarded a mark below the threshold pass mark prior to any penalty being imposed, and is submitted up to three working days after the original deadline (or any formally agreed extension to the deadline), no penalty shall be imposed;
- where the piece of work is submitted more than three working days after the original deadline (or any formally agreed extension to the deadline): a mark of zero will be recorded.
Assessments marked Pass/Fail
- where the piece of work is submitted within three working days of the deadline (or any formally agreed extension of the deadline): no penalty will be applied;
- where the piece of work is submitted more than three working days after the original deadline (or any formally agreed extension of the deadline): a grade of Fail will be awarded.
The University policy statement on penalties for late submission can be found at: https://www.reading.ac.uk/cqsd/-/media/project/functions/cqsd/documents/qap/penaltiesforlatesubmission.pdf
You are strongly advised to ensure that coursework is submitted by the relevant deadline. You should note that it is advisable to submit work in an unfinished state rather than to fail to submit any work.
Formative assessment
Formative assessment is any task or activity which creates feedback (or feedforward) for you about your learning, but which does not contribute towards your overall module mark.
The weekly practical sessions are used for conducting the formative assessment where feedback is provided to help develop understanding and enhance database development skills throughout the term. In lectures and practical sessions, interactive discussions and exercises will be employed alongside peer assessment.
Reassessment
Type of reassessment | Detail of reassessment | % contribution towards module mark | Size of reassessment | Submission date | Additional information |
---|---|---|---|---|---|
In-person written examination | Exam | 100 | 3 hours | During the NUIST resit period | Answer 4 out of 6 questions |
Additional costs
Item | Additional information | Cost |
---|---|---|
Computers and devices with a particular specification | ||
Required textbooks | ||
Specialist equipment or materials | ||
Specialist clothing, footwear, or headgear | ||
Printing and binding | ||
Travel, accommodation, and subsistence |
THE INFORMATION CONTAINED IN THIS MODULE DESCRIPTION DOES NOT FORM ANY PART OF A STUDENT'S CONTRACT.