Entry Requirements and Weighting

Prerequisites: N/A
Corequisites: N/A
Credit Points: 15 Credit Points
Level: Year 2, Core
Workload: Timetabled hours/week: 4 (Lecture = 2 hours, Tute/Lab = 2 hours)
  Personal study hours per week: 5

Brief Description

This is a core unit out of a total of 8 units in the Diploma of IT (DIT). This unit addresses the DIT course learning outcomes and complements other courses in a related field by developing students’ knowledge and skills in Database Technologies. For further course information refer to: http://www.mit.edu.au/study-with-us/programs/diploma-information-technology

This unit introduces students to the advantages and functionality of Database Management Systems. The unit presents various models of database management systems and data modelling techniques, and discusses general features and capabilities of databases, using an actual system for a practical application. Students will develop skills at using databases and data retrieval techniques using SQL (Structured Query Language).

This unit will cover the following topics:

  1. Database: Introduction to database management systems, advantages and disadvantages of the database approach. Object oriented, relational, network and hierarchical databases.
  2. Data Modelling: Modelling concepts, entity-relationship model, converting an entity-relationship model to a relational model.
  3. Information Systems: Database systems in the context of information systems. Types of information systems. Organization and management theories.
  4. Relational Model: Primary keys, foreign keys, referential integrity, relational algebra, structured query language (SQL), normalisation.
  5. Distributed Databases, Object-oriented databases, transaction processing / recovery / security, data warehousing, review.
  6. Transaction Processing: Concurrency control, locking and deadlocks, time-stamping, backup and recovery.

Learning Outcomes

At the completion of this unit students should be able to:

  1. Describe issues related to the integrity and security of database (DB) systems.
  2. Make an informed and critical assessment of database management systems (DBMS).
  3. Develop data models and implementing DB systems.
  4. Analyse business decisions related to DB information systems.
  5. Demonstrate skills in building a database application using a commercially available database management system development tool.

Graduate Attributes

MIT is committed to ensure the course is current, practical and relevant so that graduates are ‘work ready’ and equipped for life-long learning. In order to accomplish this, the MIT Graduate Attributes identify the required knowledge, skills and attributes that prepare students for the industry. The level to which Graduate Attributes covered in this unit are as follows:

Ability to communicate Independent and Lifelong Learning Ethics Analytical and Problem Solving  Cultural and Global Awareness Teamwork Specialist knowledge of a field of study

Levels of Attainment:

                                The attribute is covered by theory and practice, and addressed by assessed activities in which students always play an active role, e.g. workshops, lab submissions, assignments, demonstrations, tests, examinations.
  The attribute is covered by theory or practice, and addressed by assessed activities in which students mostly play an active role, e.g. workshops, lab submissions, assignments, interpreting documents, tests, examinations.
  The attribute is discussed in theory or practice; it is addressed by assessed activities in which the students may play an active role, e.g. lectures and discussions, reading, interpretation, workshops, presentations.
  The attribute is presented as a side issue in theory or practice; it is not specifically assessed, but it is addressed by activities such as lectures or tutorials
  The attribute is not considered, there is no theory or practice or activities associated with this attribute.