Faculty of Business and Law

School: Business

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

    2015
  • Enrolment Period

    1
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus

Description

This unit explores the use of relational databases and business intelligence in organisations. It is 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 a database. They will then proceed to investigate the application of these databases as business intelligence tools, learning about data warehouses, decision support systems, data mining and the emerging concept of "big data". For business managers, effective database management for supporting organizational intelligence promises 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. Choose business intelligence tools to provide organisations with relevant information.
  2. Compare the concepts of databases, data warehouses and business intelligence.
  3. Construct a database and corresponding data warehouse in a way that provides business value.
  4. Critique the management issues in maintaining multi-user database and data warehouse systems.
  5. Develop SQL programs and interrogate databases.
  6. Formulate a data model using a standard methodology.

Unit Content

  1. Business intelligence concepts and benefits.
  2. Data analysis, abstraction and modelling for business applications.
  3. Data mining and clustering.
  4. Data normalisation.
  5. Data sources and analysis for "big data".
  6. Data visualisation for insight and decision support.
  7. Data warehouse features, design and processes.
  8. Database creation, SQL programming and problem resolution.
  9. Fundamental relational database concepts.
  10. Introduction to database tools.

Additional Learning Experience Information

The unit is offered in both off-campus and on-campus delivery mode. The on-campus delivery is presented via a weekly three hour lecture-laboratory seminar. The off-campus version is supported via Blackboard. Regular on line access is required.

Assessment

GS1 GRADING SCHEMA 1 Used for standard coursework units

Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant Board of Examiners.

ON CAMPUS
TypeDescriptionValue
AssignmentDatabase and BI Assignment50%
ExaminationExamination50%
ONLINE
TypeDescriptionValue
AssignmentDatabase and BI Assignment50%
ExaminationExamination50%

Text References

  • ^ Connolly, T., Begg, C., & Holowczak, R. (2008). Business database systems. Harlow: Addison Wesley.

^ Mandatory reference


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 Misconduct

Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:

  • plagiarism;
  • unauthorised collaboration;
  • cheating in examinations;
  • theft of other students' work;

Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.

The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.

MAN6905|1|1

Faculty of Business and Law

School: Business

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

    2015
  • Enrolment Period

    2
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus

Description

This unit explores the use of relational databases and business intelligence in organisations. It is 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 a database. They will then proceed to investigate the application of these databases as business intelligence tools, learning about data warehouses, decision support systems, data mining and the emerging concept of "big data". For business managers, effective database management for supporting organizational intelligence promises 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. Choose business intelligence tools to provide organisations with relevant information.
  2. Compare the concepts of databases, data warehouses and business intelligence.
  3. Construct a database and corresponding data warehouse in a way that provides business value.
  4. Critique the management issues in maintaining multi-user database and data warehouse systems.
  5. Develop SQL programs and interrogate databases.
  6. Formulate a data model using a standard methodology.

Unit Content

  1. Business intelligence concepts and benefits.
  2. Data analysis, abstraction and modelling for business applications.
  3. Data mining and clustering.
  4. Data normalisation.
  5. Data sources and analysis for "big data".
  6. Data visualisation for insight and decision support.
  7. Data warehouse features, design and processes.
  8. Database creation, SQL programming and problem resolution.
  9. Fundamental relational database concepts.
  10. Introduction to database tools.

Additional Learning Experience Information

The unit is offered in both off-campus and on-campus delivery mode. The on-campus delivery is presented via a weekly three hour lecture-laboratory seminar. The off-campus version is supported via Blackboard. Regular on line access is required. The Australian Computer Society (ASC) have adopted the Skills Framework for the Information Ages (SFIA), an internationally recognised tool to describe capabilities and identify skills and knowledge. This unit meets the SFIA learning outcomes in the following: Assignment (learning outcomes 1-6): REQM, DTAN, BPRE, BUAN, DBDS. Exam (learning outcomes 1-2, 4-6): REQM DTAN, BPRE, BUAN, DBDS.

Assessment

GS1 GRADING SCHEMA 1 Used for standard coursework units

Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant Board of Examiners.

ON CAMPUS
TypeDescriptionValue
AssignmentDatabase and BI Assignment50%
ExaminationExamination50%
ONLINE
TypeDescriptionValue
AssignmentDatabase and BI Assignment50%
ExaminationExamination50%

Text References

  • ^ Connolly, T., Begg, C., & Holowczak, R. (2008). Business database systems. Harlow: Addison Wesley.

^ Mandatory reference


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 Misconduct

Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:

  • plagiarism;
  • unauthorised collaboration;
  • cheating in examinations;
  • theft of other students' work;

Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.

The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.

MAN6905|1|2