INFS3200 - Sem 1 2009 - St Lucia - Internal

Authenticated View
Printed: 28 April 2009, 03:22PM
This printed course profile is valid at the date and time specified above. The course profile may be subject to change during the semester – the online version is the authoritative version.

1. General Course Information

1.1 Course Details

Course Code: INFS3200 Course Title: Advanced Database Systems
Coordinating Unit: School of Information Technology and Electrical Engineering
Semester: Semester 1, 2009    Mode: Internal
Level: Undergraduate
Location: St Lucia
Number of Units: 2    Contact Hours Per Week: 3L1T
Pre-Requisites: INFS2200
Incompatible: INFS7907 or CS315 or CS319 or CS347 or CS370 or CS371 or CS815
Course Description: Distributed database design, query and transaction processing, data integration, data warehousing, data cleansing, management of spatial data, and data from large scale distributed devices.
Assumed Background: Information Systems Concepts Relational DB design: data aspect - ER and process aspect - DFDs Relational Database Management Systems architecture and main functions: Query processing, Transactions, Concurrency, Recovery, Security, Views, Views update-ability, SQL

1.2 Course Introduction

Most contemporary information systems are implemented as a collection of interoperating applications running on several computers. The applications are distributed among computers within an organisation for engineering reasons and among organisations necessarily. This course builds on previous knowledge of centralised information systems, seeing what happens to the design principles when the system is distributed. Some of the engineering reasons for distribition include specialised kinds of applications: data warehousing, data mining, intensively distributed data; or special kinds of data: spatial data, xml data. The course looks at the design issues involving these.

1.3 Course Staff

Course Coordinator: Assoc Prof Xue Li
Phone: 3365 2379     Email: x.li@uq.edu.au
Campus: St Lucia Building: General Purpose South (Map)   Room: 650
Consultation: By Appointment

Lecturer: Dr. Ke Deng
Phone: 3365 4739     Email: dengke@itee.uq.edu.au
Campus: St Lucia Building: General Purpose South (Map)   Room: 639
Consultation: Every Monday 2:00pm-3:00pm or by appointment


1.4 Timetable

Timetables are available on mySI-net.

Additional Timetable Information
Tutorials begin in week 3

2. Aims, Objectives & Graduate Attributes

2.1 Course Aims

To provide an understanding of the issues involved in designing and implementing a large scale modern information system. To equip the students with sufficient conceptual and practical knowledge, to be able to recognize the challenges, analyze the appropriateness of the technology and understand the design and implementation complexities.

2.2 Learning Objectives

After successfully completing this course you should be able to:

1  Have consolidated understanding of main issues in centralised databases.
2  Understand how these principles must be adapted in a distributed database environment
3  Understand the effect of multiple organisations on distributed information systems
4  Understand key principles of data warehousing
5  Understand key principles of data quality and cleansing.
6  Understand key principles of spatial databases
7  Understand key issues in XML databases in a historical context
8  Understand database aspects of RFID and sensor networks

2.3. Graduate Attributes

Successfully completing this course will contribute to the recognition of your attainment of the following UQ (Undergrad Pass) graduate attributes:

GRADUATE ATTRIBUTELEARNING OBJECTIVES
A. IN-DEPTH KNOWLEDGE OF THE FIELD OF STUDY
A1. A comprehensive and well-founded knowledge in the field of study.1, 2, 3, 4, 5, 6, 7, 8
A4. An understanding of how other disciplines relate to the field of study. 
A5. An international perspective on the field of study. 
B. EFFECTIVE COMMUNICATION
B1. The ability to collect, analyse and organise information and ideas and to convey those ideas clearly and fluently, in both written and spoken forms.2, 3
B2. The ability to interact effectively with others in order to work towards a common outcome. 
B3. The ability to select and use the appropriate level, style and means of communication. 
B4. The ability to engage effectively and appropriately with information and communication technologies. 
C. INDEPENDENCE AND CREATIVITY
C1. The ability to work and learn independently.1, 2, 3
C3. The ability to generate ideas and adapt innovatively to changing environments.3, 5
C4. The ability to identify problems, create solutions, innovate and improve current practices.2, 3, 5
D. CRITICAL JUDGEMENT
D1. The ability to define and analyse problems.1, 2, 3, 4, 5, 6, 7, 8
D2. The ability to apply critical reasoning to issues through independent thought and informed judgement.2, 3, 5, 6, 7, 8
D3. The ability to evaluate opinions, make decisions and to reflect critically on the justifications for decisions.2, 3, 4, 5, 6, 7, 8
E. ETHICAL AND SOCIAL UNDERSTANDING
E1. An understanding of social and civic responsibility. 
E2. An appreciation of the philosophical and social contexts of a discipline.2, 3, 5
E4. A knowledge and respect of ethics and ethical standards in relation to a major area of study. 
E5. A knowledge of other cultures and times and an appreciation of cultural diversity. 

Successfully completing this course will contribute to the recognition of your attainment of the following Engineers Australia graduate attributes:

GRADUATE ATTRIBUTELEARNING OBJECTIVES
1. Ability to apply knowledge of basic science and engineering fundamentals1, 2, 3, 4, 5, 6, 7, 8
2. Ability to communicate effectively, not only with engineers, but also with the community at large 
3. In-depth technical competence in at least one engineering discipline1, 2, 3, 4, 5, 6, 7, 8
4. Ability to undertake problem identification, formulation and solution2, 3, 4, 5, 6, 7, 8
5. Ability to utilise a systems approach to design and operational performance2, 3, 4, 5, 6, 7, 8
6. Ability to function effectively as an individual and in multi-disciplinary and multi-cultural teams, with the capacity to be a team leader or manager as well as an effective team member 
7. Understanding of the social, cultural, global and environmental responsibilities of the professional engineer, and for the need for sustainable development 
8. Understanding of the principles of sustainable design and development2
9. Understanding of and commitment to professional and ethical responsibilities 
10. Expectation and capacity to undertake life-long learning 

3. Learning Resources

3.1 Required Resources

Elmasri & Navathe, Fundamentals of Database Systems, 5th edition, Benjamin/Cummings Publishing Company, Inc, 2004 (4th Edition acceptable)  
 
Course notes URL
 

3.2 Recommended Resources

R.Ramakrishnan, J.Gehrke, Database Management Systems, Second Edition, McGraw-Hill, 2000.  
 
Ozsu, M. T., & Valduriez, P., Principles of Distributed Database Systems. Prentice Hall, 1999.  
 
Other readings on course web site URL
 

3.3 University Learning Resources

Access to required and recommended resources, plus past central exam papers, is available at the UQ Library website (http://library.uq.edu.au/search/r?SEARCH=INFS3200).

The University offers a range of resources and services to support student learning. Details are available on the myServices website (https://student.my.uq.edu.au/).

3.4 School of Information Technology and Electrical Engineering Learning Resources

Students enrolled at St Lucia who wish to retain a hard copy of this profile can use the free print quota provided each semester to students enrolled in courses in the School of Information Technology & Electrical Engineering. For information on how to use this print quota, see the School Policy on Student Photocopying and Printing (St Lucia) (http://www.itee.uq.edu.au/about_ITEE/policies/copy-print.html).

ITEE course websites can be found at http://www.itee.uq.edu.au/~COURSECODE. Many ITEE courses also have Usenet newsgroups, named uq.itee.COURSECODE. Instructions for accessing newsgroups are available at http://studenthelp.itee.uq.edu.au/faq/1stYearFAQ.html#accessnews.

3.5 Other Learning Resources & Information

A number of research and industry articles will be provided as additional readings for specific topics. These will be made available on the course web site

4. Teaching & Learning Activities

4.1 Learning Activities

Date
Activity
Learning Objectives
2 Mar 09
Introduction (Lecture):
1
9 Mar 09
Fundamentals of DBMS (Lecture):
2
16 Mar 09 - 17 Mar 09
Distributed DB design (Lecture):
2
23 Mar 09 - 24 Mar 09
Distributed Query Processing (Lecture):
2
30 Mar 09 - 31 Mar 09
Distributed Transactions (Lecture):
2
6 Apr 09 - 7 Apr 09
Database Systems Integration (Lecture):
3
27 Apr 09 - 28 Apr 09
Data Warehousing (Lecture):
4
5 May 09
Data Models (Lecture):
7
11 May 09 - 12 May 09
Data Cleansing (Lecture):
5
18 May 09 - 19 May 09
Spatial Data Management (Lecture):
6
25 May 09 - 26 May 09
RFID and Sensor Networks (Lecture):
8
1 Jun 09 - 2 Jun 09
Review (Lecture):
2, 3, 4, 5, 6, 7, 8

4.2 Other Teaching and Learning Activities Information

Students are not required to attend all teaching sessions, but are strongly encouraged to do so. Lectures and tutorials have been specifically designed to aid student learning of the course material. Missing a session may result in disadvantage. It is up to students to find out what happened in any class session missed.

5. Assessment

5.1 Assessment Summary

This is a summary of the assessment in the course. For detailed information on each assessment, see 5.5 Assessment Detail below.

Assessment Task
Due Date
Weighting
Learning Objectives
Tutorial Exercise
Tutorial Exercise
2 Mar 09 - 27 Jun 09
Submit before each tutorial
10%
1, 2, 3, 4, 5, 6, 7, 8
Group Assignment
Group Assignment
1 Apr 09 - 29 May 09
20%
1, 2, 3
Exam - during semester (School)
In class exam
20 Apr 09 12:00 - 20 Apr 09 14:00
20%
1, 2, 3
Exam - during Exam Period (Central)
Final examination
Examination Period
50%
1, 2, 3, 4, 5, 6, 7, 8

5.2 Course Grading


Grade 1, Fail: Fails to demonstrate most or all of the basic requirements of the course: Total of at most 19 marks

Grade 2, Fail: Demonstrates clear deficiencies in understanding and applying fundamental concepts; communicates information or ideas in ways that are frequently incomplete or confusing and give little attention to the conventions of the discipline: Total of at least 20 marks

Grade 3, Fail: Demonstrates superficial or partial or faulty understanding of the fundamental concepts of the field of study and limited ability to apply these concepts; presents undeveloped or inappropriate or unsupported arguments; communicates information or ideas with lack of clarity and inconsistent adherence to the conventions of the discipline: Total of at least 45 marks

Grade 4, Pass: Demonstrates adequate understanding and application of the fundamental concepts of the field of study; develops routine arguments or decisions and provides acceptable justification; communicates information and ideas adequately in terms of the conventions of the discipline: Total of at least 50 marks

Grade 5, Credit: Demonstrates substantial understanding of fundamental concepts of the field of study and ability to apply these concepts in a variety of contexts; develops or adapts convincing arguments and provides coherent justification; communicates information and ideas clearly and fluently in terms of the conventions of the discipline: Total of at least 65 marks

Grade 6, Distinction: As for 5, with frequent evidence of originality in defining and analysing issues or problems and in creating solutions; uses a level, style and means of communication appropriate to the discipline and the audience: Total of at least 75 marks

Grade 7, High Distinction: As for 6, with consistent evidence of substantial originality and insight in identifying, generating and communicating competing arguments, perspectives or problem solving approaches; critically evaluates problems, their solutions and implications: Total of at least 85 marks

Other Requirements & Comments : A student is required to gain at least 30 of 60 marks in the final examination to be awarded a grade of 4 for the course.

5.3 Late Submission

No extensions will be granted except in exceptional personal circumstances (documented medical reason or family emergency). Personal hardware or computer failures are not grounds for extension.

5.5 Assessment Detail


Tutorial Exercise
Type: Tutorial Exercise
Learning Objectives Assessed: 1, 2, 3, 4, 5, 6, 7, 8
Due Date:
         2 Mar 09 - 27 Jun 09     Submit before each tutorial
Weight: 10%
Task Description: The pre-class exerice for each tutorial is required and one mark for each exercise.
Criteria & Marking: Marking is against the tutorial solution

Group Assignment
Type: Group Assignment
Learning Objectives Assessed: 1, 2, 3
Due Date:
         1 Apr 09 - 29 May 09
Weight: 20%
Task Description:
Students will be required to design and analyse a given specification for an application of distributed databases. This assignment is to be done in groups of up to three. All students in a group will receive the same mark. Note that a student may do the assignment individually, but that no allowance will be made in the marking for doing so.

Criteria & Marking: The assignment will assess understanding of the main principles of distributed databases and interoperating information systems in a practical situation

In class exam
Type: Exam - during semester (School)
Learning Objectives Assessed: 1, 2, 3
Due Date:
         20 Apr 09 12:00 - 20 Apr 09 14:00
Weight: 20%
Task Description: In class exam will assess knowledge gained in the modules covered upto the date of the exam.
Criteria & Marking:

You will be assessed on understanding of main issues in centralized DBMS and how these principles must be adapted in a distributed database environment.



Final examination
Type: Exam - during Exam Period (Central)
Learning Objectives Assessed: 1, 2, 3, 4, 5, 6, 7, 8
Due Date:
         Examination Period
Weight: 50%
Perusal: 10 minutes
Duration: 120 minutes
Format: Multiple-choice, Short answer, Problem solving
Task Description: Examination covers all course topics
Criteria & Marking: You will be assessed on understanding of concepts taught in all modules of this course. Criteria for assessment will be based on learning objectives

6. Policies & Guidelines

 
This section contains the details of and links to the most relevant policies and course guidelines. For further details on University Policies please visit myAdvisor and the University Handbook of Policies and Procedures.

6.1 Assessment Related Policies and Guidelines

University Policies & Guidelines

An overview of the University’s assessment-related policies can be found on myAdvisor (http://www.uq.edu.au/myadvisor/index.html?page=2910).

Academic Integrity
It is the University's task to encourage ethical scholarship and to inform students and staff about the institutional standards of academic behaviour expected of them in learning, teaching and research. Students have a responsibility to maintain the highest standards of academic integrity in their work. Students must not cheat in examinations or other forms of assessment and must ensure they do not plagiarise.

Plagiarism
The University has adopted the following definition of plagiarism:

Plagiarism is the act of misrepresenting as one's own original work the ideas, interpretations, words or creative works of another. These include published and unpublished documents, designs, music, sounds, images, photographs, computer codes and ideas gained through working in a group. These ideas, interpretations, words or works may be found in print and/or electronic media.

Students are encouraged to read the UQ Academic Integrity and Plagiarism policy (http://www.uq.edu.au/hupp/index.html?page=25128) which makes a comprehensive statement about the University's approach to plagiarism, including the approved use of plagiarism detection software, the consequences of plagiarism and the principles associated with preventing plagiarism.

Feedback on Assessment
Feedback is essential to effective learning and students can expect to receive appropriate and timely feedback on all assessment. For a detailed explanation of the feedback you are entitled to, you should consult the policy on Student Access to Feedback on Assessment. (http://www.uq.edu.au/hupp/index.html?page=25109)

As a student you have a responsibility to incorporate feedback into your learning; make use of the assessment criteria that you are given; be aware of the rules, policies and other documents related to assessment; and provide teachers with feedback on their assessment practices.

There are certain steps you can take if you feel your result does not reflect your performance. Please refer to the myAdvisor web site. (http://www.uq.edu.au/myadvisor/index.html?page=2953)

School of Information Technology and Electrical Engineering Assessment Guidelines

Misconduct

Further to the statement on academic integrity and plagiarism above, students are required to read and understand the ITEE policy on Student Misconduct (http://www.itee.uq.edu.au/about_ITEE/policies/student-misconduct.html).

Late Arrival or Non-attendance at Examinations

The policy and procedure for late arrival or non-attendance at centrally controlled and school-based examinations is set out in the University's Assessment policy (HUPP 3.30.1), section 4.8 at http://www.uq.edu.au/hupp/index.html?page=25109.

In the case that a student requests a special exam for a School-controlled exam, the request will be considered and, if allowed, the timing shall be determined by the course coordinator, in consultation with the School's Chief Examiner where necessary, and in accordance with HUPP 3.30.1. Unless otherwise indicated in the Course Profile, applications must be made in writing to the Head of School no later than 5 days after the exam. Late applications will not be accepted.
 
Examination Feedback
 
In addition to the advice above, students wishing to view examination answer scripts and/or question papers should consult with the School office (Room 217, General Purpose South Building [78], St Lucia) regarding arrangements. The ITEE policy on exam script viewing is available at http://study.itee.uq.edu.au/current_students/exam_script_viewing.html.

Supplementary Assessment

If you fail this course you may be eligible for supplementary assessment - see the general award rules and/or your program rules for details. You should note that even though you may be eligible for supplementary assessment under these rules, in some circumstances there may be no practical assessment that can be offered to allow you to meet the minimum passing requirements. These circumstances may include failure based on:
  • group or team based assessment;
  • attendance or class participation requirements;
  • laboratory-based assessment, where laboratories can't practically be made available after classes have finished;
  • project or thesis-based assessment, where a significant period of time would be required to undertake supplementary assessment;
  • progressive assessment, where subsequent assessment items build on earlier assessment items; or
  • multiple assessment items, where it is impractical to offer multiple supplementary assessment items.
If the course coordinator determines that there is no practical supplementary assessment that can be offered to allow you to improve your grade, then you will not be offered supplementary assessment and your grade will remain unchanged.

Calculators in Examinations

Some examinations in the School of Information Technology and Electrical Engineering restrict the type of calculator that can be used. If this course profile does not specify any calculator restrictions, you should check with the course coordinator as to whether any restrictions apply. In some examinations, you may only be permitted to use an EPSA/EAIT approved and lablled non-programmable calculator. It is your responsibility to ensure you have a suitable approved and labelled calculator if required.

6.2 Other Policies and Guidelines

University Policies and Guidelines

Placement Courses
Students on a placement course – also known as a work placement, internship, industry study, industry experience, clinical practice, clinical placement, practical work, practicum, fieldwork, teaching practice – should refer to the University policy, Placement Courses (http://www.uq.edu.au/hupp/index.html?page=25120) for detailed information.
 
Working with Children
Students whose studies include a professional/work placement, internship, clinical practice, teaching practice or other similar activity which involves them in regular contact with children should refer to the University policy, Working with Children Check - "blue card" (http://www.uq.edu.au/hupp/index.html?page=25004) to find out how to apply for a ‘blue card’.
 
Students with a Disability
Any student with a disability who may require alternative academic arrangements, including assessment, in the course/program is encouraged to seek advice at the commencement of the semester from a Disability Adviser at Student Support Services. Refer to the University policy, Students with a Disability (Disability Action Plan) (http://www.uq.edu.au/hupp/index.html?page=25122) and to the policy on Special Arrangements for Examinations for Students with a Disability (http://www.uq.edu.au/hupp/index.html?page=25111

Where an adjustment is made to an accredited program, it is the responsibility of the relevant Faculty to liaise with professional and registration bodies regarding the acceptability of the change/s.  

Occupational Health and Safety
Undergraduate Students (http://www.uq.edu.au/hupp/index.html?page=25055) and Postgraduate Students (http://www.uq.edu.au/hupp/index.html?page=25057) should be familiar with the University policies on occupational health and safety in the laboratory.

Other School of Information Technology and Electrical Engineering Guidelines

Ethical Clearance
If your course involves assignment or project work involving human subjects or human-related materials, you must investigate the need for ethical clearance and obtain it when required. Information on ethical clearance can be found at http://www.uq.edu.au/research/orps/index.html?page=5064&pid=5256.

Learning Summary

 

Below is a table showing the relationship between the learning objectives for this course and the broader graduate attributes developed, the learning activities used to develop each objective and the assessment task used to assess each objective.

Learning Objectives

After successfully completing this course you should be able to:

1  Have consolidated understanding of main issues in centralised databases.
2  Understand how these principles must be adapted in a distributed database environment
3  Understand the effect of multiple organisations on distributed information systems
4  Understand key principles of data warehousing
5  Understand key principles of data quality and cleansing.
6  Understand key principles of spatial databases
7  Understand key issues in XML databases in a historical context
8  Understand database aspects of RFID and sensor networks


Assessment & Learning Activities

  Learning Objectives
  1 2 3 4 5 6 7 8
Learning Activities
Introduction (Lecture)
selected
             
Fundamentals of DBMS (Lecture)  
selected
           
Distributed DB design (Lecture)  
selected
           
Distributed Query Processing (Lecture)  
selected
           
Distributed Transactions (Lecture)  
selected
           
Database Systems Integration (Lecture)    
selected
         
Data Warehousing (Lecture)      
selected
       
Data Models (Lecture)            
selected
 
Data Cleansing (Lecture)        
selected
     
Spatial Data Management (Lecture)          
selected
   
RFID and Sensor Networks (Lecture)              
selected
Review (Lecture)  
selected
selected
selected
selected
selected
selected
selected
Assessment Tasks
Tutorial Exercise
selected
selected
selected
selected
selected
selected
selected
selected
Group Assignment
selected
selected
selected
         
In class exam
selected
selected
selected
         
Final examination
selected
selected
selected
selected
selected
selected
selected
selected

Graduate Attributes

Successfully completing this course will contribute to the recognition of your attainment of the following UQ (Undergrad Pass) graduate attributes:

  Learning Objectives
  1 2 3 4 5 6 7 8
Graduate Attributes
A IN-DEPTH KNOWLEDGE OF THE FIELD OF STUDY
A1. A comprehensive and well-founded knowledge in the field of study.
selected
selected
selected
selected
selected
selected
selected
selected
A4. An understanding of how other disciplines relate to the field of study.                
A5. An international perspective on the field of study.                
B EFFECTIVE COMMUNICATION
B1. The ability to collect, analyse and organise information and ideas and to convey those ideas clearly and fluently, in both written and spoken forms.  
selected
selected
         
B2. The ability to interact effectively with others in order to work towards a common outcome.                
B3. The ability to select and use the appropriate level, style and means of communication.                
B4. The ability to engage effectively and appropriately with information and communication technologies.                
C INDEPENDENCE AND CREATIVITY
C1. The ability to work and learn independently.
selected
selected
selected
         
C3. The ability to generate ideas and adapt innovatively to changing environments.    
selected
 
selected
     
C4. The ability to identify problems, create solutions, innovate and improve current practices.  
selected
selected
 
selected
     
D CRITICAL JUDGEMENT
D1. The ability to define and analyse problems.
selected
selected
selected
selected
selected
selected
selected
selected
D2. The ability to apply critical reasoning to issues through independent thought and informed judgement.  
selected
selected
 
selected
selected
selected
selected
D3. The ability to evaluate opinions, make decisions and to reflect critically on the justifications for decisions.  
selected
selected
selected
selected
selected
selected
selected
E ETHICAL AND SOCIAL UNDERSTANDING
E1. An understanding of social and civic responsibility.                
E2. An appreciation of the philosophical and social contexts of a discipline.  
selected
selected
 
selected
     
E4. A knowledge and respect of ethics and ethical standards in relation to a major area of study.                
E5. A knowledge of other cultures and times and an appreciation of cultural diversity.                

Successfully completing this course will contribute to the recognition of your attainment of the following Engineers Australia graduate attributes:

  Learning Objectives
  1 2 3 4 5 6 7 8
Graduate Attributes
1. Ability to apply knowledge of basic science and engineering fundamentals
selected
selected
selected
selected
selected
selected
selected
selected
2. Ability to communicate effectively, not only with engineers, but also with the community at large                
3. In-depth technical competence in at least one engineering discipline
selected
selected
selected
selected
selected
selected
selected
selected
4. Ability to undertake problem identification, formulation and solution  
selected
selected
selected
selected
selected
selected
selected
5. Ability to utilise a systems approach to design and operational performance  
selected
selected
selected
selected
selected
selected
selected
6. Ability to function effectively as an individual and in multi-disciplinary and multi-cultural teams, with the capacity to be a team leader or manager as well as an effective team member                
7. Understanding of the social, cultural, global and environmental responsibilities of the professional engineer, and for the need for sustainable development                
8. Understanding of the principles of sustainable design and development  
selected
           
9. Understanding of and commitment to professional and ethical responsibilities                
10. Expectation and capacity to undertake life-long learning