Database Design (5915.5)
|Available teaching periods||Delivery mode||Location|
|View teaching periods|
|0.125||3||Faculty Of Business, Government & Law|
|Discipline||Study level||HECS Bands|
|School Of Information Systems & Accounting||Level 1 - Undergraduate Introductory Unit|| Band 2 2021 (Commenced After 1 Jan 2021)
Band 3 2021 (Commenced Before 1 Jan 2021)
Learning outcomesOn 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 attributes1. UC graduates are professional - work collaboratively as part of a team, negotiate, and resolve conflict
2. UC graduates are global citizens - behave ethically and sustainably in their professional and personal lives
3. UC graduates are lifelong learners - evaluate and adopt new technology
This unit primarily addresses the UC graduate attributes on
- Communication: The ability to present knowledge, ideas and opinions effectively and communicate within and across professional and cultural boundaries
- Analysis and inquiry: The ability to gather information, and to analyse and evaluate information and situations in a systematic, creative and insightful way
- Problem solving :The ability to apply problem-solving processes in novel situations; to identify and analyse problems then formulate and implement solutions
- Working independently and with others: The ability to plan their own work, be self-directed, and use interpersonal skills and attitudes to work collaboratively
|Year||Location||Teaching period||Teaching start date||Delivery mode||Unit convener|
Textbook: Connolly, T & Begg, C 2015, Database Systems: A practical approach to design, implementation and management, 6th edn. Addison-Wesley, Pearson Education
Submission of assessment items
Special assessment requirements
To obtain a particular grade in this unit it is necessary that there are no outstanding resubmissions on Friday of week 12.
All assessment items will receive a numeric mark. The final grade will be determined as a weighted average of the individual assessment items.
To be awarded a particular grade in Database Design, students must meet both the assignment requirements and the examination requirements as detailed below.
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, mid-term test, and final examination.
b. You must achieve at least 50% of the available marks of the Final Examination.
If you fail the final exam your mark for this unit will be your exam mark and you will fail the unit.
Once above conditions have been satisfied, grades will be awarded as per the following table
|Grade Letter||Grade Weighted||Marks|
|High Distinction||HD||85% - 100%|
|Distinction||DI||75% - 84%|
|Credit||CR||65% - 74%|
|Pass||P||50% - 64%|
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 criteria for answers to theoretical and technical questions is both correctness and appropriate style.
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.
Your participation in lectures, workshops 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 pass 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, workshops, tutorials and labs. 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 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, a word processor and other software applications such as Visio and MS Access to undertake various assessment tasks in the unit.
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
- UC College Trimester 3, 2017, On-Campus, UC - University of Canberra College, Bruce (166532)
- UC College Trimester 2, 2017, On-Campus, UC - University of Canberra College, Bruce (165608)
- Semester 2, 2017, On-Campus, UC - Canberra, Bruce (167662)
- UC College Trimester 1, 2017, On-Campus, UC - University of Canberra College, Bruce (165563)
- Semester 1, 2017, On-Campus, UC - Global Business College of Australia, Melbourne (171418)
- Semester 1, 2017, On-Campus, UC - Canberra, Bruce (167158)
- UC College Trimester 3, 2016, On-Campus, UC - University of Canberra College, Bruce (150006)
- Semester 2, 2016, On-Campus, UC - Canberra, Bruce (151816)
- Semester 2, 2016, On-Campus, UC Melbourne - Chadstone Campus (151814)
- Semester 2, 2016, On-Campus, UC - TAFE NSW South Western Sydney, Liverpool (151815)
- Semester 1, 2016, On-Campus, UC - TAFE NSW South Western Sydney, Liverpool (154995)
- Semester 1, 2016, On-Campus, UC - Canberra, Bruce (154993)
- UC College Trimester 1, 2016, On-Campus, UC - University of Canberra College, Bruce (153271)
- Semester 2, 2014, On-Campus, UC Melbourne - Chadstone Campus (138510)
- Semester 2, 2015, On-Campus, UC - TAFE NSW South Western Sydney, Liverpool (140590)
- Semester 2, 2015, On-Campus, UC - Canberra, Bruce (140592)
- UC College Trimester 3, 2015, On-Campus, UC - University of Canberra College, Bruce (142547)
- UC College Trimester 2, 2016, On-Campus, UC - University of Canberra College, Bruce (152709)
- UC College Trimester 1, 2015, On-Campus, UC - University of Canberra College, Bruce (142506)
- Semester 1, 2015, On-Campus, UC - Canberra, Bruce (146191)