Database Design G (6672.5)

Availability

• UC - Canberra, Bruce

  Year	Teaching Period	Convener		Mode of Delivery
  2020	Semester 1	MS   Yuting   ZHAO	(Ph: )	ON-CAMPUS
  2020	Semester 2	DR   Masoud   MOHAMMADIAN	(Ph: +61 2 62012917 )	ON-CAMPUS

Possible changes to your unit's learning activities and assessment items

As a result of the Australian Government's directives requiring physical distancing and restrictions on movement because of the COVID-19 pandemic, you may find that learning activities and/or assessment items in some units you are studying have changed. These changes will not be updated in the published Unit Outline but will be communicated to you via your unit’s UCLearn(Canvas) teaching site. The new learning activities and/or assessment items will continue to meet the unit's learning outcomes, as described in the Unit Outline.

New learning activities and/or assessment items are available on your unit's UCLearn(Canvas) teaching site. Please contact your Unit Convener with any questions.

Unit Outlines

To view your Unit Outline, click View to log in to MyUC and access this information, or visit your unit's online teaching site.

• Semester 1, 2020, ON-CAMPUS, BRUCE (194348) - View
• Semester 2, 2019, ON-CAMPUS, BRUCE (185402) - View
• Semester 1, 2019, ON-CAMPUS, BRUCE (185123) - View
• Semester 2, 2018, ON-CAMPUS, BRUCE (181403) - View
• Semester 1, 2018, ON-CAMPUS, BRUCE (181402) - View
• Semester 2, 2017, ON-CAMPUS, BRUCE (167457) - View
• Semester 1, 2017, ON-CAMPUS, BRUCE (167080) - View
• Semester 2, 2016, ON-CAMPUS, BRUCE (151239) - View
• Semester 1, 2016, ON-CAMPUS, BRUCE (154804) - View
• Semester 2, 2015, ON-CAMPUS, BRUCE (139493) - View
• Semester 1, 2015, ON-CAMPUS, BRUCE (145604) - View

If a link to your Unit Outline is not displayed, please check back later. Unit Outlines are generally published by Week One of the relevant teaching period.

Syllabus

This unit introduces a practical approach to the development and design of database systems. The emphasis is placed on relational database management systems, their design 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.

Learning Outcomes

Upon 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 that process, with an emphasis on data modelling;

3. Acquire data analysis skills;

4. Develop an appropriate set of data models for relational database implementation and evaluate these data models;

5. Demonstrate an understanding of theoretical concepts; and

6. Demonstrate the use of the SQL language in a database server environment.

Assessment Items

Contact Hours

Up to 52 hours per semester.

Prerequisites

None.

Corequisites

None.

Assumed Knowledge

None.

Incompatible Units

None.

Equivalent Units

None.