Course Title: Model data objects

Part B: Course Detail

Teaching Period: Term1 2011

Course Code: COSC5353C

Course Title: Model data objects

School: 650T TAFE Business

Campus: City Campus

Program: C6074 - Advanced Diploma of Information Technology

Course Contact : Chandra Nannegari

Course Contact Phone: +61 3 99251657

Course Contact

Name and Contact Details of All Other Relevant Staff

Nominal Hours: 30

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites


Course Description

This unit defines the competency required to understand business operations, identify entities and data, diagrammatically represent their relationships and prepare a data model

If you are undertaking this course in Melbourne from semester 2, 2012 onwards your teacher will advise you if you require access to a computer for the course. It is recommended that you have access to a mobile computing device to allow greater flexibility in terms of where you can work on campus outside class times.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAA5153A Model data objects


1. Identify entities and relationships

Performance Criteria:

1.1 Analyse business data to understand operations
1.2 Identify boundaries of the system
1.3 Identify entities, attributes, data types and relationships of data
1.4 Review business rules to determine impact
1.5 Document relationships in an entity relationship diagram


2. Develop normalisation

Performance Criteria:

2.1 Identify suitable business data
2.2 Undertake normalisation of business data and document results
2.3 Compare normalisation results with entity relationship diagram
2.4 Reconcile differences between data, if any


3. Validate model

Performance Criteria:

3.1 Validate data model with client
3.2 Resolve issues or recommendations arising
3.3 Document completed data model
3.4 Submit to client for final approval

Learning Outcomes

Details of Learning Activities

In this course students will have practical lab sessions and out-of-class research (studying) and homework (including the design and implementation of a major project).

Teaching Schedule

(Please Note: The total number of scheduled hours of teaching, learning and assessment involved in this course will include all planned activities. This may incorporate face-to-face classes, lectures, workshops and seminars; wherever possible workplace visits, online learning and other forms of structured teaching and learning. The total scheduled hours includes the amount of effort required to undertake, evaluate and complete all assessment requirements, including observation of work performance, discussions with supervisors and others providing third party evidence and one on one and group assessment sessions with students.)Weekly Breakdown
WeekWeek Beginning (Monday)                            Weekly TopicsResources
Textbook: Modern Database Management 9th Edn.
17th Feb 2011Review of relational DB concepts. Keys. Determinants & dependants.Textbook: Chapter 1
Class Handout: Worksheet
 Worksheet Assessment - 1
214th Feb 2011Scope and functionality of DB continued. ProjectTextbook: Chapter 5
Class Handout: Worksheet
321st Feb 2011Steps in normalisationTextbook: Chapter 5
Class Handout: Worksheet
428th Feb 2011Relational schema. Normal forms -1NF & 2NF Textbook: Chapter 5 
57th Mar 2011Normal forms - 3NF & BCNF. Steps in database development.Textbook: Chapter 5 Worksheet Assessment - 1
614th Mar 2011ERD concepts. Unary, binary & ternary relationships. Weak and strong entities. Textbook: Chapter 3

 Worksheet Assessment - 1

721st Mar 2011Recursive relationships. IS A relationships. Participation Constraint. Textbook: Chapter 3Worksheet Assessment - 1
828th Mar 2011

Developing a design. Business RulesTextbook: Chapter 3 & 4 
94th Apr 2011ERD’s continued.Textbook: Chapter 3

 Assessment - 2: (Project: ERD, RS, BR) CA / NYC

1011th Apr 2011ERD’s continued.Textbook: Chapter 4

 Worksheet Assessment - 1 Project Feedback

1118th Apr 2011Data validation.- data type, length, default value Worksheet - In-class exercise

Worksheet Assessment - 1 Project Feedback

 Mid Semester Easter Break                                        Wed 21st April - Thurs 27th April 2011
1125th Apr 2011Data validation.- data type, length, default valueWorksheet - In-class exercise Worksheet Assessment - 1 Project Feedback
 12 2nd May 2011 Data dictionary – identifiers are selected and documented. Textbook: Chapter 4 Worksheet Assessment - 1 Project Feedback
 139th May 2011 Validation of data model by client. Textbook: Chapter 2Project Feedback
 14 16th May 2011 Resolution of issues. Documentation of validation process Worksheet - In-class exercise Project Feedback
 15 23rd May 2011 Assessment - 2:Complete Project Submission. Exam Revision. Work on Project  
 16 30th May 2011                                                        Assessment - 3:   TEST          


"Students, who have been granted special consideration or are required to resubmit, will be able to submit/sit their assessment by arrangement with the class teacher in weeks 17 or 18."

Learning Resources

Prescribed Texts

Hoffer , Prescott & Topi, Modern Database Management 9/E , Prentice Hall



David M. Kroenke, Database Processing: Fundamentals, Design & Implementation, 9th Edition. Prentice Hall, ISBN 0-13-120971-X

Peter Rob & Carlos Coronel, Database Systems: Design, Implementation & Management, 5th Edition, Course Technology, ISBN 0-619-06269-X . Any book that you can find on Database modelling.

Other Resources

Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework, assignments, group and/or individual projects and in class exercises, written tests, practical problem solving exercises, presentations, practical tests and a final exam. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.

Students will be provided with feedback throughout the course to check their progress.


Assessment Tasks

Assessment 1 (Worksheets): 30%

The purpose of these worksheets is to provide feedback to students about their learning and observe them doing the required course material in the class. Therefore students will gain an understanding of the steps involved in solving database design problems, which includes functional dependencies, normalisation, ERD and ERD mapping for implementation, validating the model and documentation. Printouts (or electronic copy in Drop box) are to be submitted during class. Unfortunately, it will not be possible to accept late submissions or e-mail submissions.

Assessment 2 (Project): 35%

The purpose of this project is to ensure that students are able to implement all the skills they have developed to date.

A case study or real life project is defined and made available to students in Week 2. The students will be required to submit as a project assignment in two stages (Refer weekly breakdown). During this period each student is given feed back on their project for further improvement in their model mimicking the industry approach to a design problem

Assessment 3 (Test): 35%

A final examination will be offered to students who have achieved CA.

Assessment Matrix

 Assessment 1 (Work Sheets)Assessment 2 (Project)Assessment 3 (Test)
Identify entities and relationshipsYesYesYes
Develop normalisationYesYesYes
Validate modelYesYes 
MarkCA / NYC

Other Information

Competency and Grading Requirements:

To be deemed competent students must demonstrate an understanding of all elements of a competency. Assessment methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.

All assessments for this course must be completed to achieve a CA (Competency Achieved) grade.

Each assessment task will also carry a numerical weighting to be used for grading purposes. The grade applied to this weighting will only be awarded if a CA has been achieved in all compulsory assessment tasks.

If a student has been marked NYC (Not Yet Competent) in any of the assessment tasks, the weighting will carry no value until the student has obtained a CA.
If a CA is achieved on re-assessment then a maximum mark of 50% of the original weighting will be granted for that assessment.
Reassessments will only be granted to students who were either unsuccessful in the first attempt or have an approved special consideration application.

A final test worth 35% will be offered to students who have achieved CA.

Course Overview: Access Course Overview