The unit is a core unit in the new Bachelor of Software Engineering (Honours) degree to be introduced in 2016.

29/08/2017 - Admin: update prerequisites to include a new unit being introduced as part of the redevelopment of the Bachelor of Computer Science Advanced (Honours) for 2018.

June 2017 (2): Amendment to prerequisites after discussion with David Taniar, Arun Konagurthu and David Albrecht. Change prerequisite to a level 1 programming unit to make unit available to BCSAH students. Effective 2018 (first offering in S1 2018). This makes the prerequisites consistent with FIT2094 (the units will be co-taught).

June 2017. Updating exam hours from 3 to 2 hours as required by new University Examination procedures, effective S1 2018.

February 2018: Amendment to workload "Additional hours" so that it adds up to 12 hours/week.

24/9/19: Admin - updating the exam duration to include additional 10 minutes as per University requirement.

06/11/2019: Admin - adding Reasons for Change - CE Modified Workload/ContactHours (lectures changed into workshops and labs changed into tutorials) to support new version of the unit which will be conducted in Woodside building for 2020. This changes have been discussed with 2019 CE (Marc Cheong) on 5 November 2019. I will be the CE for the unit in S1 2020.

23/09/2020 Admin: Update to include new assessment and teaching approach fields as per Handbook requirements.

15/02/2021: Change assessment regime following introduction of new University assessment guidelines and FLEX review/comments of 2020 offerings, date of implementation S1 2021

The unit will be co-taught with FIT2094. However, since the unit introduces database concepts to the Bachelor of Software Engineering (Honours) students, different tutorial contents and assignments will be designed for this unit. As this is a level-3 unit, the students would already have gained sufficient knowledge and experience in modelling and implementation in their previous units, more in-depth database modeling, designing and programming skills will be tested in FIT3171.

At the completion of this unit, students should be able to:

1. explain the motivations behind the development of database management systems;
2. describe the underlying theoretical basis of the relational database model and apply the theories into practice;
3. critically compared the design constructs of object oriented model and relational model design;
4. develop a sound database design;
5. implement a database based on a sound database design;
6. construct queries that meet user requirements;
7. develop an application with a database backend;
8. use data modelling and database development tools effectively;

020301, 020303, 020305

This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. Students will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system (Oracle). Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

Students are required to have access to a copy of the textbook Coronel, C., & Morris, Steven, Database Systems: Design, Implementation, and Management (Version 12 or 13 is suitable).

The Library has 12th and 13th Editions available as hard copies for borrowing. There is also access to an online version of the 12th Edition via Monash Library

Students are recommended to purchase the digital version of the textbook as an eBook from http://bit.ly/2NYK937. As an eBook, students will have immediate access (the text can be accessed online via the Cengage eReader using your desktop or mobile web browser.). A discount voucher for this purchase will be available from the Unit Moodle Website in week 0

Recommended resources

This unit will make use of the Oracle 12 database running on a Monash server. All students will have an account on this server which will suffice for all database work this semester. To access this server students will need to install and run the Monash VPN software (details available from the Moodle site).

The client software for accessing Oracle (SQL Developer) will be available via a download from the Unit Moodle site - students must ONLY use the prescribed version available from Moodle, you must not download and use SQL Developer from any other site.

Technological requirements

Monash FIT GitLab Server All students will be required to maintain their unit work on the FIT GitLab server https://git.infotech.monash.edu/ to both provide a secure repository for work completed and to demonstrate a clear development history. Students will be provided with an account on this server.

Moodle

All students must regularly check Moodle for announcements. In addition, for assignment 1A and assignment 1B, Moodle forums will act as a 'client' to students allowing them to clarify any design/task issues - the responses posted to these forums by the moderator will be regarded as part of the assignment brief. Failure to note these postings and implement/integrate them as part of your solution will incur grade penalties.

On-campus

Peer-assisted learning In this unit, we plan to use a peer-assisted learning approach. To maximise the learning experience for students in this approach, students are expected to read the suggested sections from the textbook prior to attending the workshop sessions . The preparation prior to the workshop is CRUCIAL to the successful participation of students in peer-assisted learning during the workshop sessions.

Examination (2 hours and 10 minutes): 50%; In-semester assessment: 50%

1. Workshop Exercise - 5% - ULO: 1, 2, 3, 4, 5, 6, 7, 8
2. Assignment 1A: Conceptual Model (UML and ERD): - 5% - ULO: 2, 3, 4
3. Assignment 1B: Full Database Model and Implementation: - 15% - ULO: 2, 4, 5, 8
4. Assignment 2A: SQL Database Creation/Modification - 10% - ULO: 2, 5, 8
5. Assignment 2B: SQL Queries and PL/SQL - 15% - ULO: 2, 6, 7 , 8
6. End of semester examination - 50% - ULO: 1, 2, 3, 4, 5, 6, 7, 8

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

(b.) Additional requirements (all students):

Oracle database, SQL Developer , Response gathering system for the Peer Instruction.

One of FIT1045, FIT1053, FIT1048, FIT1051 or ENG1003