SISAT

School of Information Systems and Technology

Faculty of Informatics

BUSS311 – Advanced Database Management Systems Subject Outline

Autumn Session 2007

Head of School –Associate Professor Peter Hyland, Student Resource Centre, Tel: (02) 4221 3606

General Information

	Omar Garcia
Telephone Number:	4221 5290
Email:	omar@uow.edu.au
Location:	40.252

Mr Garcia’s Consultation Times During Session

Subject Organisation

Session:

Autumn session, Wollongong Campus

Credit Points

6 credit points

Contact hours per week:

2L,2CL

Lecture Times & Location:

Lecture

Tue

17:30

19:30

40.HOPE

Tutorial Day, Time and Location can be found at:

http://www.uow.edu.au/student/sols/timetables/index.html

Lecture Program (subject to minor changes)

	Topics Covered	Readings
1	Revision: DBMS Concepts	Chapter 1, 2
2	The relational Model and SQL	Chapter 3, 5
3	Conceptual Modeling with E-R and UML diagrams	Chapter 4
4	Database Design With Normalization Concepts	Chapter 6
5	Object relational Databases	Chapter 14
6	Object relational Databases (cont)	Chapter 14
7	Midterm exam
8	XML and Web Data	Chapter 15
9	OLAP and Data Mining	Chapter 17
10	OLAP and Data Mining (cont)	Notes
11	Spatial Database Systems & Map Web Services	Notes
12	Database Tuning	Chapter 12
13	Review and Final Exam preparation

Students should check the subject’s web site regularly as important information, including details of unavoidable changes in assessment requirements will be posted from time to time. Any information posted to the web site is deemed to have been notified to all students.

Content

This subject provides an overview of the relational data model and relational database management systems followed by comprehensive coverage of some of the advanced topics related to data and database administration, CASE tools, post-relational database systems and recent developments in the areas of online analytical processing, data mining and the World Wide Web (WWW). Discussion of these relatively recent and advanced topics is expected to equip the student to meet the challenges in database management and advanced applications development in contemporary organisations. Students will be presented with opportunities to do hands-on work with appropriate commercial tools.

Objectives

On successful completion of this subject, the student should be able to: develop a good understanding of the critical issues in data and database administration; demonstrate a good understanding of the scope and functionalities of object-relational and object-oriented database management systems; demonstrate an understanding of the role, features and limitations of CASE tools in system design and development; understand the key conceptual issues and be conversant with some of the practical tools in the emerging areas of database management.

Attendance Requirements

It is the responsibility of students to attend all lectures/tutorials/labs/seminars/practical work for subjects for which you are enrolled.

It should be noted that according to Course Rule 003{Interpretation Point 2 (t)} each credit point for a single session subject has the value of about two hours per week including class attendance. Therefore, the amount of time spent on each 6 credit point subject should be at least 12 hours per week, which includes lectures/tutorials/labs etc

1. Silberschatz, Korth, and Sudarshan, 2005, 5th edition, Database System Concepts, McGraw-Hill, New York

2. Teorey, Toby, 2006, Database modeling & design, 4^th edition, Morgan Kaufmann publishers.

3. B. Bordoloi and D. Bock. (2004) Oracle SQL, Pearson Prentice Hall

4. Baklarz, G., Scoot, Dan, Zikopolous, Paul, 2005, Apache Derby, Off to the Races, IBM Press

5. Chong, R., Liu, C., Qi, S., Snow, D., 2005, Understanding DB2 : Learning Visually with Examples , IBM Press

6. Abiteboul, Buneman and Suciu, 2000, Data on the Web: From Relations to Semi-structured Data and XML, Morgan Kaufmann.

7. Han, J. and Kamber, M., 2001, Data Mining: Concepts and Techniques, Morgan Kaufmann publishers.

8. Imhoff, Claudia, 2003, Mastering data warehouse design: relational and dimensional technique, Wiley Pub.

