INFS 7007 Systems Analysis and Database Management Systems

Credit Points 10

Legacy Code 300977

Coordinator Aruna Jamdagni Opens in new window

Description The main purpose of this unit is to provide students with an opportunity to gain knowledge and experience of developing a business information system in a systematic way. This unit examines the general methodology of systems development life cycle, including different phases and various modeling techniques. The unit specialises in the development of a full systems analysis and design documentation by using system development methodologies, including data analysis and modeling methods. It extensively covers database design techniques where students will use a set of business rules obtained from requirements and use case analysis, and database implementation using a commercial database management system. At the same time, student learning, intercommunication and collaborative working skills are enhanced by student participation in tutorial presentations and group assignments.

School Computer, Data & Math Sciences

Student Contribution Band HECS Band 2 10cp

Check your HECS Band contribution amount via the Fees page.

Level Postgraduate Coursework Level 7 subject

Restrictions Students must be enrolled in a postgraduate program.

Learning Outcomes

On successful completion of this subject, students should be able to:
  1. explain the key role of a system analyst and compare the generic roles and responsibilities of users, developers and managers within the context of business information systems
  2. apply various phases of System Development Life Cycle (SDLC) to collaborative projects in a business environment.
  3. analyse user and system requirements for producing abstract models on business problems.
  4. explain essential components of a Relational Database Management System (RDBMS) and the database ANSI/SPARC 3 level architecture.
  5. apply and generalise skills in database modeling, including Entity-Relationship Diagram (ERD), normalization and Global Relation Diagram (GRD).
  6. develop a database using the SDLC methodology and implement this system in a commercial database management system such as Microsoft SQL.
  7. explain the general concepts of database transactions and concurrency control.

Subject Content

Systems analysis design and the Systems Development Life Cycle (SDLC)
Project creation, selection and management
Requirements analysis and use case analysis
Process modeling and Data Flow Diagram (DFD)
Systems architecture, user-interface design and program design
Systems testing, documentation and transition
Database architecture, ANSI/SPARC 3 level architecture
Data modeling, Entity-Relationship modeling and Relational modeling
Anomalies in databases and data normalization.
Entity-Relationship Diagram (ERD) and Global Relation Diagram (GRD)
Introduction to database transaction management, concurrency and locking.
Database implementation and SQL

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
Exam 2 hours 35% Y Individual
Tutorial practicals 10 in-class tutorial practical exercises. 1 for each week, lasting 10 weeks. Each exercise to be completed no later than the next class. 30% Y Group
Final Project presentation: 10 minutes including question time report: maximum 2000 words in no more than 20 pages 35% Y Group

Teaching Periods

2021-2022 Summer

Parramatta - Victoria Rd (Summer A)

Day

Subject Contact Pantea Aria Opens in new window

View timetable Opens in new window

2022 Semester 1

Parramatta - Victoria Rd

Evening

Subject Contact Pantea Aria Opens in new window

View timetable Opens in new window

2022 Semester 2

Parramatta - Victoria Rd

Evening

Subject Contact Pantea Aria Opens in new window

View timetable Opens in new window

2022 Trimester 3

Sydney City

Day

Subject Contact Mahsa Razavi Opens in new window

View timetable Opens in new window