MA332-7-AU-CO:
Databases and data processing with SQL

The details
2023/24
Mathematics, Statistics and Actuarial Science (School of)
Colchester Campus
Autumn
Postgraduate: Level 7
Current
Thursday 05 October 2023
Friday 15 December 2023
15
15 February 2024

 

Requisites for this module
(none)
(none)
(none)
(none)

 

(none)

Key module for

MSC G30412 Data Science,
MSC G30424 Data Science,
MSC G304PP Data Science with Professional Placement,
MSC G30512 Applied Data Science,
MSC G30524 Applied Data Science,
MSC G30612 Data Science and its Applications,
MSC G30624 Data Science and its Applications,
MPHDG30448 Data Science,
PHD G30448 Data Science

Module description

Relational databases and SQL are developed and used as fundamental tools for relevant applications from different disciplines including humanities, life sciences, linguistics, marketing, and social science. They are essential to 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 data modelling and SQL, database analysis, management, and advanced topics including big data, security and privacy issues of modern databases.

Module aims

The aim of this module is:



  • To provide students with an introduction to the underlying principles and practical experience of the design and implementation of relational databases.

Module learning outcomes

By the end of this module, students will be expected to be able to:



  1. Gain systematic, extensive and comparative knowledge and understanding of conceptual data models, relational databases and database designs.

  2. Gain comprehensive knowledge and familiarity with SQL to manipulate data in a database.

  3. Gain systematic, extensive and comparative knowledge and understanding of the ability to design and implement a database using SQL and DBMS

Module information

Syllabus



  • 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, design and management 


Entity Relationship Diagrams; Normalisation of Database Tables; Database Design; Database construction and application; Database management via DBMS



  • Advanced topics 


Distributed DBMS; big data issues; security and privacy of databases; introduction to NonSQL databases with linguistics and text analytics applications.

Learning and teaching methods

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.

Bibliography

The above list is indicative of the essential reading for the course.
The library makes provision for all reading list items, with digital provision where possible, and these resources are shared between students.
Further reading can be obtained from this module's reading list.

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

Coursework Exam
100% 0%

Reassessment

Coursework Exam
100% 0%
Module supervisor and teaching staff
Dr Vasileios Giagos, email: v.giagos@essex.ac.uk.
Dr Vas Giagos
maths@essex.ac.uk

 

Availability
Yes
Yes
Yes

External examiner

Dr Yinghui Wei
University of Plymouth
Resources
Available via Moodle
Of 116 hours, 36 (31%) hours available to students:
60 hours not recorded due to service coverage or fault;
20 hours not recorded due to opt-out by lecturer(s), module, or event type.

 

Further information
Mathematics, Statistics and Actuarial Science (School of)

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.