Database Design (5915.6)

Please note these are the 2024 details for this unit
Home
/
Find a course
/
Database Design
Available teaching periods Delivery mode Location
View teaching periods On-Campus
Online
 UC - Canberra, Bruce
UC - University of Canberra College, Bruce
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 introduces a practical approach to understanding and modelling the world in terms of data entities, attributes and relationships. The emphasis is placed on analysis and design for relational database management systems in an organisational environment using database design patterns for typical domains. Expertise in the structured query language (SQL) is developed. The means for database quality evaluation, including normal forms, conformance with standards, testing techniques security and privacy are reviewed along with database management systems services including backup and recovery, cloud storage, etc.
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 effectively
1. 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


Skills development

This unit primarily addresses the UC graduate attributes on

  1. Communication: The ability to present knowledge, ideas and opinions effectively and communicate within and across professional and cultural boundaries
  2. Analysis and inquiry: The ability to gather information, and to analyse and evaluate information and situations in a systematic, creative and insightful way
  3. Problem solving: The ability to apply problem-solving processes in novel situations; to identify and analyse problems then formulate and implement solutions
  4. Working independently and with others: The ability to plan their own work, be self-directed, and use interpersonal skills and attitudes to work collaboratively


Prerequisites

None.

Corequisites

None.

Incompatible units

6672 Database Design G.

Equivalent units

None.

Assumed knowledge

None.
Availability for enrolment in 2024 is subject to change and may not be confirmed until closer to the teaching start date.
Year Location Teaching period Teaching start date Delivery mode Unit convener
2023 UC - Canberra, Bruce Semester 1 06 February 2023 On-Campus Dr Hamed Sarbazhosseini
2023 UC - Canberra, Bruce Semester 1 06 February 2023 Online Dr Hamed Sarbazhosseini
2023 UC - University of Canberra College, Bruce UC College Trimester 2 05 June 2023 On-Campus Mr Tariq Alqura'N Alzyadat
2023 UC - Canberra, Bruce Semester 2 31 July 2023 On-Campus Dr Masoud Mohammadian
2024 UC - Canberra, Bruce Semester 1 05 February 2024 Online Dr Hamed Sarbazhosseini
2024 UC - Canberra, Bruce Semester 1 05 February 2024 On-Campus Dr Hamed Sarbazhosseini
2024 UC - University of Canberra College, Bruce UC College Trimester 2 03 June 2024 On-Campus Mr Tariq Alqura'N Alzyadat
2024 UC - Canberra, Bruce Semester 2 29 July 2024 On-Campus Dr Masoud Mohammadian
The information provided should be used as a guide only. Timetables may not be finalised until week 2 of the teaching period and are subject to change. Search for the unit timetable.

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 obtain a particular grade in this unit it is necessary that there are no outstanding resubmissions at the end 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, online quizzes, Lab & Tutorial Participation, and final assessment.

and

b.        You must achieve at least 50% of the available marks for the Final assessment.

If you fail the final exam your final grade for this unit will be NX, regardless of the final numeric mark, and you will fail the unit.

Once these 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%
Fail NX <50%

Other Requirements

  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.
  4. The tutor/s will provide feedback to the students on their assignments.

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

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.

Next step

Apply now Enquire