Database Design G (6672.5)
Available teaching periods | Delivery mode | Location |
---|---|---|
View teaching periods | On-Campus Online |
Bruce, Canberra |
EFTSL | Credit points | Faculty |
0.125 | 3 | Faculty Of Science And Technology |
Discipline | Study level | HECS Bands |
Academic Program Area - Technology | Graduate Level | Band 2 2021 (Commenced After 1 Jan 2021) Band 3 2021 (Commenced Before 1 Jan 2021) |
This unit may be cotaught with 5915 Database Design.
Learning outcomes
On successful completion of this unit, students will be able to:1. Describe, illustrate the steps in a database system development life cycle;
2. Explain, classify and categorize the inputs and outputs in that process, with an emphasis on data modelling;
3. Analyse data and apply data analysis for data modelling;
4. Design and develop an appropriate set of data models for relational database implementation; and
5. Demonstrate the use of the SQL language in a database server environment.
Graduate attributes
1. UC graduates are professional - communicate effectively1. UC graduates are professional - display initiative and drive, and use their organisation skills to plan and manage their workload
1. UC graduates are professional - employ up-to-date and relevant knowledge and skills
1. UC graduates are professional - use creativity, critical thinking, analysis and research skills to solve theoretical and real-world problems
1. UC graduates are professional - work collaboratively as part of a team, negotiate, and resolve conflict
Prerequisites
None.Corequisites
None.Incompatible units
5915 Database DesignEquivalent units
None.Assumed knowledge
None.Year | Location | Teaching period | Teaching start date | Delivery mode | Unit convener |
---|---|---|---|---|---|
2023 | Bruce, Canberra | Semester 1 | 06 February 2023 | On-Campus | Dr Hamed Sarbazhosseini |
2023 | Bruce, Canberra | Semester 1 | 06 February 2023 | Online | Dr Hamed Sarbazhosseini |
2023 | Bruce, Canberra | Semester 2 | 31 July 2023 | On-Campus | Dr Masoud Mohammadian |
2024 | Bruce, Canberra | Semester 1 | 05 February 2024 | On-Campus | Dr Masoud Mohammadian |
2024 | Bruce, Canberra | Semester 2 | 29 July 2024 | On-Campus | Dr Masoud Mohammadian |
Required texts
Connolly, T and Begg, C 2015, Database Systems: A practical approach to design, implementation and management,
6th edition, Boston, Pearson Education
The text book can be purchased at the University of Canberra bookshop.
Submission of assessment items
Extensions & Late submissions
Further information will be made available on the unit's Canvas website.
Special assessment requirements
To pass this unit, you will need to satisfy the following conditions:
a. You must achieve at least 50% as a combined total of the available marks of the two assignments and online quiz exercise; and
b. You must achieve at least 50% of the available marks in the Take Home Assessment.
Once these conditions have been satisfied, grades will be awarded as per the following
---------------------------------------------------------------
Grade Letter Grade Weighted Marks
--------------------------------------------------------------
High Distinction HD 85% - 100%
Distinction DI 75% - 84%
Credit CR 65% - 74%
Pass P 50% - 64%
Fail NX 0% - 49%
If there is any doubt with regard to the requirements of any particular assignments or assessment procedure, the onus for clarifying the issue rests with the student who should contact the lecturer about the matter. Tutors will also be happy to assist in this regard.
1. Students should keep a copy of all assessment items that are submitted.
2. The lecturer reserves the right to question students orally on their submitted work
3. The assessment criterion for answers to theoretical and technical questions is both correctness and appropriate style.
4. The tutors will provide feedback to the students on their assignments. Students are encouraged to seek individual feedback from the tutor/lecturer.
Referencing requirements:
All work quoted from other written sources should be appropriately referenced using the "author-date" (Harvard) style. This style is described in detail (including electronic sources) in the Citation Guide available at:
http://canberra.libguides.com/referencing
Academic integrity
Students have a responsibility to uphold University standards on ethical scholarship. Good scholarship involves building on the work of others and use of others' work must be acknowledged with proper attribution made. Cheating, plagiarism, and falsification of data are dishonest practices that contravene academic values. Refer to the University's Student Charter for more information.
To enhance understanding of academic integrity, all students are expected to complete the Academic Integrity Module (AIM) at least once during their course of study. You can access this module within UCLearn (Canvas) through the 'Academic Integrity and Avoiding Plagiarism' link in the Study Help site.
Use of Text-Matching Software
The University of Canberra uses text-matching software to help students and staff reduce plagiarism and improve understanding of academic integrity. The software matches submitted text in student assignments against material from various sources: the internet, published books and journals, and previously submitted student texts.
Learner engagement
An estimate of the required student workload for this subject is given below:
Lectures 12 weeks (2 hours per week) 24 hours
Tutorials/Laboratories 12 weeks (1 hours per week) 24 hours
Preparation (Lectures/tutorials/labs) 12 weeks (3 hours per week) 24 hours
Assignment 1 20 hours
Online exercises 13 hours
Assignment 2 20 hours
Self Study/Practice 25 hours
Total 150
Participation requirements
Attendance at classes is not compulsory but you are strongly advised to attend all classes. Students should also be aware that the unit will be examined on material covered in classes, including lectures, tutorials and laboratories and it is the individual student's responsibility to ensure that they are sufficiently familiar with this material. Attendance at classes is one of the best ways of ensuring this familiarity. While the lecture notes and course materials are available on the subject website, these are intended to be broad outlines of the lectures. Do not make the mistake of assuming that the materials perfectly substitute for class attendance.
Required IT skills
There are no specific IT skills required for this unit.
This unit involves online tutorial/laboratory session in real time using the Virtual Room in your UCLearn teaching site as well as face-to-face tutorial/laboratory seessions and lecture. The Virtual Room allows you to communicate in real time with your lecturer and other students. To participate verbally, rather than just typing, you will need a microphone. For best audio quality we recommend a microphone and speaker headset. For more information and to test your computer, go to the Virtual Room in your UCLearn site and 'Join Course Room'. This will trigger a tutorial to help familiarise you with the functionality of the virtual room.
In-unit costs
There are no additional costs associated with this unit apart from materials you choose to use in the preparation of assessment items.
Work placement, internships or practicums
None.
Additional information
Announcements made in the class and website of this subject are deemed to be made to all students enrolled in the unit.
- Semester 2, 2023, On-Campus, UC - Canberra, Bruce (213995)
- Semester 1, 2023, Online, UC - Canberra, Bruce (212883)
- Semester 1, 2023, On-Campus, UC - Canberra, Bruce (212882)
- Semester 2, 2022, Online, UC - Canberra, Bruce (210921)
- Semester 2, 2022, On-Campus, UC - Canberra, Bruce (207353)
- Semester 1, 2022, Online, UC - Canberra, Bruce (210719)
- Semester 1, 2022, On-Campus, UC - Canberra, Bruce (205840)
- Semester 2, 2021, On-Campus, UC - Canberra, Bruce (202202)
- Semester 2, 2021, Online, UC - Canberra, Bruce (209318)
- Semester 1, 2021, On-Campus, UC - Canberra, Bruce (200440)
- Semester 2, 2020, On-Campus, UC - Canberra, Bruce (195650)
- Semester 1, 2020, On-Campus, UC - Canberra, Bruce (194348)
- Semester 2, 2019, On-Campus, UC - Canberra, Bruce (185402)
- Semester 1, 2019, On-Campus, UC - Canberra, Bruce (185123)
- Semester 2, 2018, On-Campus, UC - Canberra, Bruce (181403)
- Semester 1, 2018, On-Campus, UC - Canberra, Bruce (181402)