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
  2021	Semester 1	MS   Yuting   ZHAO	(Ph: )	ON-CAMPUS
  2021	Semester 2	DR   Masoud   MOHAMMADIAN	(Ph: +61 2 62012917 )	ON-CAMPUS

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

Prerequisites

None