Visit ECU Homepage
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.
Please note that given the circumstances of COVID-19, there may be some modifications to the assessment schedule promoted in Handbook for Semester 1 2020 Units. Students will be notified of all approved modifications by Unit Coordinators via email and Unit Blackboard sites. Where changes have been made, these are designed to ensure that you still meet the unit learning outcomes in the context of our adjusted teaching and learning arrangements.
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.
Students must pass 1 unit from CSI1241 OR CSI4201. For students enrolled in the Data Science (MAAAJJ) Major no pre-requisites are required before undertaking CSG1207. Data Science students will require assistance bypassing the pre-requisites, please contact Student Hub.
Unit was previously coded CSI2341, CSI5135
On completion of this unit students should be able to:
Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.
| Joondalup | Mount Lawley | South West (Bunbury) | |
|---|---|---|---|
| Semester 1 | 13 x 2 hour lecture | Not Offered | Not Offered |
| Semester 1 | 13 x 1 hour workshop | Not Offered | Not Offered |
| Semester 2 | 13 x 2 hour lecture | Not Offered | Not Offered |
| Semester 2 | 13 x 1 hour workshop | Not Offered | Not Offered |
For more information see the Semester Timetable
Students will engage in learning experiences through ECU Blackboard as well as additional ECU learning technologies.
Lectures & practical workshops, research and group work.
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.
| Type | Description | Value |
|---|---|---|
| Assignment | Normalisation & E-R modelling | 20% |
| Project | Database design & implementation | 30% |
| Examination ^ | End of semester examination | 50% |
| Type | Description | Value |
|---|---|---|
| Assignment | Normalisation & E-R modelling | 20% |
| Project | Database design & implementation | 30% |
| Examination ^ | End of semester examination | 50% |
^ Mandatory to Pass
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.
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:
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|4|1
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.
Please note that given the circumstances of COVID-19, there may be some modifications to the assessment schedule promoted in Handbook for this unit. All assessment changes will be published by 27 July 2020. All students are reminded to check handbook at the beginning of semester to ensure they have the correct outline.
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.
Students must pass 1 unit from CSI1241 OR CSI4201. For students enrolled in the Data Science (MAAAJJ) Major no pre-requisites are required before undertaking CSG1207. Data Science students will require assistance bypassing the pre-requisites, please contact Student Hub.
Unit was previously coded CSI2341, CSI5135
On completion of this unit students should be able to:
Students will attend on campus classes as well as engage in learning activities through ECU Blackboard.
| Joondalup | Mount Lawley | South West (Bunbury) | |
|---|---|---|---|
| Semester 1 | 13 x 2 hour lecture | Not Offered | Not Offered |
| Semester 1 | 13 x 1 hour workshop | Not Offered | Not Offered |
| Semester 2 | 13 x 2 hour lecture | Not Offered | Not Offered |
| Semester 2 | 13 x 1 hour workshop | Not Offered | Not Offered |
For more information see the Semester Timetable
Students will engage in learning experiences through ECU Blackboard as well as additional ECU learning technologies.
Lectures & practical workshops, research and group work.
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.
| Type | Description | Value |
|---|---|---|
| Assignment | Normalisation & E-R modelling | 20% |
| Project | Database design & implementation | 30% |
| Examination ^ | End of semester examination | 50% |
| Type | Description | Value |
|---|---|---|
| Assignment | Normalisation & E-R modelling | 20% |
| Project | Database design & implementation | 30% |
| Examination ^ | End of semester examination | 50% |
^ Mandatory to Pass
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.
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:
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|4|2