SCSSE

School of Computer Science & Software Engineering

Faculty of Informatics

CSCI315 Database Design and Implementation Subject Outline

Autumn Session 2007

Head of School –Professor Philip Ogunbona, Student Resource Centre, Tel: (02) 4221 3606

General Information

	Dr Tianbing Xia
Telephone Number:	4221 3076
Email:	txia@uow.edu.au
Location:	3.205

Dr Xia’s Consultation Times During Session

Subject Organisation

Session:

Autumn Session, Wollongong

Credit Points

Contact hours per week:

3 hours lectures, 2 hours lab

Lecture Times & Location:

Lecture A

Fri

12:30

14:30

20.5

Lecture B

Wed

11:30

12:30

35.G20

Tutorial Day, Time and Location can be found at:

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

Lecture Schedule (subject to change)

Week	Topics	Comments
1	Course information, Conceptual design: conceptual modelling: abstractions, aggregations, associations, Physical design: Implementation of Web based database applications	NO LAB CLASSES
2	Conceptual design: object-oriented approach to conceptual database modeling Physical design: Enforcing database consistency constraints with database triggers	LABORATORIES COMMENCE
3	Conceptual design: Quality of conceptual modelling Physical design: Enforcing database consistency constraints with database triggers (cont.)
4	Conceptual design: Quality of conceptual modelling Physical design: Internal structures of relational database systems
5	Conceptual design: Advanced object modelling, object meta-modeling Physical design: Internal structures of relational database systems (cont.)
6	Conceptual design: Modelling historical information, Physical design: Storage allocation strategies, Materialized views
7	Conceptual design: Conceptual modelling strategies, integration of conceptual models, Physical design: Materialized view, Partitioned relational tables
8	Conceptual design: Patterns in conceptual modelling Physical design: Intuitive and analytical approaches to database indexing
9	Conceptual design: Object model transformations: performance and implementation driven transformations, simplifications Physical design: Intuitive and analytical approaches to database indexing (cont)	TEST
10	Conceptual design: Object model transformations: migration of attributes, horizontal and vertical decomposition, Physical design: Intuitive and analytical approaches to database indexing (cont)
11	Conceptual design: Object model transformations: dealing with generalizations Physical design: Intuitive and analytical approaches to database indexing (cont)
12	Conceptual design: Object model transformations: translation into implentation model Physical design: Intuitive and analytical approach to database clustering
13	Conceptual design: Database reverse engineering Physical design: Intuitive and analytical approach to database clustering (cont.)

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 investigates the process of relational database design starting from conceptual database design, through logical database design up to and including physical database design, database tuning and administration. The topics will include conceptual database design based on Object Modelling Technique, methodologies for conceptual design, view integration, logical database design, database normalization and de-normalization, physical database design, generation of database applications, database tuning, design of distributed database systems.

Objectives

A student who successfully completes this subject should be able to:
(i) design a relational database using Object Modelling Technique in a systematic manner,
(ii) prove the correctness of the final design using the formal techniques,
(iii) carry out cost/benefit analysis of the final design in the terms of physical database design techniques,
(iv) implement the design using commercially available database application generators,
(v) carry out performance evaluation tests and evaluate his/her implementation against a range of criteria using the best test results,
(vi) explain an internal organisation of a sample relational database system,
(vii) carry out the basic functions of database administrator,
(viii) design a distributed database system.

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

All laboratory classes are compulsory

Participation in laboratory classes is compulsory. Absence from a laboratory class may decreases the maximum mark available for an implementation part of the respective assignment by 0.5 mark. For example, if the maximum evaluation of the implementation part is equal to 1.5 mark then absence in one lab class reduces the maximum evaluation to 1, absence in two lab classes reduces the maximum evaluation to 0.5, etc. A lab class may be repeated only when special consideration has been granted.

Attendance in laboratory classes will be marked by a tutor during the last 10 minutes of each lab session. Students are strongly recommended to verify their attendance mark before leaving a lab.

Satisfactory attendance is deemed to be attendance at approximately 80%* of the allocated contact hours. Attendance rolls may be kept for lectures, TUTORIALS and laboratories. If you are present for less than 80%* you need to apply for special consideration, otherwise a fail grade may be recorded.

Students MUST attend their allocated tutorial unless they have the written permission of the subject coordinator.

Laboratory classes will include the elements of physical database design, database tuning and database administration. Oracle Database Server 10g will be used for all work in the laboratories. Moreover, Oracle HTTP Listener ver. 10g. will be used for implementation of database applications. The laboratories will demonstrate the typical approaches to implementation of database applications, will show how to tune database applications, and will include the elements of database administration.

