Â鶹´«Ã½

-


MN50641: Databases & business intelligence

Academic Year: 2018/9
Owning Department/School: School of Management
Credits: 6      [equivalent to 12 CATS credits]
Notional Study Hours: 120
Level: Masters UG & PG (FHEQ level 7)
Period:
Semester 1
Assessment Summary: CW 50%, EX 50%
Assessment Detail:
  • Coursework (CW 0%)
  • Coursework (CW 50%)
  • Examination (EX 50%)
Supplementary Assessment:
Like-for-like reassessment (where allowed by programme regulations)
Requisites:
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.
Programme availability:

MN50641 is a Designated Essential Unit on the following programmes:

School of Management

Notes:

  • This unit catalogue is applicable for the 2018/19 academic year only. Students continuing their studies into 2019/20 and beyond should not assume that this unit will be available in future years in the format displayed here for 2018/19.
  • Programmes and units are subject to change in accordance with normal University procedures.
  • Availability of units will be subject to constraints such as staff availability, minimum and maximum group sizes, and timetabling factors as well as a student's ability to meet any pre-requisite rules.
  • Undergraduates: .
  • Postgraduates: .