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 will teach apprentices both theoretical and practical aspects of the design and implementation of database systems. Apprentices will gain knowledge and hands-on experience in data modelling and using database management languages and tools. The current module is based on WM164 Smart Solutions Development I (Programming) and feeds into advanced data processing modules such as WM3B7 Data Science and Machine Learning.
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.
Data model,
Three tier architectures,
Entity-relationship model,
Conversion of binary relationships ,
Sub-classing,
Weak entity sets,
Relational model,
Relational data model,
Relational algebra,
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,
Conceptual design,
Logical data base design,
Physical database design,
Generalization and aggregation,
Data quality,
Data security
Learning outcomes
By the end of the module, students should be able to:
- Describe the role of data management systems in managing organisational data and information.
- Describe data management system-related techniques and tools.
- Describe how to use database management systems to perform basic queries to synthesise information and present it concisely.
- Describe the relevant legal, ethical, social and security standards to a database system solution, and the factors affecting these.
- Describe different data sources, formats, and structures, and how to extract data from different sources.
- Describe how to use different database management systems to handle structured and unstructured data.
- Describe the approaches to data processing, including data modelling and data-driven decision making such as reducing data redundancy.
Indicative reading list
View reading list on Talis Aspire
Subject specific skills
SQL language, database management tools, entity relation diagram, NoSQL, SQL injection, database security and performance
Transferable skills
Team working, problem-solving, oral and written communication
Study time
| Type | Required |
|---|---|
| Lectures | 30 sessions of 1 hour (6%) |
| Tutorials | 30 sessions of 1 hour (6%) |
| Demonstrations | (0%) |
| Work-based learning | 64 sessions of 1 hour (13%) |
| Online learning (independent) | 52 sessions of 1 hour (10%) |
| Other activity | 4 hours (1%) |
| Private study | 196 hours (40%) |
| Assessment | 120 hours (24%) |
| Total | 496 hours |
Private study description
No private study requirements defined for this module.
Other activity description
Exam support sessions and PMA support sessions.
About WBL hours: work-related activities using databases.
Costs
No further costs have been identified for this module.
You must pass all assessment components to pass the module.
Assessment group D
| Weighting | Study time | Eligible for self-certification | |
|---|---|---|---|
Assessment component |
|||
| Post Module Assessment | 60% | 72 hours | Yes (extension) |
|
Post Module Assessment – 3000 words report on the design of a database project for a given scenario. |
|||
Reassessment component is the same |
|||
Assessment component |
|||
| In Module Assessment | 40% | 48 hours | No |
|
In Module Assessment - Computer-based exam using database management tools |
|||
Reassessment component is the same |
|||
Feedback on assessment
Feedback will be given as appropriate to the assessment type:
– In Module Assessment: written cohort-level feedback.
– Post Module Assessment: written summative feedback on post module assessment.
Pre-requisites
To take this module, you must have passed:
Courses
This module is Core for:
- Year 1 of DWMS-H655 Undergraduate Digital and Technology Solutions (Cyber) (Degree Apprenticeship)
- Year 1 of DWMS-H652 Undergraduate Digital and Technology Solutions (Data Analytics) (Degree Apprenticeship)
- Year 1 of DWMS-H653 Undergraduate Digital and Technology Solutions (Network Engineering) (Degree Apprenticeship)
- Year 1 of DWMS-H654 Undergraduate Digital and Technology Solutions (Software Engineering) (Degree Apprenticeship)