Contact hours for this subject comprise 3 hours of lectures and 2 hours of tutorials/labs. There is no tutorial/lab in week 1. Students should check the subject's web site regularly as important information, including details of the potential 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. Please note that the e-Learning website url is: www.uow.edu.au/student/lol/

Textbooks

R. Ramakrishnan and J. Gehrke Database Management Systems, WCB/McGraw-Hill, 3rd edition, 2003 chapters 5, 7, 8, 9, 10, 11, 20, 25

The book is available from the University Union Bookshop. It is also included in the Reserve Collection of UoW Library.

Blaha, M., Premerlani, W., Object-Oriented Modeling and Design for Database Applications, Prentice-Hall Inc., 1998, chapters 2, 3, 4

The book is included in the Reserve Collection of UoW Library. The chapters 3, 4 are available on The e-Learning website through electronic readings.

Batini, C., Ceri, S., Navathe, S. B., Conceptual Database Design An Entity Relationship Approach, The Benjamin/ Cummings Publishing Company, Inc., 1992

The book is included in the Reserve Collection of UoW Library. The chapters 5, 6 are available on the e-Learning website through electronic readings.

Oracle manuals available on https://sai.uow.edu.au/oradocs, the links to relevant chapters in the manuals are included in the laboratory specifications.

Oracle textbooks available on Safari Bookshelf (O'Reilly Network), access through a link to Proquest Safari website, the links to relevant chapters in the textbooks are included in the laboratory specifications.

H. Garcia-Molina, J.D.Ullman, J. Widom Database Systems The Complete Book, Prentice Hall, 2002,

The book is available in UoW Library.

Lecture notes and slides

Lecture slides are provided as PowerPoint presentations in Pdf format, 6 slides per page, designed using black & white template. Lecture notes are provided as files in Pdf format. Both lecture notes and slides are available on the e-Learning website.

1. Assignments

Include: conceptual modeling, programming database applications, programming of database server, physical database design and implementation, administration of relational database server

25% (3*6%, 7%)

Assignment 1: Week 4, hard copy

Assignment 2: Week 7, hard copy

Assignment 3: Week 10, hard copy

Assignment 4: Week 12, hard copy

2. Class tests

(1.5 hours, 4 questions)

15%

Week 9, hard copy

Final Examination

60%

During Exam Period

Assignments

Specifications of all assignments will be released in electronic format ONLY. There will be NO printed hardcopies distributed during lectures or lab classes. The students will collect the electronic copies of specifications from the e-Learning website.

Each assignment will consist of a database design component and database implementation component. Evaluation of a design component will take under consideration the completeness and correctness of the design and its consistency with the given specification. Evaluation of an implementation component will take under consideration the correctness of the solution and its consistency with the given specification.

Assignments are to be submitted personally to your lecturer. Students are allowed to submit assignments during office hours (room 3.205, room 3.218), during 10 minutes after each lecture class (lecture hall), during laboratory classes (bldg. 3 room 124), or during an assignment submission session (room 3.205, room 3.218) 3 hours before the assignment deadline. All submissions must be accompanied by a SCSSE Assignment Cover Sheet available from the School office. No assignments will be accepted without a SCSSE Assignment Cover Sheet. The students must collect a submission receipt signed by a lecturer. All assignments that do not satisfy the submission requirements listed above will not be evaluated and will be returned to the students during the next lab class with mark of 0.

Assignments should be submitted on their respective due dates (please see a table above). Penalties may apply to all late work, except if special consideration is deemed necessary or unless an extension has been granted by your subject coordinator or lecturer. Requests for extensions should be submitted to the lecturer or coordinator as Special Consideration (SC), prior to the due date.

25% mark will be deducted for each day it is overdue. The students are allowed to perform late submissions during office hours (room 3.205 or room 3.218), during 10 minutes after each lecture class (lecture hall), or during laboratory classes (bldg. 3 room 124). Any documentation justifying a late submission must be attached to an assignment.

All assignments must be submitted as hard copy only.

Annotated copies of evaluated assignments will be personally returned to the students no later than 2 weeks after the respective submission date. All assignments will be returned to the students during laboratory classes.

All assignments are individual assignments and it is expected that all the problems will be solved individually without any cooperation with the other students. If you have any doubts, questions, etc. please consult your lecturer or tutor during lab classes or office hours.

Class Tests

There will be one class test during the session. The class test is compulsory and cannot be repeated. Absence in a class test will result in a 0 grade recorded for that assessment task, except when special consideration has been granted. There is no supplementary test.

The scope of the test will cover the contents of assignments, lab exercises and experiments previous the week 9. The evaluations of assignments will be returned to students at least one week before the respective class tests.

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