School: Science

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

    Systems Analysis and Database Design
  • Unit Code

    CSI6207
  • Year

    2019
  • Enrolment Period

    1
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Naeem Khalid JANJUA

Description

This unit explores the process of systems analysis and database design to understand existing systems with a view to improving processes, procedures and data storage and utilisation. The concepts of system analysis, database design, normalisation and entity-relationship modelling are considered in order to solve specific digital systems design problems. The unit also explores the use of Structured Query Language (SQL) to create, populate and administer relational databases, and to perform complex queries upon the data inside them.

Learning Outcomes

On completion of this unit students should be able to:

  1. Apply appropriate data analysis and modelling concepts to meet specific business needs.
  2. Design relational databases using normalisation and entity-relationship modelling.
  3. Use SQL to implement, populate and administer a database design in an appropriate relational database management system (RDBMS).
  4. Work collaboratively to develop and demonstrate a range of analysis, modelling and database tools.

Unit Content

  1. Investigating system requirements.
  2. Identifying user stories and use cases.
  3. Use Case Modelling.
  4. Introduction to RDBMS technology and SQL.
  5. Data manipulation and querying in SQL.
  6. Creating and administering databases in SQL.
  7. Database design using entity-relationship modelling and normalisation.

Learning Experience

ON-CAMPUS

Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.

JoondalupMount LawleySouth West (Bunbury)
Semester 113 x 1 hour labNot OfferedNot Offered
Semester 113 x 2 hour lectureNot OfferedNot Offered
Semester 213 x 1 hour labNot OfferedNot Offered
Semester 213 x 2 hour lectureNot OfferedNot Offered

For more information see the Semester Timetable

ONLINE

Students will engage in learning experiences through ECU Blackboard as well as additional ECU learning technologies.

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
TestOnline Quizzes20%
ReportAnalysis and Modelling Report35%
ProjectDatabase Design and Implementation35%
PresentationVideo Executive Summary10%
ONLINE
TypeDescriptionValue
TestOnline Quizzes20%
ReportAnalysis and Modelling Report35%
ProjectDatabase Design and Implementation35%
PresentationVideo Executive Summary10%

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.

CSI6207|1|1

School: Science

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

    Systems Analysis and Database Design
  • Unit Code

    CSI6207
  • Year

    2019
  • Enrolment Period

    2
  • Version

    1
  • Credit Points

    20
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Coordinator

    Dr Naeem Khalid JANJUA

Description

This unit explores the process of systems analysis and database design to understand existing systems with a view to improving processes, procedures and data storage and utilisation. The concepts of system analysis, database design, normalisation and entity-relationship modelling are considered in order to solve specific digital systems design problems. The unit also explores the use of Structured Query Language (SQL) to create, populate and administer relational databases, and to perform complex queries upon the data inside them.

Learning Outcomes

On completion of this unit students should be able to:

  1. Apply appropriate data analysis and modelling concepts to meet specific business needs.
  2. Design relational databases using normalisation and entity-relationship modelling.
  3. Use SQL to implement, populate and administer a database design in an appropriate relational database management system (RDBMS).
  4. Work collaboratively to develop and demonstrate a range of analysis, modelling and database tools.

Unit Content

  1. Investigating system requirements.
  2. Identifying user stories and use cases.
  3. Use Case Modelling.
  4. Introduction to RDBMS technology and SQL.
  5. Data manipulation and querying in SQL.
  6. Creating and administering databases in SQL.
  7. Database design using entity-relationship modelling and normalisation.

Learning Experience

ON-CAMPUS

Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.

JoondalupMount LawleySouth West (Bunbury)
Semester 113 x 1 hour labNot OfferedNot Offered
Semester 113 x 2 hour lectureNot OfferedNot Offered
Semester 213 x 1 hour labNot OfferedNot Offered
Semester 213 x 2 hour lectureNot OfferedNot Offered

For more information see the Semester Timetable

ONLINE

Students will engage in learning experiences through ECU Blackboard as well as additional ECU learning technologies.

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
TestOnline Quizzes20%
ReportAnalysis and Modelling Report35%
ProjectDatabase Design and Implementation35%
PresentationVideo Executive Summary10%
ONLINE
TypeDescriptionValue
TestOnline Quizzes20%
ReportAnalysis and Modelling Report35%
ProjectDatabase Design and Implementation35%
PresentationVideo Executive Summary10%

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.

CSI6207|1|2