Database Design (5915.6)
Available teaching periods | Delivery mode | Location |
---|---|---|
View teaching periods | ||
EFTSL | Credit points | Faculty |
0.125 | 3 | Faculty Of Science And Technology |
Discipline | Study level | HECS Bands |
Academic Program Area - Technology | Level 1 - Undergraduate Introductory Unit | Band 2 2021 (Commenced After 1 Jan 2021) Band 3 2021 (Commenced Before 1 Jan 2021) |
This unit may be cotaught with 6672 Database Design G.
Learning outcomes
On successful completion of this unit, students will be able to:1. Analyse a situation and develop an appropriate set of data models for relational database implementation;
2. Demonstrate the use of the SQL language for database specification and data manipulation;
3. Evaluate the soundness of a database specification; and
4. Discuss the issues around data and its management.
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
6672 Database Design G.Equivalent units
None.Assumed knowledge
None.Year | Location | Teaching period | Teaching start date | Delivery mode | Unit convener |
---|
Required texts
Textbook: Connolly, T & Begg, C 2015, Database Systems: A practical approach to design, implementation and management, 6th edn. Addison-Wesley, Pearson Education
Suggested Reading
Elmasri R & Navathe S B, 2003, 4th edition, Addison Wesley, An introduction of Database Systems
Mark L. Gillenson, Paulraj Ponniah, Alex Kriegel, Boris M Trukhnou, Allen G Taylor, Gavin Powell, 2008, 1st edition, Wiley, An Introduction to database Management, Wiley Publishing Inc
Gavin Powell, 2006, 1st Edition, Beginning Database Design, Wiley Publishing Inc
Kifer M, Bernstein A & Lewis P M, 2004, 2nd Edition, Addison Wesley, Database Systems: An application-oriented approach
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
Students must apply academic integrity in their learning and research activities at UC. This includes submitting authentic and original work for assessments and properly acknowledging any sources used.
Academic integrity involves the ethical, honest and responsible use, creation and sharing of information. It is critical to the quality of higher education. Our academic integrity values are honesty, trust, fairness, respect, responsibility and courage.
UC students have to complete the Academic Integrity Module annually to learn about academic integrity and to understand the consequences of academic integrity breaches (or academic misconduct).
UC uses various strategies and systems, including detection software, to identify potential breaches of academic integrity. Suspected breaches may be investigated, and action can be taken when misconduct is found to have occurred.
Information is provided in the Academic Integrity Policy, Academic Integrity Procedure, and University of Canberra (Student Conduct) Rules 2023. For further advice, visit Study Skills.
Learner engagement
Activity |
Details |
Hours |
Lectures |
12 weeks (2 hours per week) |
24 |
Tutorials/Laboratories |
11 weeks (2 hours per week) |
22 |
Preparation (Lectures/tutorials/labs) |
12 weeks (2 hours per week) |
24 |
Assignment 1 |
20 |
|
Online exercises |
13 |
|
Assignment 2 |
22 |
|
Self-Study/Practice |
25 |
|
Total hours: |
150 |
Participation requirements
Your participation in lectures and tutorial activities will enhance your understanding of the unit content and therefore the quality of your assessment responses. Lack of participation may result in your inability to satisfactorily complete assessment items. Experience has shown that students who do not attend classes, have difficulty passing the unit.
Students should also be aware that the subject will be examined on material covered in all classes, including lectures, tutorials and labs. It is the individual student's responsibility to ensure that they are sufficiently familiar with this material. Attendance in classes is one of the best ways of ensuring this familiarity. While some of the lecture notes and course materials are available online, 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 and participation.
Required IT skills
Students need to possess the ability to use on-line searching tools from the Internet and a word processor to undertake various assessment tasks in the unit.
In-unit costs
No additional costs will be incurred by students undertaking this unit apart from the normal costs of being a university student.
Work placement, internships or practicums
NA
Additional information
Announcements made in the class and Canvas website of this subject are deemed to be made to all students enrolled in the unit.
- UC College Trimester 2, 2023, On-campus, UC - University of Canberra College, Bruce (211063)
- Semester 2, 2023, On-campus, UC - Canberra, Bruce (213684)
- Semester 1, 2023, On-campus, UC - Canberra, Bruce (212813)
- Semester 1, 2023, Online, UC - Canberra, Bruce (212815)
- UC College Trimester 3, 2022, On-campus, UC - University of Canberra College, Bruce (208913)
- Semester 2, 2022, Online, UC - Canberra, Bruce (210911)
- Semester 2, 2022, On-campus, UC - Canberra, Bruce (207224)
- UC College Trimester 1, 2022, On-campus, UC - University of Canberra College, Bruce (207144)
- Semester 1, 2022, On-campus, UC - Canberra, Bruce (205766)
- Semester 1, 2022, Online, UC - Canberra, Bruce (210723)
- Semester 2, 2021, On-campus, UC - Canberra, Bruce (202073)
- Semester 2, 2021, Online, UC - Canberra, Bruce (209317)
- UC College Trimester 2, 2021, On-campus, UC - University of Canberra College, Bruce (201345)
- Semester 1, 2021, On-campus, UC - Canberra, Bruce (200371)
- UC College Trimester 3, 2020, On-campus, UC - University of Canberra College, Bruce (197001)
- Semester 2, 2020, On-campus, UC - Canberra, Bruce (195592)
- UC College Trimester 2, 2020, On-campus, UC - University of Canberra College, Bruce (195042)
- Semester 1, 2020, On-campus, UC - Canberra, Bruce (194000)
- UC College Trimester 3, 2019, On-campus, UC - University of Canberra College, Bruce (189814)
- UC College Trimester 2, 2019, On-campus, UC - University of Canberra College, Bruce (185688)
- Semester 2, 2019, On-campus, UC - Canberra, Bruce (185324)
- UC College Trimester 1, 2019, On-campus, UC - University of Canberra College, Bruce (185671)
- Semester 1, 2019, On-campus, UC - Canberra, Bruce (185044)
- UC College Trimester 3, 2018, On-campus, UC - University of Canberra College, Bruce (183215)
- Semester 2, 2018, On-campus, UC - Canberra, Bruce (183229)
- UC College Trimester 2, 2018, On-campus, UC - University of Canberra College, Bruce (183214)
- UC College Trimester 1, 2018, On-campus, UC - University of Canberra College, Bruce (183213)
- Semester 1, 2018, On-campus, UC - Canberra, Bruce (183227)
- Semester 1, 2018, On-campus, UC - Global Business College of Australia, Melbourne (183228)