IS4S703 - ICT Systems Development 01 Sep 2023 - 31 Aug 2028 | Version 6
Associated Module Information
| Module Code: | IS4S703 | ||
|---|---|---|---|
| Module Title: | ICT Systems Development | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Information and Electronics | ||
| Faculty Sub Group: | informatics | ||
| Module Leader: | Mitchel Langford | ||
| Module Team: | Robert Berry, Neil Lewis | ||
| First Intended Intake: | NOV 2015 | Final Year of Intake: | |
| Date Closed: | |||
| Credit Value: | 20 | Credit Level: | 7 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | 100371 - information systems | ||
| HECOS Code Weighting: | 100 | ||
Document Version Information
| Version | 6 |
|---|---|
| Valid From | 01 Sep 2023 |
| Valid To | 31 Aug 2028 |
Module Aims
To demonstrate a critical understanding of current and developing data models and database systems.
To exercise autonomy and judgement in the selection of optimal solutions to database-related problems.
To determine and use appropriate design and modelling techniques to develop advanced database system applications within legislative constraints.
Content Summary
Features of DBMS:
Transaction processing, ACID properties, concurrency, locking, security, integrity, access, backup and recovery.
DBMS management & administration. Relevant legislation, such as protection of personal data.
Database performance: overview of storage and access methods, indexing, b-trees.
Advanced database technologies such as data warehouses and data marts, distributed and graph databases, ‘big data’ and NoSQL database systems.
Spatial databases:
Fundamental types of spatial data. Sources. Storage and transfer formats.
Creating/managing spatial databases. Data preparation. Importing spatial and non-spatial data.
Spatial database concepts. Spatial reference systems. Spatial indexing. Flat-Earth and geodetic data.
Queries and analyses in a spatial database; using SQL/MM spatial functions.
Serving spatial data to a desktop GIS and web browser clients.
Learning and Teaching Methods
| Activity Type | Hours |
|---|---|
| Lecture | 24 |
| Tutorial | 24 |
| Independent Study | 80 |
| Directed Study | 72 |
| Total Hours Selected | 200 |
Learning Outcomes
| # | Learning Outcome |
|---|---|
| LO1 | To demonstrate a critical understanding of the prevailing technologies associated with current and developing data models and database systems. |
| LO2 | To understand advanced database technology and develop the ability to analyse requirements and design an appropriate solution for a complex problem using design and modelling techniques. |
Module Requisites
N/A
Assessment Criteria
| Assessment Category | Assessment Type | Description | Duration | Word Count | Weight (%) | Best of? | Pass Mark |
|---|---|---|---|---|---|---|---|
| Asynchronous Assessment | Practical Written Work 2 | Implement and Query Spatial database | 0 | 2000 | 50 | No | 40 |
| Asynchronous Assessment | Practical Written Work 1 | Data Storage and ETL | 0 | 2000 | 50 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Practical Written Work 2 | ✔ | ✔ | |
| Practical Written Work 1 | ✔ | ✔ | |