- Student Records
Programme & Unit Catalogues

MN50641: Databases & business intelligence

Follow this link for further information on academic years Academic Year: 2017/8
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.

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)

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