- Student Records
Programme & Unit Catalogues


MN50641: Databases & business intelligence

Follow this link for further information on academic years Academic Year: 2019/0
Further information on owning departmentsOwning Department/School: School of Management
Further information on credits Credits: 6      [equivalent to 12 CATS credits]
Further information on notional study hours Notional Study Hours: 120
Further information on unit levels Level: Masters UG & PG (FHEQ level 7)
Further information on teaching periods Period:
Semester 1
Further information on unit assessment Assessment Summary: CW 50%, EX 50%
Further information on unit assessment Assessment Detail:
  • Coursework (CW 0%)
  • Coursework (CW 50%)
  • Examination (EX 50%)
Further information on supplementary assessment Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
Further information on requisites Requisites:
Further information on descriptions Description: Aims:
This unit introduces databases for the storage and retrieval of data as well as tabular and graphical methods of data presentation for deriving managerial insights.

Learning Outcomes:
At the end of this unit, students will be able to:
* Design a database that will best fit the needs of a business in terms of both flexibility and efficiency.
* Use optimised queries to process data and derive managerial insights.
* Visualise processed data in multiple dimensions to maximise its business value.

Skills:
Intellectual skills:
* Identify the underlying data model of a business process (T, F, A)
Practical skills:
* Present multi-dimensional data in tabular and graphical formats (T, F, A)
* Use SQL and Business Intelligence software (T, F, A)
Transferable skills:
* Enhance perspective of data storage and retrieval (T, F)
* Eliminate data duplication to achieve information consistency (T, F)

Content:
Topics covered include basic data types, relational databases, query design, object oriented databases, web databases, data warehousing, Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP), and slice-and-dice methods for data visualization.
Further information on programme availabilityProgramme availability:

MN50641 is a Designated Essential Unit on the following programmes:

School of Management

Notes: