School of Information and Communication Technology

College of Sciences and Engineering

Unit Outline

KIT712 Data Management Technology


Semester 2, 2021

Sandy Bay Campus, Hobart

Newnham Campus, Launceston


Unit Coordinator

Dr. Saurabh Garg

E-Mail: [email protected]

Phone: 03 6226 6210

Room: 462, Sandy Bay Campus, Hobart


Teaching Staff

Sandy Bay Campus, Hobart:

Dr. Saurabh Garg

E-Mail: [email protected]

Phone: 03 6226 6210

Room: 462


COVID Safety on Campus

To ensure the safety and wellbeing of our University and the broader community, it's important that you allow time to complete the following steps every day you attend campus:

Complete the COVID-Safe Return to Campus MyLO module before you attend

Go through screening each day when attending campus, check your temperature, swipe your access card

Maintain COVID-safe behaviours: keep 1.5 metres away from others, wash your hands thoroughly and often, use disinfectant wipes to clean your work station

Critically, please stay at home if you are unwell, get tested if you have any symptoms and email us at [email protected] if you are getting tested

Together, let's make our campus a safe place to be.


UNIT OVERVIEW

Introduction

This unit is designed to introduce students to the fundamental concepts necessary for the analysis, design, use and implementation of a relational database management system for the management of data in modern organisations. Students will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system. This unit is designed for students to extend their programming abilities in developing relatively large database applications. Topics covered include the principal aspects of database development and applications, advanced queries to populate, retrieve, and update data, database programming with triggers, procedures and functions. This unit also introduces students to the principles and practice of administering enterprise-level database systems. Topics include database architecture; DBMS installation and configuration issues; user management and DBA tools.


Prerequisites

KIT502 or KIT506


Unit Weight

12.5% of one academic year


Learning expectations

The University is committed to high standards of professional conduct in all activities, and holds its commitment and responsibilities to its students as being of paramount importance. Likewise, it holds expectations about the responsibilities students have as they pursue their studies within the special environment the University offers.

The University's Code of Conduct for Teaching and Learning states:

Students are expected to participate actively and positively in the teaching/learning environment. They must attend classes when and as required, strive to maintain steady progress within the subject or unit framework, comply with workload expectations, and submit required work on time.


CoVid-19 (Corona) Virus Information

The delivery of some units will continue online as per the University of Tasmania's guidelines. Students will be updated on any changes to delivery by the University of Tasmania whenever required. Unit specific information as to how the delivery of this unit has been modified can be found in the Teaching Pattern section of this unit outline.


Attendance/performance requirements and teaching and learning strategies

In this unit, your engagement will be monitored in the following way:

1. Submission of assessment tasks in first four weeks

2. Attendance in the tutorials.

If you do not demonstrate evidence of having engaged actively with this unit, your enrolment may be cancelled or you may be withdrawn from the unit.


Communication

Given the large size of the unit, students are recommended to communicate in the following manner:

a) For validity of any information, first point is MyLO where all lectures, assessments and tutorials will be posted. You can ask your unit coordinator during lecture.

b) Students are encouraged to utilise MyLO discussion board for any generic information

c) Your tutor will be your first contact for understanding unit content outside lecture/consultation hours.

d) You may email unit coordinator for your query. Depending on your query, he may reply to you individually or as a group within 72 hours.


Teaching Pattern

Lectures: 3hr in week 1 and 13 & 2hr/wk [week 2-12],

Tutorials: 2hr/wk [Week 2-13]


Unit Content

Introduction to Systems and Databases;

Entity Relationship Model review and extension;

Conceptual, logical, physical Modelling;

SQL Review and advanced SQL;

SQL Query Optimisation;

Triggers, Procedures and Functions;

Database Administration.

Overview of NoSql Databases.

For more information see the section titled 'Content' on the unit website.


Prior Knowledge and/or Skills

Need knowledge of SQL and some programming.


Learning Outcomes

On successful completion of this unit, you will be able to:

1. Evaluate and critically analyse alternative techniques and data models for designing databases;

2. Adapt and apply techniques and processes for designing, implementing and administering an enterprise level relational database;

3. Design sophisticated SQL queries to efficiently retrieve information from relational databases;

4. Understand and appreciate data storage and retrieval issues with current trends and advances in database technologies.


Developing attainment of Skills Framework for the Information Age (SFIA)

As an accredited Australian Computing Society (ACS) course, each unit offered in this ICT course assists students in the attainment of SFIA skills which can help you achieve your specific career goals. As you progress through the course you will develop depth with the skills at increasing levels of responsibility ranging from 1-5.

For more information regarding the SFIA you can visit the following website: https://sfia-online.org/en/about-sfia/browsing-sfia

Upon successful completion of this unit, you will have the capacity to demonstrate attainment of the following SFIAv6 skills:

DTAN (4), DBDS(5), TECH(4), SYSP(3), SCAD(4), DBAD(4), METL(4), DATM(4), IRMG(4),PBMG(3)


Generic graduate attributes

Successful completion of this unit supports your development of course learning outcomes, which describe what a graduate of a course knows, understands and is able to do. Course learning outcomes are available by selecting the appropriate course from this page https://www.utas.edu.au/courses/study/computing-and-it, and choosing Learning Outcomes or they can be obtained from the Course Coordinator. Course learning outcomes are developed with reference to national discipline standards, Australian Qualifications Framework (AQF), any professional accreditation requirements and the University of Tasmania's Graduate Statement.

The University of Tasmania experience unlocks the potential of individuals. Our graduates are equipped and inspired to shape and respond to the opportunities and challenges of the future as accomplished communicators, highly regarded professionals and culturally competent citizens in local, national, and global society. University of Tasmania graduates acquire subject and multidisciplinary knowledge and skills, and develop critical and creative literacies and numeracies and skills of inquiry. They demonstrate the ability to apply this knowledge in changing circumstances. Our graduates recognise and critically evaluate issues of social responsibility, ethical conduct and sustainability, are entrepreneurial and creative, and are mindful of their own wellbeing and that of the community. Through respect for diversity and by working in collaborative ways, our graduates reflect the values of the University of Tasmania.

Knowledge

use a wide range of academic skills (research, analysis, synthesis etc) to problem-solve an ICT-related issue;

understand the limitation of, and have the capacity to evaluate, their current knowledge;

develop a broad knowledge base and respect the contribution of other disciplines or professional areas relating to ICT;

identify, evaluate and implement personal learning strategies;

learn both independently and cooperatively;

learn new skills and apply learning to new and unexpected situations; and

recognise opportunities.

Communication Skills

demonstrate oral, written, numerical and graphic communication;

use the medium and form of communication appropriate for a given situation;

present well-reasoned arguments, using technology as appropriate;

access, organise and present information, particularly through technology-based activity; and

listen to and evaluate the views of others.

Problem-solving Skills

identify critical issues in the discipline or professional area;

conceptualise problems and formulate a range of solutions;

work effectively with others; and

find, acquire, evaluate, manage and use relevant information in a range of media.

Global Perspective

demonstrate an awareness of the local and global context of the ICT discipline or professional area; and

function in a multicultural or global context

Social Responsibility

acknowledge the social and ethical implications of their actions;

appreciate the impact of social change;

be committed to access and equity principles in the ICT discipline or professional area, and society in general; and

demonstrate responsibility to the local community, and society generally.


Alterations to the unit as a result of student feedback

Test for all students is now at the same time.

Lectures will be changed to be more modular.


UNIT ASSESSMENT

Assessment Pattern

Internal (60%), Exam (40%)


Assessment Summary

  Component
  Weight
  Due Date
  Database design
  10%
  9th August 1 PM
  Database Implementation & SQL basics
  15%
  Week 5, Thursday 4pm-6pm
  Query Design and Optimisation
  15%
  Week 8, Thursday 4pm-6pm
  Database Constraints Implementation (PL/SQL)
  15%
  Week 11, Thursday 4pm-6pm
  Database Administration & Modern Database Test
  5%
  Week 13, Thursday 4pm-6pm
  Exam
  40%
  The final exam is conducted by the Student Centre in the formal examination period. See the
  Examinations and Results page: http://www.utas.edu.au/exams/ on the University's website,
  or access your personal exams timetable by logging into the eStudent Centre - Personal
  Exams Timetable for specific date, time and location closer to the examination period.


Assessment Items

Item 1

Title: Database design

Type: In-Semester - individual assignment

Task Length: not applicable

Weighting: 10%

Links to Learning Outcomes: 1, 2

Due: 9th August 1 PM

How To submit: MyLO

Description: Students need to design a database based on a given scenario. This assignment consist of 2 parts. First part is business rules design which needs to be submitted in week 3 (date will be announced in Assignment Description) and second part is to design a database for a given scenario.

Item 2

Title: Database Implementation & SQL basics

Type: In-Semester - test

Task Length: not applicable

Weighting: 15%

Links to Learning Outcomes: 1,2,3,4

Due: Week 5, Thursday 4pm-6pm

How To submit: MyLO

Description: This practical test involves questions in relation to database design and implementation and on basic SQL.

There will be also a quiz associated with the test.

Item 3

Title: Query Design and Optimisation

Type: In-Semester - test

Task Length: not applicable

Weighting: 15%

Links to Learning Outcomes: 3,4

Due: Week 8, Thursday 4pm-6pm

How To submit: MyLO

Description: This practical test involves questions for assessing students' skill in designing SQL statements and optimising them. Students will be supplied with a set of tables and asked to construct and optimise the performance of a number of required queries against these tables.

There will be also a quiz associated with the test.

Item 4

Title: Database Constraints Implementation (PL/SQL)

Type: In-Semester - test

Task Length: not applicable

Weighting: 15%

Links to Learning Outcomes: 2

Due: Week 11, Thursday 4pm-6pm

How To submit: MyLO

Description: Students may be asked to develop a set of SQL queries, triggers, procedures and functions to meet supplied user requirements.

There will be also a quiz associated with the test.

Item 5

Title: Database Administration & Modern Database Test

Type: In-Semester - test

Task Length: not applicable

Weighting: 5%

Links to Learning Outcomes: 2

Due: Week 13, Thursday 4pm-6pm

How To submit: MyLO

Description: Students will have a test based on database administration and modern databases.

There will be also a quiz associated with the test.

Item 6

Title: Exam

Type: Formal Examination

Task Length: 2 hours

Weighting: 40%

Links to Learning Outcomes: All

Due: The final exam is conducted by the Student Centre in the formal examination period. See the Examinations and Results page: http://www.utas.edu.au/exams/ on the University's website, or access your personal exams timetable by logging into the eStudent Centre - Personal Exams Timetable for specific date, time and location closer to the examination period.

Description: 2hr online exam.

See the 'Assessment' section in unit website for more detailed information about assessment items.


How your Final Grade will be determined

Your overall mark in this unit will be determined by combining your results from each assessment task. These marks are combined to reflect the percentage weighting of each task. You need to achieve an overall score of at least 50% to successfully complete this unit. To be eligible to pass you will need to attain (gain at least 40% in) each Intended Learning Outcome and gain a minimum of 45% in each of the examination and aggregated internal assessment tasks. It is expected that you will seek help (from your lecturer in the first instance), well before the due date, if you are unclear about the requirements for an assessment task.


UNIT RESOURCES

Unit Web Site

This unit is Web Dependent: content & communication. This means that you will need to use the Web for this unit. The unit website contains unit information and resources.

MyLO is the online learning environment at the University of Tasmania. This is the system that will host the online learning materials and activities for this unit.

It is important that you are able to access and use MyLO as part of your study in this unit. To find out more about the features and functions of MyLO, and to practice using them, visit the Getting Started in MyLO unit.

For access to information about MyLO and a range of step-by-step guides in pdf, word and video format, visit the MyLO Student Support page on the University website.

The unit website is accessed from http://www.utas.edu.au/coursesonline/. You will need to use your university email account username and password to log on to the MyLO system. Once authenticated by the system your personalised MyLO Learning Online area will be displayed. It contains links to the websites that you have permission to access - including the website for this unit.


Prescribed Text

Following books one may want to refer during this unit:

Database Systems: Design, Implementation and Management, by Cornell and Morris, Cengage Learning publisher.

Oracle 11g: SQL, by Joan Casteel, published 2010 by Course Technology, Cengage Learning

Oracle 11g: PL/SQL, by Joan Casteel, published 2010 by Course Technology, Cengage Learning


Software

The software that you will need to access the unit website and to study this unit, including general purpose software such as word processors, is provided on the computers in the computing labs. If you intend to use software on other computers please check that the versions are compatible.

oracle database management system