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 students both theoretical and practical aspects of the design and implementation of database systems. Students will gain knowledge and hands-on experience in data modeling 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:
- Explain the role of data management systems in managing organisational data and information, describe possible components of a typical database system.
- 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
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 (11%) |
| Tutorials | 8 sessions of 1 hour (3%) |
| Demonstrations | 30 sessions of 1 hour (11%) |
| Private study | 196 hours (74%) |
| Total | 264 hours |
Private study description
Explain the role of data management systems in managing organisational data and information, describe possible components of a typical database system.
Costs
No further costs have been identified for this module.
You must pass all assessment components to pass the module.
Assessment group A1
| Weighting | Study time | Eligible for self-certification | |
|---|---|---|---|
Assessment component |
|||
| In Module Assessment | 40% | 12 hours | No |
|
In Module Assessment - Computer-based in-class test using database management tools |
|||
Reassessment component is the same |
|||
Assessment component |
|||
| Post Module Assessment | 60% | 24 hours | Yes (extension) |
|
Post Module Assessment – 2500 words report on the design of a database project for a given scenario. |
|||
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.
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)