INFO6001

Database Management 1

10 Units

Modern enterprises rely on the efficient storage and management of data. An organisation's data provides information that is vital for its day-to-day existence. Corporate data structures can also be formed to serve as a knowledge repository for the organisation. These provide a basis for strategic decisions and enhance competitive advantage. This course provides the foundational knowledge of database systems and their implementation with elementary programming skills. The course covers both the theoretical content and the practical implementation of database requirements for organisations. It presents the basics of information storage and management, from the conceptual modelling of an organisation's data requirements using the relational model, through to the implementation of these requirements with tools such as SQL and techniques such as normalisation. It also addresses the practical issues of security and concurrency in data transactions. It introduces elementary programming techniques.

Faculty Faculty of Science and Information Technology
School School of Design, Communication and Information Technology
Availability Trimester 1 - 2014 (Callaghan Campus)
Trimester 1 - 2014 (WebLearn GradSchool)
Trimester 1 - 2015 (Callaghan Campus)
Trimester 1 - 2015 (WebLearn GradSchool)
Objectives

Upon successful completion of this course the student should:

  1. be familiar with fundamental relational database concepts including entity relationship diagrams, data normalisation and relational operators;
  2. have a working knowledge of SQL;
  3. understand system implementation issues such as data views, data independence, indexing, security and transaction management
  4. be able to apply elementary programming skills.
Content

Topics will generally include:

  • 3 Level Architecture
  • SQL Basics: DDL, DML
  • Conceptual Modelling: E/R
  • Normalisation (to BCNF)
  • Database Design and Case Studies
  • Theory of Relational Database Systems
  • Data Integrity
  • Introductory computer skills in a contemporary development environment
  • Overview of the issues in Transaction Processing within the business environment
  • Contemporary issues in Database Systems.
Replacing Course(s) NA
Transition NA
Industrial Experience 0
Assumed Knowledge Desktop computer competency as prescribed by the International Computer Driving Licence. (See Australian Computer Society at http://www.icdl.com.au/ )
Modes of Delivery External Mode
Internal Mode
Teaching Methods Email Discussion Group
Lecture
Self Directed Learning
Computer Lab
Assessment Items
  • Essays / Written Assignments -
  • Examination: Formal -
  • Quiz - Class -
Contact Hours
  • Computer Lab: for 2 hour(s) per Week for Full Term
  • Lecture: for 2 hour(s) per Week for Full Term
Compulsory Components None listed
Course Materials None listed
Timetable 2015 Course Timetables for INFO6001

Sound like the course for you?

  Apply Now