Advanced Database Management
| Code | School | Level | Credits | Semesters |
| BUSI3210 | Nottingham University Business School China | 3 | 10 | Autumn China |
- Code
- BUSI3210
- School
- Nottingham University Business School China
- Level
- 3
- Credits
- 10
- Semesters
- Autumn China
Summary
This module covers advanced knowledge on database management including the theory and practice of relational and distributed databases. It explores the design of relational databases using the entity relationship diagram. Advanced Structured Query Language will be covered including complex calculations in SELECT statements. Temporal data type functions are included in the module.
The basic principles and working mechanisms of distributed databases will be studied, as well as cutting-edge developments in big data and NoSQL.
Pre-Requisites： BUSI2118 Database Design and Implementation
Target Students
Part 2 Business School Students
Classes
- One 1-hour-30-minute lecture each week for 11 weeks
- One 1-hour laboratory each week for 4 weeks
Assessment
- 30% Group coursework (1,500 words): Group coursework, 1500 words
- 70% 1.5 hour exam (1-hour-30-minute): 1.5 hour exam
Assessed by end of autumn semester
Educational Aims
This module aims to develop to an advanced level students’understanding of database management and implementation. Advanced database design tools and structured query language are taught in this model. In addition, the module covers data models, database performance, and distributed databases, which provides students with an in-depth understanding of database concepts.Learning Outcomes
Discuss how data is modelled to reflect real world business.
Analyse data using advanced structured query language including temporal analysis, advanced select statement, and SQL analytic functions to resolve business problems.
Measure database performance and optimize queries.
Critically discuss concepts related to distributed database management.
Critically discuss issues related to big data and NoSQL.
Work collaboratively with team members to design a database using advanced entity relationship modelling tools (e.g. extended entity relationship model, entity clustering, and entity integrity).
Conveners
- Dr Qingxin Meng