WM264-30 Smart Solutions Development-II (Databases)
Introductory description
Industries store a large amount of data for their day to day operations. The data related to customers, employees and machines are all managed using a database management system (DBMS). The data can be organized and can be accessed at any point for operations management using DBMS.
Module aims
This module introduces the theoretical basis of databases and how relational databases can be developed. It will equip students to understand organizational information requirements and can model data solutions using conceptual data modeling techniques. The database design and solutions will be discussed using industry-standard DBMS. The fundamental concepts related to data quality and security will be discussed.
An introduction to structured query language (SQL) will be included which will enable students to extract data from the DBMS. The introduction of a developing user interface will be covered which can be used for accessing data from DBMS. A part of the course will focus on designing, implementing, testing and debugging databases including front end development according to user requirements so in an effect full stack development will be covered.
Outline syllabus
This is an indicative module outline only to give an indication of the sort of topics that may be covered. Actual sessions held may differ.
Introduction to databases
- Function & components
- Data model
- Three tier architectures
Entity relationship model - Conversion of binary relationships
- Sub-classing
- Weak entity sets
Relational model - Relational data model
- Relational algebra
Introduction to SQL - Simple queries: Insert, update, delete commands
- Multi- statements transaction
- System constraints
- Queries on multiple tables
Normalization - Normalization process
- 3rd normal form
Object oriented Databases - Distributed databases
- Client/server Systems
- Data warehouses
- Object-oriented databases
System- oriented methodologies - Conceptual design
- Logical data base design
- Physical database design
Database design & modelling for systems - Modelling system requirements
- User- centric design
- Generalization and aggregation
- Data quality
- Data security
Learning outcomes
By the end of the module, students should be able to:
- Know the role of data management systems in managing organisational data and information, and use a high-level language to create user interface for accessing data from DBMS.
- Describe the logical and conceptual data modelling, make entity relationship model for incorporating system and user requirements.
- Use SQL to perform simple queries including adding, updating and deleting queries.
- Identify the data redundancy problems and update anomalies, apply data normalization techniques to combat the data redundancy problem.
- Use analytical and critical thinking skills to technology solutions development, analyse and apply structured problem-solving techniques to complex systems and situations
Indicative reading list
- G. Tillmann, “Usage driven database design: from logical data modelling through physical schema definition”, Apress, 2017, ISBN: 9781484227220.
- J. L. Harrington, “ Relational database design and implementation”, Elsevier, 2016, ISBN: 9780128499023
- C. Mancas, “Conceptual data modelling and database design: a fully algorithmic approach”, Academic Press, 2016, ISBN: 9781771881241.
View reading list on Talis Aspire
Subject specific skills
SQL language, database management tools, entity relation diagram
Transferable skills
Team working, problem-solving, oral and written communication
Study time
| Type | Required |
|---|---|
| Lectures | 30 sessions of 1 hour (10%) |
| Tutorials | 30 sessions of 1 hour (10%) |
| Practical classes | 20 sessions of 1 hour (7%) |
| Work-based learning | 160 sessions of 1 hour (53%) |
| Private study | 30 hours (10%) |
| Assessment | 30 hours (10%) |
| Total | 300 hours |
Private study description
30 hours guided self-study including:
- Pre-block reading list given on Moodle to encourage flipped learning approach
- Pre-block online Quizzes
- Pre-block exercises given on Moodle.
- Post block reading list published on Moodle that helps students to do Individual projects.
- Post-block problem sets released on Moodle.
- Post block online Quizzes for revision
- Post-block reading list on ‘Advance topics relating to databases’ is published to encourage the outperforming students
- Online links for learning programming step by step published on Moodle to help the struggling students.
- Online forum for discussing queries with course peers and tutor.
- Online consulting session for providing one to one support to help struggling students.
- Online tutor-recorded videos.
- Distance learning support using technology enhanced learning.
Costs
No further costs have been identified for this module.
You must pass all assessment components to pass the module.
Assessment group A
| Weighting | Study time | Eligible for self-certification | |
|---|---|---|---|
Assessment component |
|||
| In Module Assessment | 40% | 6 hours | Yes (extension) |
|
Database design incorporating functional and non-functional requirements |
|||
Reassessment component is the same |
|||
Assessment component |
|||
| Post Module Assessment | 60% | 24 hours | Yes (extension) |
|
Report on a work-based project related to data models that represent the business domain, documented database design and a fit-for-purpose database solution. |
|||
Reassessment component is the same |
|||
Feedback on assessment
Feedback will be given as appropriate to the assessment type:
– verbal formative feedback on in module assessment,
– written cohort-level feedback on the exam,
– written summative feedback on post module assessment.
There is currently no information about the courses for which this module is core or optional.