These readings/references are recommended only and are not intended to be an exhaustive list. Students are encouraged to use the library catalogue and databases to locate additional readings

Assessment

Description % Final Mark Due Date

Assignment1: SQL Review	4%	Week 3 before the first Lab
Assignment 2: DB Design	9%	Week 4 before the first Lab
Assignment 3: Object Relational	9%	Week 7 before the first Lab
Assignment 4: XML	4%	Week 8 before the first Lab
Assignment 5: Data Warehouse	4%	Week 9 before the first Lab
Midterm Exam	20%	Week 7 at Lecture time
Final Exam	50%	Exam Weeks

Assignments must be done in pairs. The solution to the assignment has to be demonstrated or explained by only one student. The selected person will be chosen at random and the other student will be asked to leave the laboratory. Both students get the same mark. You may pair differently for each assignment; however groups must be signed during the laboratory when the assignment is explained. All assignments require building software/databases using SQL. Assignment 2 and 3 require an additional report. Code and report must be submitted electronically in e-Learning (previously Vista/WebCT) before the time for the first lab of the week independently of the laboratory the student is enrolled

Assessment tasks which are relevant to the final examination for the subject will be marked and available for collection (in the labs) prior to the study week before the final examination.

A SISAT assignment cover sheet should be attached to each piece of written assessment.

Penalties for late submission of assessment

Assessed work must be handed in by the date and time given. Assessed work handed in late can be penalised by the deduction (from the mark given to the assessed work) of 2 points per 24 hours of the weekday or part thereof. The operation of this rule will not result in a negative mark being carried forward.

Special consideration

An extension of time for the completion of an assignment may be granted in certain circumstances. A request for an extension must be made to the Subject Coordinator via SOLs before the due date

Scaling

Final results in this subject may be scaled. The scaling method that will be used in this subject is as follows.

If E is the student exam mark, and A is the student assignment mark, the student final mark will be determined as follows:

if E >= 40% of the maximum exam mark: then student final mark is E + A;

if E < 40% of the maximum exam mark: then student final mark is /min/{E+A, 47};

if E < 35% of the maximum exam mark: then student: final mark is /min/{E+A, 42}.

Additional Information

Students must refer to the Faculty Handbook or online references which contains a range of policies on educational issues and student matters.

Supplementary Exams

While the School normally grants supplementary exams when the student does not sit the standard exam for an acceptable reason, each case will be assessed on its own merit and there is no guarantee a supplementary exam will be granted. If a supplementary exam is granted the date will be determined by the University via ARD. You will be notified via SOLS Mail the time and date of this supplementary exam. You must follow the instructions given in the email message.

Please note that if this is your last session and you are granted a supplementary exam, be aware that your results will not be processed in time to meet the graduation deadline.

Plagiarism

When you submit an assessment task, you are declaring the following

1. It is your own work and you did not collaborate with or copy from others.

2. You have read and understand your responsibilities under the University of Wollongong's policy on plagiarism.

3. You have not plagiarised from published work (including the internet). Where you have used the work from others, you have referenced it in the text and provided a reference list at the end ot the assignment.

4. Plagiarism will not be tolerated.

5. Students are responsible for submitting original work for assessment, without plagiarising or cheating, abiding by the University’s policies on Plagiarism as set out in the Calendar under University Policies, and in Faculty handbooks and subject guides. Plagiarism has led to the expulsion from the University.

This outline should be read in conjunction with the following documents:

Code of Practice - Teaching and Assessment

http://www.uow.edu.au/handbook/codesofprac/teaching_code.html

Key Dates

http://www.uow.edu.au/student/dates.html

Code of Practice - Students

http://www.uow.edu.au/handbook/codesofprac/cop_students.html

Information Literacies Introduction Program

http://www.library.uow.edu.au/helptraining/workshops/ilip/

Acknowledgement Practice Plagiarism will not be tolerated

http://www.uow.edu.au/handbook/courserules/plagiarism.html

Student Academic Grievance Policy