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

Discipline Information Systems, Not Elsewhere Classified.

Student Contribution Band HECS Band 2 10cp

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