Module Details
| Module Code: |
INFO6032 |
| Title: |
Business Data Management
|
|
Long Title:
|
Business Data Management
|
| NFQ Level: |
Fundamental |
| Valid From: |
Semester 1 - 2022/23 ( September 2022 ) |
| Field of Study: |
4820 - Information Systems
|
| Module Description: |
This module deals with databases and their central role in information management. It also introduces students to the basics of business intelligence, business analytics, and data protection and ethics.
|
| Learning Outcomes |
| On successful completion of this module the learner will be able to: |
| # |
Learning Outcome Description |
| LO1 |
Build a relational database in the area of finance or marketing. |
| LO2 |
Generate reports, perform advanced database queries, format reports, integrate database with other applications. |
| LO3 |
Describe the significance of databases as the backbone of Information Systems. |
| LO4 |
Identify the importance of Business Analytics and Business Intelligence to modern businesses. |
| LO5 |
Outline basic issues regarding Data Protection, Privacy and Ethics. |
| Dependencies |
Module Recommendations
This is prior learning (or a practical skill) that is strongly recommended before enrolment in this module. You may enrol in this module if you have not acquired the recommended learning but you will have considerable difficulty in passing (i.e. achieving the learning outcomes of) the module. While the prior learning is expressed as named MTU module(s) it also allows for learning (in another module or modules) which is equivalent to the learning specified in the named module(s).
|
| None |
Incompatible Modules
These are modules which have learning outcomes that are too similar to the learning outcomes of this module. You may not earn additional credit for the same learning and therefore you may not enrol in this module if you have successfully completed any modules in the incompatible list.
|
| None |
Co-requisite Modules
|
| No Co-requisite modules listed |
Requirements
This is prior learning (or a practical skill) that is mandatory before enrolment in this module is allowed. You may not enrol on this module if you have not acquired the learning specified in this section.
|
| No requirements listed |
| Indicative Content |
|
Database
Creating and Managing Relational Databases;
Forms: tab order, moving and sizing controls, adding and deleting fields, subforms, importing spreadsheets, multi-table forms.
Advanced queries: using the expression builder to perform calculations, summarising groups of records, display top or bottom values, parameter queries, crosstab queries; Reports: grouping, sorting, summarising, inserting formulas manually; charts; Create labels, merge data.
|
|
Database Processing
Components of a Database System: Database Application, Database Management System (DBMS) and Database; Features of a Database System: Tables, Queries, Forms, Reports; Enterprise DBMS vs. Personal DBMS; Data Models: Entities, Relationships, Cardinality; Normalisation;
Data Quality.
|
|
Business Intelligence
Reporting: Basic Reporting, RFM Analysis, OLAP; Data Mining: Unsupervised, Supervised, Market Bucket Analysis; Decision Tree;
Data Warehouses and Data Marts.
Business Analytics;
|
|
Data Protection, Privacy & Ethics
Data Protection Commissioner, Personal Data, Sensitive Data, Data Protection Rights and Rules, Data Protection Acts, Case Studies, e.g. Social Media;
Privacy; Ethics: Codes of Conduct, Surveillance.
|
|
Module Content & Assessment
|
| Assessment Breakdown | % |
|---|
| Coursework | 100.00% |
Assessments
| No End of Module Formal Examination |
| Reassessment Requirement |
Repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.
|
The University reserves the right to alter the nature and timings of assessment
Module Workload
| Workload: Full Time |
| Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
| Lecture |
Contact |
Presentation of Theory Topics |
Every Week |
2.00 |
2 |
| Lab |
Contact |
Computer Lab |
Every Week |
2.00 |
2 |
| Independent & Directed Learning (Non-contact) |
Non Contact |
Self directed study |
Every Week |
3.00 |
3 |
| Total Hours |
7.00 |
| Total Weekly Learner Workload |
7.00 |
| Total Weekly Contact Hours |
4.00 |
| Workload: Part Time |
| Workload Type |
Contact Type |
Workload Description |
Frequency |
Average Weekly Learner Workload |
Hours |
| Lecture |
Contact |
Presentation of Theory Topics |
Every Week |
0.50 |
0.5 |
| Lab |
Contact |
Computer Lab |
Every Week |
1.50 |
1.5 |
| Independent & Directed Learning (Non-contact) |
Non Contact |
Self-directed Study |
Every Week |
5.00 |
5 |
| Total Hours |
7.00 |
| Total Weekly Learner Workload |
7.00 |
| Total Weekly Contact Hours |
2.00 |
|
Module Resources
|
| Recommended Book Resources |
|---|
-
David M. Kroenke, Randall J. Boyle. (2021), Using MIS, 12th. 12, Pearson, Boston, [ISBN: 978013692165].
-
Alan Dillon. (2014), Step by Step Databases, 3rd. Gill & Macmillan, Dublin, p.384, [ISBN: 9780717160433].
| | Supplementary Book Resources |
|---|
-
Kenneth Laudon, Jane P. Laudon. (2020), Management Information Systems: Managing the Digital Firm, 16th. 15, Pearson Education, Upper Saddle River, NJ, p.656, [ISBN: 9781292296562].
| | This module does not have any article/paper resources |
|---|
| Other Resources |
|---|
-
Website, ComputerWeekly.com,
-
Website, Business.com,
-
Website, TechTarget,
-
Website, Enterprise Ireland,
|
|
