Skip to content | Change text size

M O N A T A R

InfoTech Unit Avatar

MMS2801 Database Management Systems(DISESTABLISHED FB 05/07)

Chief Examiner

This field records the Chief Examiner for unit approval purposes. It does not publish, and can only be edited by Faculty Office staff

To update the published Chief Examiner, you will need to update the Faculty Information/Contact Person field below.

NB: This view restricted to entries modified on or after 19990401000000

Unit Code, Name, Abbreviation

MMS2801 Database Management Systems(DISESTABLISHED FB 05/07) (14 Dec 2007, 4:29pm) [DBMS]

Reasons for Introduction

Obsolete Reasons for Introduction

In moving ownership of the GCO (GSCIT) units in the on-campus version of the Bachelor of Multimedia Computing to the School of Multimedia Systems (Berwick), a restructure has taken place of the course as detailed in the separate course amendment proposal.This unit aims to provide students with an understanding of the principles and terminology of database management systems and database design so that they are able to design, implement and manage efficient database systems.22/07/2003 Revision - MMS2801 is a second level core to the Bachelor of Multimedia Systems to be introduced in 2004. The aim of the unit remains as stated above.

Reasons for Change (10 Jun 2004, 2:12pm)

18th Feb 2004 - Add a semester 2 offering to support mid semester entry and students who need to repeat the unit (this unit is a core unit in the BMS)

10th June 2004 - modification of assignment tasks to two task rather than three (no change to weighting)

Objectives

Unit Content

Teaching Methods

Assessment

Strategies of Assessment (10 Jun 2004, 2:13pm)

The final mark will be calculated using a weighting formula:

final grade = (R*A* E)/((R-1)*A+E)

where A = overall assignment percentage, E = examination percentage, R = 100/assignment weight

If a student achieves a grade of 0% for assignments the final grade will be:

Final grade = E / 2.5

If a student achieves a grade of 0% for the examination the final grade will be:

Final grade = A / 2.5

Workloads

Resource Requirements

Software Requirements (21 Oct 2005, 1:04pm)

Software Required:

  1. Latest version of full Oracle SQL for Windows XP Client (including sqlldr) - available under Monash University licence
  2. Latest version of SQL Tools, available from http://www.sqltools.net/ - free licence
  3. Latest version of Database Design Studio (DDS) - SMS School based licence contact SMS Technical Services staff
  4. Access to the Monash University Oracle Server (orac.its.monash.edu.au) running at least Oracle 8.5
  5. Access to a web server, via SFTP/SCP, which students can place files on and which supports ColdFusion with a connection to item 4 above

Prerequisites

Proposed year of Introduction (for new units) (25 Jul 2006, 2:59pm)

2002, S1 and then as scheduled

Frequency of Offering (25 Jul 2006, 2:59pm)

Semester 2 2007

Faculty Information

Proposer

Lindsay Smith

Approvals

School: 14 Dec 2007 (Julianna Dawidowicz)
Faculty Education Committee: 14 Dec 2007 (Julianna Dawidowicz)
Faculty Board: 17 Dec 2007 (Julianna Dawidowicz)
ADT:
Faculty Manager:
Dean's Advisory Council:
Other:

Version History

22 Jul 2003 Lindsay Smith Update of MMS2801 for inclusion in the BMS (2004)
24 Jul 2003 Melanie Smith minor edit
24 Jul 2003 Lindsay Smith SMS SEC Approval Meeting 04/03
25 Jul 2003 Lindsay Smith Add prohibition BUS3112 - request from J. Betts
11 Aug 2003 Lindsay Smith Reclassify tutorial requirements as laboratory requirements as per FEC steering Committee recommendation
17 Aug 2003 Lindsay Smith Add SIMS prohibitions as requested at FEC 5/03 - IMS1907, IMS2112
19 Aug 2003 Denise Martin FEC Approval
01 Sep 2003 Annabelle McDougall FacultyBoard Approval
19 Feb 2004 Lindsay Smith Add semester 2 offering; modified Frequency; modified ReasonsForIntroduction/RChange; modified ReasonsForIntroduction/RChange
20 Feb 2004 Lindsay Smith SMS Approval
15 Mar 2004 Denise Martin FEC Approval
26 Mar 2004 Annabelle McDougall FacultyBoard Approval
10 Jun 2004 Lindsay Smith modified ReasonsForIntroduction/RChange; modified Assessment/Strategies; modified ResourceReqs/SoftwareReqs
10 Jun 2004 Lindsay Smith SMS Approval
11 Jun 2004 Lindsay Smith MMS School Approval, http://www.multimedia.monash.edu/staff/staffonly/sec/2004/0204secmin.html
28 Jun 2004 Ralph Gillon FEC Approval
20 Jul 2004 Annabelle McDougall FacultyBoard Approval
15 Nov 2004 Lindsay Smith modified ResourceReqs/SoftwareReqs
17 Oct 2005 David Sole Added Software requrirements template
21 Oct 2005 David Sole Updated requirements template to new format
25 Jul 2006 Melanie Smith changed offering to S2 2007
14 Dec 2007 Julianna Dawidowicz modified UnitName
14 Dec 2007 Julianna Dawidowicz MMS2801 Chief Examiner Approval, ( proxy school approval )
14 Dec 2007 Julianna Dawidowicz FEC Approval
14 Dec 2007 Julianna Dawidowicz FacultyBoard Approval - Faculty Board approved the disestablishment of this unit at 05/07 meeting
17 Dec 2007 Julianna Dawidowicz FacultyBoard Approval - Faculty Board approved the disestablishment of this unit at 05/07 meeting

This version: