School: Business and Law

This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.

  • Unit Title

    Databases and Business Intelligence
  • Unit Code

    MAN6905
  • Year

    2026
  • Enrolment Period

    1
  • Version

    5
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Sashah MUTASA

Description

This unit explores the use of relational databases and business intelligence in organisations. It serves as a practical guide to designing, building, and implementing databases to support operational and decision-making objectives. Students will first learn relational database design concepts and the database query language Structured Query Language (SQL) to define and manipulate databases. They will then investigate the application of these databases as business intelligence tools, covering topics such as data mining, and the emerging concept of "big data". For business managers, effective database management for supporting organizational intelligence promises a significant competitive advantage. This unit uses a well-known, standard database management system to ensure that students have a sound understanding and practical knowledge of this important component of any organisation's information systems portfolio.

Learning Outcomes

On completion of this unit students should be able to:

  1. Construct a data model using a standard methodology.
  2. Examine the concepts of databases, data warehouses and business intelligence.
  3. Construct a database in a way that provides business value.
  4. Conceptualise solutions to complex data requirements.
  5. Apply SQL programming skills to create business solutions.

Unit Content

  1. Fundamental relational database concepts.
  2. Introduction to database tools.
  3. Data analysis, abstraction and modelling for business applications.
  4. Data normalisation.
  5. Database creation, SQL programming and problem resolution.
  6. Business intelligence concepts and benefits.
  7. Introduction to Data Warehouse, Data mining, Big Data and Analytics.

Learning Experience

ON-CAMPUS

Students will attend on campus classes as well as engage in learning activities through ECU's LMS

City CampusJoondalupSouth West (Bunbury)
Semester 113 x 3 hour lectureNot OfferedNot Offered
Semester 213 x 3 hour lectureNot OfferedNot Offered

For more information see the Semester Timetable

ONLINE

Students will engage in learning experiences via ECU’s LMS as well as additional ECU learning technologies

Assessment

GS2 GRADING SCHEMA 2 Used for Undifferentiated Pass/Fail units inc. practical units or work-integrated learning

ON CAMPUS
TypeDescription
AssignmentData Modelling Assignment
AssignmentDatabase Development and BI Assignment
ExaminationFinal Exam
ONLINE
TypeDescription
AssignmentData Modelling Assignment
AssignmentDatabase Development and BI Assignment
ExaminationFinal Exam

Disability Standards for Education (Commonwealth 2005)

For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.

Assessment

Students please note: The marks and grades received by students on assessments may be subject to further moderation. Informal vivas may be conducted as part of an assessment task, where staff require further information to confirm the learning outcomes have been met. All marks and grades are to be considered provisional until endorsed by the relevant School Progression Panel.

Academic Integrity

Integrity is a core value at Edith Cowan University, and it is expected that ECU students complete their assessment tasks honestly and with acknowledgement of other people's work as well as any generative artificial intelligence tools that may have been used. This means that assessment tasks must be completed individually (unless it is an authorised group assessment task) and any sources used must be referenced.

Breaches of academic integrity can include:

  • Plagiarism: Copying the words, ideas or creative works of other people or generative artificial intelligence tools, without referencing in accordance with stated University requirements. Students need to seek approval from the Unit Coordinator within the first week of study if they intend to use some of their previous work in an assessment task (self-plagiarism).
  • Unauthorised collaboration (collusion): Working with other students and submitting the same or substantially similar work or portions of work when an individual submission was required. This includes students knowingly providing others with copies of their own work to use in the same or similar assessment task(s).
  • Contract cheating: Organising a friend, a family member, another student or an external person or organisation (e.g. through an online website) to complete or substantially edit or refine part or all of an assessment task(s) on their behalf.
  • Cheating in an exam: Using or having access to unauthorised materials in an exam or test.

Serious outcomes may be imposed if a student is found to have committed one of these breaches, up to and including expulsion from the University for repeated or serious acts.

ECU's policies and more information about academic integrity can be found on the student academic integrity website.

All commencing ECU students are required to complete the Academic Integrity Module.

Assessment Extension

In some circumstances, Students may apply to their Unit Coordinator to extend the due date of their Assessment Task(s) in accordance with ECU's Assessment Procedure - for more information visit https://askus2.ecu.edu.au/s/article/000001386.

Special Consideration

Students may apply for Special Consideration in respect of a final unit grade, where their achievement was affected by Exceptional Circumstances as set out in the Assessment Procedure - for more information visit https://askus2.ecu.edu.au/s/article/000003318.

MAN6905|5|1

School: Business and Law

This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.

  • Unit Title

    Databases and Business Intelligence
  • Unit Code

    MAN6905
  • Unit Type

    Learning Unit
  • Year

    2026
  • Enrolment Period

    2
  • Version

    6
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Nelson LEUNG

Description

This unit explores the use of relational databases and business intelligence in organisations. It serves as a practical guide to designing, building, and implementing databases to support operational and decision-making objectives. Students will first learn relational database design concepts and the database query language Structured Query Language (SQL) to define and manipulate databases. They will then investigate the application of these databases as business intelligence tools, covering topics such as data mining, and the emerging concept of "big data". For business managers, effective database management for supporting organizational intelligence promises a significant competitive advantage. This unit uses a well-known, standard database management system to ensure that students have a sound understanding and practical knowledge of this important component of any organisation's information systems portfolio.

Capabilities

In this unit, students will be developing the following capabilities:

  1. DIGITAL LITERACY
  2. CRITICAL THINKING
  3. COMMUNICATION

Unit Content

  1. Fundamental relational database concepts.
  2. Introduction to database tools.
  3. Data analysis, abstraction and modelling for business applications.
  4. Data normalisation.
  5. Database creation, SQL programming and problem resolution.
  6. Business intelligence concepts and benefits.
  7. Introduction to Data Warehouse, Data mining, Big Data and Analytics.

Learning Experience

ONLINE

All learning experiences are delivered online and attendance at scheduled virtual classes is expected.

ON-CAMPUS

On-campus attendance at scheduled classes is expected.

This is a Learning Unit. Learning Units engage students in regular learning activities to develop their knowledge, skills, and capabilities. The learning activities provide each student with feedback to support their development, and create evidence for each student’s progress towards achieving the learning outcomes of the course.

Unit Completion Requirements

To meet the minimum requirements for this Learning Unit, you will actively engage in specified learning activities and produce a curated portfolio of work that demonstrates your knowledge, skills, and developmental progress toward the course learning outcomes. Further details are available in the unit Canvas site.

GS2 GRADING SCHEMA 2 Used for Undifferentiated Pass/Fail units inc. practical units or work-integrated learning


Disability Standards for Education (Commonwealth 2005)

For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.

Academic Integrity in Learning Units

The University is committed to creating an academic environment in which learning with integrity means engaging honestly, responsibly and ethically with the curriculum. Engaging in academic misconduct undermines this commitment, impedes the development of authentic knowledge and skills, and prevents meaningful learning. Academic integrity is therefore essential to the learning process and to the value of the qualifications awarded by the University.

Academic Integrity in a Learning Unit includes:

  • Following the guidance for Artificial Intelligence in your unit, taking responsibility for the validity of any information you get from AI tools, and always acknowledging your use fully and accurately;
  • Completing your own work, without copying from others or asking other people to do your work for you;
  • Referencing your sources of information accurately;
  • Attending classes and engaging with the learning materials and feedback.

Your teaching staff will provide feedback if they have concerns that you are not acting with integrity in your learning. However, it is your responsibility to ensure that you are completing your work ethically.

Extension

In some circumstances, Students may apply for an extension in accordance with ECU policy and procedure - for more information visit https://askus2.ecu.edu.au/s/article/000001386.

Special Consideration

Students may apply for Special Consideration in respect of a final unit grade, where their achievement was affected by Exceptional Circumstances as set out in ECU policy and procedure - for more information visit https://askus2.ecu.edu.au/s/article/000003318.

MAN6905|6|2