Database Design (5915.7)

Please note these are the 2024 details for this unit
Home
/
Find your course
/
Database Design
Available teaching periods Delivery mode Location
View teaching periods On-campus
Online real-time
 Bruce, Canberra
UC College, Bruce, ACT
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 the development and design of database systems. The emphasis is placed on relational database management systems, their development and implementation in a modern organisational environment. The use of modern query languages for relational databases is discussed and experienced. Conceptual, logical and physical database design issues are also covered. Other topics include client server database computing and database administration issues.

This unit may be cotaught with 6672 Database Design G.

Learning outcomes

On successful completion of this unit, students will be able to:
1. List, describe, and illustrate the steps in a database system development life cycle;
2. Illustrate the inputs and outputs in database system development, with an emphasis on data modelling;
3. Acquire and apply fundamental skills to analyse data;
4. Develop an appropriate set of data models for relational database implementation; and
5. Utilise Structured Query Language (SQL) to query and manipulate a database server environment.


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 2026 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
2025 Bruce, Canberra Semester 1 03 February 2025 On-campus Mr Sisira Adikari
2025 Bruce, Canberra Semester 1 03 February 2025 Online real-time Mr Sisira Adikari
2025 UC College, Bruce, ACT UC College Trimester 2 26 May 2025 On-campus Mr Tariq Alqura'N Alzyadat
2025 Bruce, Canberra Semester 2 28 July 2025 Online real-time Dr Masoud Mohammadian
2025 Bruce, Canberra Semester 2 28 July 2025 On-campus Dr Masoud Mohammadian
2026 Bruce, Canberra Semester 1 16 February 2026 Online real-time Mr Sisira Adikari
2026 Bruce, Canberra Semester 1 16 February 2026 On-campus Mr Sisira Adikari
2026 UC College, Bruce, ACT UC College Trimester 2 29 June 2026 On-campus Mr Tariq Alqura'N Alzyadat
2026 Bruce, Canberra Semester 2 10 August 2026 On-campus Dr Masoud Mohammadian
2026 Bruce, Canberra Semester 2 10 August 2026 Online real-time Dr Masoud Mohammadian
Not available

Required texts

Required Textbook: Connolly, T and Begg, C 2015, Database Systems: A practical approach to design, implementation and management,
6th edition, Boston, Pearson Education

The textbook can be borrowed from the UC library (https://www.canberra.edu.au/library) or can be purchased at the University of Canberra bookshop  School Locker (https://theschoollocker.com.au/universities/university-of-canberra). 

Submission of assessment items

Extensions & Late submissions

Further information will be made available on the unit's Canvas website.

Special assessment requirements

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 assessment or assessment procedure, the onus for clarifying the issue rests with the student who should contact the lecturer about the matter. 

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 assessment. 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

 

Supplementary assessment

There is no supplementary assessment for this subject.

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

An estimate of the required student workload for this subject is given below:

Lectures                                                                         12 weeks (2 hours per week)   24 hours

Tutorials/Laboratories                                                     11 weeks (2 hours per week)  22 hours

Preparation (Lectures/tutorials/labs)                                12 weeks (2 hours per week)  24 hours

Assessment 1 (Online quiz exercise)                                                                    13 hours

Assessment 2                                                                                                       20 hours

Assessment 3                                                                                                       20 hours

Assessment 4                                                                                                       27 hours

 

Total                                                                                                                      150 hours

Participation requirements

You are strongly advised to listen to all lecture and review supporting materials. Students should also be aware that the subject 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. 

Required IT skills

There are no specific IT skills required for this unit.

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

NA

Additional information

Announcements made in the Canvas website of this subject are deemed to be made to all students enrolled in the unit.