CIS 2002 Database Design

STAFFING:

REQUISITES:

RATIONALE:

An essential component of a successful information system is usually a well designed and efficient database. It is important for those who wish to become information systems practitioners to have a sound understanding of database theory and current trends. Furthermore, it is of crucial importance that information systems practitioners understand database design because databases are not only becoming pervasive but also inexorably larger and more complex.

SYNOPSIS:

This course introduces students to relational database theory and design. Practical methodologies for data analysis, data modelling and database design are examined, coupled with a detailed study of the relational database model. Students will build practical skills in ER diagramming, normalisation and database design. Students will also be exposed to a broad range of topics in database theory and current database trends.

OBJECTIVES:

On successful completion of this course, the student will be able to:

1. describe and discuss the relational database model;
2. describe, use and apply data analysis and modelling techniques, including ER diagramming and normalisation, and derive a relational database design;
3. demonstrate an ability to analyse and justify database designs, with clear verbal and written statements of any assumptions about the data; and
4. demonstrate an understanding of current database theory and trends.

TOPICS:

TEXT and MATERIALS required to be PURCHASED or accessed:

ALL textbooks and materials are available for purchase from USQ BOOKSHOP (unless otherwise stated). Orders may be placed via secure internet, free fax 1800642453, phone 07 46312742 (within Australia), or mail. Overseas students should fax +61 7 46311743, or phone +61 7 46312742. For costs, further details, and internet ordering, use the 'Textbook Search' facility at http://bookshop.usq.edu.au click 'Semester', then enter your 'Course Code' (no spaces).

REFERENCE MATERIALS:

STUDENT WORKLOAD REQUIREMENTS:

ASSESSMENT DETAILS:

NOTES:

1.

The examination is scheduled to be held in the end-of-semester examination period. Students will be advised of the official examination date for Exam (Parts A and B) after the timetable has been finalised. The total working time for Exam (Parts A and B) is 3 hours.

IMPORTANT ASSESSMENT INFORMATION

1. Attendance requirements:
   If you are an international student in Australia, you are advised to attend all classes at your campus. For all other students, there are no attendance requirements for this course. However, it is the students' responsibility to study all material provided to them or required to be accessed by them to maximise their chance of meeting the objectives of the course and to be informed of course-related activities and administration.
2. Requirements for students to complete each assessment item satisfactorily:
   To complete each of the assessment items satisfactorily, students must obtain at least 50% of the marks available for each assessment item.
3. Penalties for late submission of required work:
   If students submit assignments after the due date without prior approval then a penalty of 5% of the total marks available for the assignment will apply for each working day late. The assignment is likely to be subject to processing delays.
4. Requirements for student to be awarded a passing grade in the course:
   To be assured of receiving a passing grade a student must submit all of the summative assessment items, achieve a total mark of at least 50% in Part A and Part B of the examination, and at least 50% of the available weighted marks for the summative assessment items.
5. Method used to combine assessment results to attain final grade:
   The final grades for students will be assigned on the basis of the weighted aggregate of the marks (or grades) obtained for each of the summative assessment items in the course.
6. Examination information:
   This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination room. The examination consists of two parts. Part A (1 hour) is worth 35 marks and Part B (2 hours) is worth 65 marks.
7. Examination period when Deferred/Supplementary examinations will be held:
   Any Deferred or Supplementary examinations for this course will be held during the next examination period.
8. University Regulations:
   Students should read USQ Regulations 5.1 Definitions, 5.6. Assessment, and 5.10 Academic Misconduct for further information and to avoid actions which might contravene University Regulations. These regulations can be found at the URL http://www.usq.edu.au/corporateservices/calendar/part5.htm. Students should also read the Faculty of Business Guide to Policies and Procedures of the Faculty which can be found at the URL http://www.usq.edu.au/handbook/current/buspolproc.html.

ASSESSMENT NOTES

OTHER REQUIREMENTS:

1. Learning Resources: Prescribed texts and materials (see above); recommended reference materials (see above); printed Introductory Book, Book/s of Selected Readings, and Study Book/s; and course Website accessible via USQConnect.
2. E-mail and Internet Access: Students will require access to e-mail and Internet access to USQConnect for this course.