Â鶹´«Ã½

-


CM20255: Databases

Academic Year: 2018/9
Owning Department/School: Department of Computer Science
Credits: 3      [equivalent to 6 CATS credits]
Notional Study Hours: 60
Level: Intermediate (FHEQ level 5)
Period:
Semester 1
Assessment Summary: EX 100%
Assessment Detail:
  • EXAM (EX 100%)
Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
Requisites: Before taking this module you must take CM10227
Description: Aims:
This unit aims to provide a systems-based understanding of data, data modelling, storage, access, retrieval and protection.

Learning Outcomes:
On completion of the unit the students will be able to:
* understand the nature, capture, formal description and representation of data and its processing;
* be conversant with emerging data exchange and database developments such as big data, data mining, meta data and the semantic web.
* be able to critically review the migration towards cloud-based data storage in the context of its professional, legal and ethical implications.

Skills:
Use of IT (T/F, A), Problem Solving (T/F, A).

Content:

* data modelling methodologies such as UML and the e-r model.
* relational model, relational algebra, SQL and normalization,
* metadata, the semantic web, data exchange methods and formats such as XML.
* Datamining, big data and pattern discovery in large datasets.
* cloud-based, distributed data storage and its professional, legal and ethical implications.
Programme availability:

CM20255 is Compulsory on the following programmes:

Department of Computer Science
  • USCM-AFB06 : BSc(Hons) Computer Science (Year 2)
  • USCM-AAB07 : BSc(Hons) Computer Science with Study year abroad (Year 2)
  • USCM-AKB07 : BSc(Hons) Computer Science with Year long work placement (Year 2)
  • USCM-AFB20 : BSc(Hons) Computer Science and Mathematics (Year 2)
  • USCM-AAB20 : BSc(Hons) Computer Science and Mathematics with Study year abroad (Year 2)
  • USCM-AKB20 : BSc(Hons) Computer Science and Mathematics with Year long work placement (Year 2)
  • USCM-AFB09 : BSc(Hons) Computer Science with Business (Year 2)
  • USCM-AAB10 : BSc(Hons) Computer Science with Business with Study year abroad (Year 2)
  • USCM-AKB10 : BSc(Hons) Computer Science with Business with Year long work placement (Year 2)
  • USCM-AFM01 : MComp(Hons) Computer Science (Year 2)
  • USCM-AAM02 : MComp(Hons) Computer Science with Study year abroad (Year 2)
  • USCM-AKM02 : MComp(Hons) Computer Science with Year long work placement (Year 2)
  • USCM-AFM14 : MComp(Hons) Computer Science and Mathematics (Year 2)
  • USCM-AAM14 : MComp(Hons) Computer Science and Mathematics with Study year abroad (Year 2)
  • USCM-AKM14 : MComp(Hons) Computer Science and Mathematics with Year long work placement (Year 2)

Notes:

  • This unit catalogue is applicable for the 2018/19 academic year only. Students continuing their studies into 2019/20 and beyond should not assume that this unit will be available in future years in the format displayed here for 2018/19.
  • Programmes and units are subject to change in accordance with normal University procedures.
  • Availability of units will be subject to constraints such as staff availability, minimum and maximum group sizes, and timetabling factors as well as a student's ability to meet any pre-requisite rules.
  • Undergraduates: .
  • Postgraduates: .