INFS 2001 Database Design and Development

Credit Points 10

Legacy Code 300104

Coordinator Zhuhan Jiang Opens in new window

Description The main purpose of this unit is to provide students with an opportunity to gain a basic knowledge of database design and development including data modelling methods, techniques for database design using a set of business rules that are derived from a case study and finally implementation of the database using a commercial relational database management system. Through group work and tutorial practicals, students examine a number of important database concepts such as database administration, concurrency, backup and recovery and security whilst developing their professional communication and team work skills.

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

Equivalent Subjects INFS 2003 - Database Design and Development (WSTC)

Incompatible Subjects LGYA 4371 - Database Management System for Business Information Systems

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

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 generalization and specialization.
- Anomalies in databases and data normalization.
- introduction to database security and administration.
- introduction to transaction management, concurrency and locking.

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 maximum 2000 words in no more than 20 pages 15 N Group
Assignment 2 maximum 2000 words (excluding SQL source code) in no more than 20 pages 15 N Group
Tutorials and Practicals Refer to additional information below for details 20 N Individual
Final Exam 2 hours 50 Y Individual

Teaching Periods

2021-2022 Summer

Parramatta - Victoria Rd (Summer A)

Day

Subject Contact Maria Mikhail Opens in new window

View timetable Opens in new window

2022 Trimester 1

Sydney City

Day

Subject Contact Antoinette Cevenini Opens in new window

View timetable Opens in new window

2022 Trimester 2

Sydney City

Day

Subject Contact Antoinette Cevenini Opens in new window

View timetable Opens in new window

2022 Semester 2

Campbelltown

Day

Subject Contact Zhuhan Jiang Opens in new window

View timetable Opens in new window

Penrith (Kingswood)

Day

Subject Contact Zhuhan Jiang Opens in new window

View timetable Opens in new window

Parramatta - Victoria Rd

Day

Subject Contact Maria Mikhail Opens in new window

View timetable Opens in new window

2022 Trimester 3

Sydney City

Day

Subject Contact Antoinette Cevenini Opens in new window

View timetable Opens in new window