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 Email:Chandra.Nannegari@rmit.edu.au
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
NONE
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 |
Element: |
1. Identify entities and relationships |
Performance Criteria: |
1.1 Analyse business data to understand operations |
Element: |
2. Develop normalisation |
Performance Criteria: |
2.1 Identify suitable business data |
Element: |
3. Validate model |
Performance Criteria: |
3.1 Validate data model with client |
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
| Week | Week Beginning (Monday) | Weekly Topics | Resources Textbook: Modern Database Management 9th Edn. |
Assessments |
| 1 | 7th Feb 2011 | Review of relational DB concepts. Keys. Determinants & dependants. | Textbook: Chapter 1 Class Handout: Worksheet |
Worksheet Assessment - 1 |
| 2 | 14th Feb 2011 | Scope and functionality of DB continued. Project | Textbook: Chapter 5 Class Handout: Worksheet |
|
| 3 | 21st Feb 2011 | Steps in normalisation | Textbook: Chapter 5 Class Handout: Worksheet |
|
| 4 | 28th Feb 2011 | Relational schema. Normal forms -1NF & 2NF | Textbook: Chapter 5 | |
| 5 | 7th Mar 2011 | Normal forms - 3NF & BCNF. Steps in database development. | Textbook: Chapter 5 | Worksheet Assessment - 1 |
| 6 | 14th Mar 2011 | ERD concepts. Unary, binary & ternary relationships. Weak and strong entities. | Textbook: Chapter 3 | Worksheet Assessment - 1 |
| 7 | 21st Mar 2011 | Recursive relationships. IS A relationships. Participation Constraint. | Textbook: Chapter 3 | Worksheet Assessment - 1 |
| 8 | 28th Mar 2011 |
Developing a design. Business Rules | Textbook: Chapter 3 & 4 | |
| 9 | 4th Apr 2011 | ERD’s continued. | Textbook: Chapter 3 | Assessment - 2: (Project: ERD, RS, BR) CA / NYC |
| 10 | 11th Apr 2011 | ERD’s continued. | Textbook: Chapter 4 | Worksheet Assessment - 1 Project Feedback |
| 11 | 18th Apr 2011 | Data 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 | ||||
| 11 | 25th Apr 2011 | Data validation.- data type, length, default value | Worksheet - 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 |
| 13 | 9th May 2011 | Validation of data model by client. | Textbook: Chapter 2 | Project 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 | 35% |
Learning Resources
Prescribed Texts
Hoffer , Prescott & Topi, Modern Database Management 9/E , Prentice Hall |
9780136003915 |
References
David M. Kroenke, Database Processing: Fundamentals, Design & Implementation, 9th Edition. Prentice Hall, ISBN 0-13-120971-X |
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 relationships | Yes | Yes | Yes |
| Develop normalisation | Yes | Yes | Yes |
| Validate model | Yes | Yes | |
| Mark | CA / NYC 30% |
CA / NYC 35% |
35% |
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