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 and Database Design
  • Unit Code

    CSG1207
  • Year

    2017
  • Enrolment Period

    1
  • Version

    2
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Co-ordinator

    Dr Gregory BAATARD

Description

This unit introduces students to the concepts of relational databases, including database design via normalisation and entity-relationship modelling in order to solve problems. It 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.

Prerequisite Rule

Students must pass 1 units from CSI1241, CSI4201

Equivalent Rule

Unit was previously coded CSI2341, CSI5135

Learning Outcomes

On completion of this unit students should be able to:

  1. Construct complex queries to retrieve data in a relational database using SQL.
  2. Design relational databases using normalisation and entity-relationship modelling.
  3. Distinguish between a logical and a physical database design.
  4. Understand the fundamental concepts of relational databases and what distinguishes them from other data storage methods.
  5. Use SQL to implement, populate and administer a database design in a relational database management system (RDBMS).

Unit Content

  1. Creating and administering databases in SQL.
  2. Data manipulation and querying in SQL.
  3. Database design using entity-relationship modelling.
  4. Database design using normalisation.
  5. Introduction to RDBMS technology and SQL.
  6. Introduction to database models, concepts, terminology and history.

Teaching and Learning Processes

Lectures & practical workshops, research and group work.

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
AssignmentNormalisation & E-R modelling20%
ProjectDatabase design & implementation30%
Examination ^End of semester examination50%
ONLINE
TypeDescriptionValue
AssignmentNormalisation & E-R modelling20%
ProjectDatabase design & implementation30%
Examination ^End of semester examination50%

^ Mandatory to Pass


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 Student Equity, Diversity and Disability Service 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.

CSG1207|2|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 and Database Design
  • Unit Code

    CSG1207
  • Year

    2017
  • Enrolment Period

    2
  • Version

    3
  • Credit Points

    15
  • Full Year Unit

    N
  • Mode of Delivery

    On Campus
    Online
  • Unit Co-ordinator

    Dr Gregory BAATARD

Description

This unit introduces students to the concepts of relational databases, including database design via normalisation and entity-relationship modelling in order to solve problems. It 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.

Prerequisite Rule

Students must pass 1 units from CSI1241, CSI4201.
For students enrolled in the Data Science (MAAAJJ) Major no pre-requisites are required before undertaking CSG1207

Equivalent Rule

Unit was previously coded CSI2341, CSI5135

Learning Outcomes

On completion of this unit students should be able to:

  1. Construct complex queries to retrieve data in a relational database using SQL.
  2. Design relational databases using normalisation and entity-relationship modelling.
  3. Distinguish between a logical and a physical database design.
  4. Understand the fundamental concepts of relational databases and what distinguishes them from other data storage methods.
  5. Use SQL to implement, populate and administer a database design in a relational database management system (RDBMS).

Unit Content

  1. Creating and administering databases in SQL.
  2. Data manipulation and querying in SQL.
  3. Database design using entity-relationship modelling.
  4. Database design using normalisation.
  5. Introduction to RDBMS technology and SQL.
  6. Introduction to database models, concepts, terminology and history.

Teaching and Learning Processes

Lectures & practical workshops, research and group work.

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
AssignmentNormalisation & E-R modelling20%
ProjectDatabase design & implementation30%
Examination ^End of semester examination50%
ONLINE
TypeDescriptionValue
AssignmentNormalisation & E-R modelling20%
ProjectDatabase design & implementation30%
Examination ^End of semester examination50%

^ Mandatory to Pass


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 Student Equity, Diversity and Disability Service 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.

CSG1207|3|2