Skip to main content

We are aiming for an incremental return to campus in accordance with guidelines provided by NSW Health and the Australian Government. Until this time, learning activities and assessments will be planned and scheduled for online delivery where possible, and unit-specific details about face-to-face teaching will be provided on Canvas as the opportunities for face-to-face learning become clear.

We are currently working to resolve an issue where some unit outline links are unavailable. If the link to your unit outline does not appear below, please use the link in your Canvas site. If no link is available on your Canvas site, please contact your unit coordinator.

Unit of study_

ISYS2120: Data and Information Management

The ubiquitous use of information technology leaves us facing a tsunami of data produced by users, IT systems and mobile devices. The proper management of data is hence essential for all applications and for effective decision making within organizations. This unit of study will introduce the basic concepts of database designs at the conceptual, logical and physical levels. We will place particular emphasis on introducing integrity constraints and the concept of data normalization which prevents data from being corrupted or duplicated in different parts of the database. This in turn helps in the data remaining consistent during its lifetime. Once a database design is in place, the emphasis shifts towards querying the data in order to extract useful information. The unit will introduce the SQL database query languages, which is industry standard. Other topics covered will include the important concept of transaction management, application development with a backend database, and an overview of data warehousing and OLAP.

Code ISYS2120
Academic unit Computer Science
Credit points 6
Prerequisites:
? 
INFO1113 OR INFO1103 OR INFO1105 OR INFO1905 OR INFO1003 OR INFO1903 OR DECO1012
Corequisites:
? 
None
Prohibitions:
? 
INFO2120 OR INFO2820 OR COMP5138
Assumed knowledge:
? 
Programming skills

At the completion of this unit, you should be able to:

  • LO1. work effectively in a team with members whose skills and interests differ
  • LO2. understand the SQL mechanisms for basic concepts of data security and privacy
  • LO3. design a schema which says how information about a particular domain will be stored in a relational DBMS (given a conceptual data model), also be able to apply normalisation theory to evaluate or improve a relational schema, and be able to capture business rules as integrity constraints in a database schema
  • LO4. understand the concept of a DBMS, differences from other ways to store and share data, DBMS role in organisations, and the types of work done with a DBMS
  • LO5. work with data stored in a relational database management system, and understand table definitions including integrity constraints, extract information through SQL queries, modify information through SQL queries, and use views and permissions for security
  • LO6. understand how application software can use data stored in a DBMS, and understand the basic architectural alternatives for data management applications
  • LO7. understand the basic concepts of transaction management
  • LO8. understand the relational data model
  • LO9. connect general database concepts to both theoretical abstract formulations, and details of specific software platforms.

Unit outlines

Unit outlines will be available 2 weeks before the first day of teaching for 1000-level and 5000-level units, or one week before the first day of teaching for all other units.

There are no unit outlines available online for previous years.