INFS 2002 Database Design and Development (Advanced)

Credit Points 10

Legacy Code 300941

Coordinator Zhuhan Jiang Opens in new window

Description This unit covers the principles, methodologies and technologies for the database design and development, exploring in particular the data modelling methods and the use of the language SQL for the database applications. The unit also examines a number of important database concepts such as database administration, concurrency, backup and recovery, and security. Students in this advanced unit are furthermore required to investigate new technological and theory advances in the database industry and apply them to the solution of concrete database problems.

School Computer, Data & Math Sciences

Student Contribution Band HECS Band 2 10cp

Check your HECS Band contribution amount via the Fees page.

Level Undergraduate Level 2 subject

Incompatible Subjects LGYA 4371 - Database Management System for Business Information Systems INFS 2001 - Database Design and Development

Restrictions Students must be enrolled in 3685 Bachelor of Computing (Information Systems) Advanced, 3684 Bachelor of Information and Communication Technology (Advanced), 3688 Bachelor of Information Systems Advanced or 3745 Bachelor of Information Systems Advanced/Bachelor of Business.

Assumed Knowledge

Basic programming skills, including variable declaration, variable assignment, selection statement and loop structure.

Learning Outcomes

On successful completion of this subject, students should be able to:
  1. Describe components of a database system, advantages and disadvantages of a database system, roles peoples play and the historical development of a database system in the context of a Relational Database Management System (RDBMS).
  2. Apply basic skills in database modeling, including ER diagrams and normalization in RDBMS.
  3. Explain the basic concepts of relational algebra and apply them in queries.
  4. Describe the general concepts of transaction management.
  5. Identify concepts in database administration.
  6. Describe concepts in database security and backup.
  7. Define and manipulate data using structured query language (SQL)
  8. Design and develop a database for a business application using a commercial database management system
  9. Investigate and apply advanced database techniques such as higher normal forms, stored procedures, triggers, indexes and limited data denormalization

Subject Content

Introduction to database concepts and ANSI Spark 3 level architecture.
Concepts in data modeling.
Integration of data and data independence.
Translating a case study into relational concepts and integrity constraints.
Introduction to relational algebra.
Data Modelling: Conceptual, logical and physical database design.
Data definition and manipulation using SQL.
EER concepts with generalisation and specialisation.
Anomalies in databases and database normalisation.
Introduction to database security and administration.
Introduction to transaction management, concurrency and locking.
Higher normal forms, stored procedures, triggers, indexes, and limited data denormalization.

Assessment

The following table summarises the standard assessment tasks for this subject. Please note this is a guide only. Assessment tasks are regularly updated, where there is a difference your Learning Guide takes precedence.

Item Length Percent Threshold Individual/Group Task
Assignment 1 (including advanced components) maximum 2000 words in no more than 20 pages 23 N Both (Individual & Group)
Assignment 2 (including advanced components) maximum 2000 words (excluding SQL source code) in no more than 20 pages 27 N Both (Individual & Group)
Final Examination 2 hours 50 N Individual

Teaching Periods

2022 Semester 2

Campbelltown

Day

Subject Contact Zhuhan Jiang Opens in new window

Attendance Requirements 80% attendance rate is imposed in all core subjects’ due to the nature of class activities that are aligned with subject assessments.

View timetable Opens in new window

Penrith (Kingswood)

Day

Subject Contact Zhuhan Jiang Opens in new window

Attendance Requirements 80% attendance rate is imposed in all core subjects’ due to the nature of class activities that are aligned with subject assessments.

View timetable Opens in new window

Parramatta - Victoria Rd

Day

Subject Contact Zhuhan Jiang Opens in new window

Attendance Requirements 80% attendance rate is imposed in all core subjects’ due to the nature of class activities that are aligned with subject assessments.

View timetable Opens in new window