MA332-5-AU-CO:
Databases and data processing with SQL
2022/23
Mathematics, Statistics and Actuarial Science (School of)
Colchester Campus
Autumn
Undergraduate: Level 5
Current
Thursday 06 October 2022
Friday 16 December 2022
15
08 December 2023
Requisites for this module
(none)
(none)
(none)
(none)
(none)
BSC 5B43 Statistics (Including Year Abroad),
BSC 9K12 Statistics,
BSC 9K13 Statistics (Including Placement Year),
BSC 9K18 Statistics (Including Foundation Year),
BA Q120 Linguistics with Data Science,
BA Q121 Linguistics with Data Science (Including Foundation Year),
BA Q122 Linguistics with Data Science (Including Placement Year),
BA Q123 Linguistics with Data Science (Including Year Abroad)
Relational databases and SQL are developed and used as a fundamental tool for relevant applications from different disciplines including humanities, life sciences, linguistics, marketing and social science. They are essential to the efficient information management for IT systems and commercial applications in almost all modern organisations.
The purpose of this module is to provide students with an introduction to the underlying principles and practical experience of the implementation of relational databases. It will cover the data modelling and SQL, database analysis, management, and advanced topics including big data, security and privacy issues of modern databases.
To provide students with an introduction to the underlying principles and practical experience of the implementation of relational databases.
A. The ability to apply conceptual data models, and relational databases
B. The ability to use SQL to manipulate data in a database
C. The ability to implement a database using SQL and DBMS
Introduction to Database and SQL:
Background; database environment and examples; Database architecture; Database programming; SQL
Relational Model and SQL:
Relational Database Model; SQL SELECT Queries, Creating Table, Altering Table, Data Manipulation
Database analysis and management:
Entity Relationship Diagrams; Normalisation of Database Tables; Database management via DBMS
Advanced topics:
Distributed DBMS; big data issues; security and privacy of databases
Teaching will be delivered in a way that blends face-to-face classes, for those students that can be present on campus, with a range of online lectures, teaching, learning and collaborative support.
This module does not appear to have a published bibliography for this year.
Assessment items, weightings and deadlines
Coursework / exam |
Description |
Deadline |
Coursework weighting |
Coursework |
SQL Lab Test |
|
40% |
Coursework |
Application Lab Test |
|
60% |
Exam format definitions
- Remote, open book: Your exam will take place remotely via an online learning platform. You may refer to any physical or electronic materials during the exam.
- In-person, open book: Your exam will take place on campus under invigilation. You may refer to any physical materials such as paper study notes or a textbook during the exam. Electronic devices may not be used in the exam.
- In-person, open book (restricted): The exam will take place on campus under invigilation. You may refer only to specific physical materials such as a named textbook during the exam. Permitted materials will be specified by your department. Electronic devices may not be used in the exam.
- In-person, closed book: The exam will take place on campus under invigilation. You may not refer to any physical materials or electronic devices during the exam. There may be times when a paper dictionary,
for example, may be permitted in an otherwise closed book exam. Any exceptions will be specified by your department.
Your department will provide further guidance before your exams.
Overall assessment
Reassessment
Module supervisor and teaching staff
Dr Vasileios Giagos, email: v.giagos@essex.ac.uk.
Dr Felipe Maldonado
v.giagos@essex.ac.uk
Yes
Yes
Yes
Dr Yinghui Wei
University of Plymouth
Available via Moodle
Of 84 hours, 40 (47.6%) hours available to students:
24 hours not recorded due to service coverage or fault;
20 hours not recorded due to opt-out by lecturer(s), module, or event type.
Disclaimer: The University makes every effort to ensure that this information on its Module Directory is accurate and up-to-date. Exceptionally it can
be necessary to make changes, for example to programmes, modules, facilities or fees. Examples of such reasons might include a change of law or regulatory requirements,
industrial action, lack of demand, departure of key personnel, change in government policy, or withdrawal/reduction of funding. Changes to modules may for example consist
of variations to the content and method of delivery or assessment of modules and other services, to discontinue modules and other services and to merge or combine modules.
The University will endeavour to keep such changes to a minimum, and will also keep students informed appropriately by updating our programme specifications and module directory.
The full Procedures, Rules and Regulations of the University governing how it operates are set out in the Charter, Statutes and Ordinances and in the University Regulations, Policy and Procedures.