IS2S565 - Database Development 01 Jul 2022 - 31 Aug 2028 | Version 5
Associated Module Information
| Module Code: | IS2S565 | ||
|---|---|---|---|
| Module Title: | Database Development | ||
| Faculty: | Faculty of Computing, Engineering and Science | ||
| Faculty Group: | Computing and Mathematics | ||
| Faculty Sub Group: | Informatics | ||
| Module Leader: | Robert Berry | ||
| Module Team: | Mitchel Langford | ||
| First Intended Intake: | Final Year of Intake: | ||
| Date Closed: | |||
| Credit Value: | 20 | Credit Level: | 5 |
| Language: | English | ||
| Percentage of Module Taught in Welsh: | 0 | ||
| Equivalent Module: | |||
| HECOS codes: | 100754 - databases | 100755 - data management | |
| HECOS Code Weighting: | 60 | 40 | |
Document Version Information
| Version | 5 |
|---|---|
| Valid From | 01 Jul 2022 |
| Valid To | 31 Aug 2028 |
Module Aims
• To provide an understanding of database technology and methodology, and to develop the practical skills needed by both system designers and software developers working with relational and spatial databases by addressing the basic principles of design, development and usage
• To explore fundamentals of spatially-enabled databases in a practical, hands-on approach.
Content Summary
Database environment overview: components & functions of a DBMS.
Database development methodology:
• Review of ER Modelling: entities, attributes and relationships, Primary & Foreign Keys, ERDs, resolution of N:M relationships.
• Further application of ER Modelling. Chasm/Fan traps.
• Further application of Normalisation, functional dependency, UNF, (insert, update & delete anomalies). Introduction to 4th and 5th NF.
• Implementation using Oracle SQL (DDL, DML).
• Spatial databases:
• What are they, who uses them, and why? How do they differ from a traditional RDB
• Spatial data. Fundamental type 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 understand standard relational database technology and develop the ability to analyse requirements and design an appropriate solution for a problem of defined scope using relational design and modelling techniques. |
| LO2 | To understand spatial database technology and develop the ability to analyse requirements and design an appropriate solution for a problem of defined scope using spatial 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 | Portfolio 1 | Analyse the requirements and design of solutions for real-world problems. | 0 | N/A | 50 | No | 40 |
| Synchronous Onsite Assessment (Exam) | Onsite Closed Book Examination 1 | An examination that draws on knowledge and material from the module | 120 | N/A | 50 | No | 40 |
Assessment Matrix
| Assessment Type | Learning Outcomes | ||
|---|---|---|---|
| LO1 | LO2 | ||
| Portfolio 1 | ✔ | ✔ | |
| Onsite Closed Book Examination 1 | ✔ | ✔ | |