Course Title: Design a database
Part B: Course Detail
Teaching Period: Term1 2011
Course Code: COSC5331C
Course Title: Design a database
School: 650T TAFE Business
Campus: City Campus
Program: C5194 - Diploma of Information Technology (General)
Course Contact : Chandra Nannegari
Course Contact Phone: +61 3 9925 1657
Course Contact Email:chandra.nannegari@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Nominal Hours: 50
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 establish client needs and technical requirements and to design a database that meets those requirements.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICAA5139A Design a database |
Element: |
1. Determine database requirements |
Performance Criteria: |
1.1 Meet with client and conduct a user needs analysis to determine database functionality |
Element: |
2. Develop logical data model |
Performance Criteria: |
2.1 Identify attributes and determine data types |
Element: |
3. Design data structures |
Performance Criteria: |
3.1 Confirm primary and foreign keys for tables |
Element: |
4. Design queries, screens and reports |
Performance Criteria: |
4.1 Design user interface for database, including menus, input screens and outputs |
Element: |
5. Design access and security systems |
Performance Criteria: |
5.1 Review business security plan as basis for commencing access and security design |
Element: |
6. Confirm database design |
Performance Criteria: |
6.1 Identify database back up and recovery requirements |
Learning Outcomes
Details of Learning Activities
Theory presentations, practical lab classes, tutorial sessions plus out-of-class research and homework.
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.
Please Note that this Course is delivered in Sem 1, 2011 for Part Time students ONLY and this weekly breakdown is only for Group ICPT.
Week beginning | Topic/Learning Activities | Assessment Tasks | National Codes |
Week 1 – 7th Feb | Course introduction & overview. Database concepts. Single table databases, Primary keys, Forms, Data Structures | Teacher handouts in-class exercises. Assessment -1 | ICAA5046B ICAA5139A ICAB4170A |
Week 2 – 14th Feb | Business requirements. Intro to ERD’s. 1:M relationships & foreign keys. VBA basics. | Teacher handouts in-class exercises. | ICAA5046B ICAA5139A ICAB4170A |
Week 3 – 21nd Feb | More on ERD’s. M:N relationships & bridging tables, Binary & Ternary. VBA basics : Loops | Teacher handouts in-class exercises. | ICAA5046B ICAA5139A ICAB4170A |
Week 4 – 28th Feb | ERD’s continued. VBA continued. | Teacher handouts in-class exercises. Assessment -1. Project Posting. |
ICAA5046B ICAA5139A ICAB4170A |
Week 5 – 7th March | Referential integrity. Data entry for 1:M and M:N relationships, Business Rules. VBA Continued. | Teacher handouts in-class exercises. Assessment -1 | ICAA5046B ICAA5139A ICAB4170A |
Week 6 – 14th March | Building up more complex ERD’s. Logical Database design. | Teacher handouts in-class exercises. | ICAA5046B ICAA5139A ICAB4170A |
Week 7 – 21st March | ERD’s Continued. GUI components | Teacher handouts in-class exercises. Assessment -1 | ICAA5046B ICAA5139A ICAB4170A |
Week 8 – 28th March | Determinant & dependencies . GUI components continued. | Teacher handouts in-class exercises. Assessment -1 | ICAA5046B ICAA5139A ICAB4170A |
Week 9 – 4th April | Data Redundancy & Anomalies. Form and subform. | Teacher handouts in-class exercises. Assessment -1 | ICAA5046B ICAA5139A ICAB4170A |
Week 10 – 11th April | Steps in normalisation. Relational Schema. Normal Forms – 1NF, 2NF & 3 NF. Confirm DB Design. | Teacher handouts in-class exercises. Assessment -1. Assessment – 2: Stage 1 Project Submission Due. |
ICAA5046B ICAA5139A ICAB4170A |
Week 11 – 18th April | Normal Forms Continued. Data dictionaries. Prototype Created and populated. | Teacher handouts in-class exercises. Assessment -1. Project Feedback. |
ICAA5046B ICAA5139A ICAB4170A |
Mid semester Easter break Wed 21st April – Thurs 27th April, 2011 | ICAA5046B ICAA5139A ICAB4170A |
||
Week 11 – 25th April (25th Apr, public holiday) | Normal Forms Continued. Data dictionaries. Prototype Created and populated. | Teacher handouts in-class exercises. Assessment -1. Project Feedback. |
ICAA5046B ICAA5139A ICAB4170A |
Week 12 – 2rd May | Intro to basic SQL including functions, Identification of relevant software. DBMS constraints. Test Data Developed. | Teacher handouts in-class exercises. Project Feedback. |
ICAA5046B ICAA5139A ICAB4170A |
Week 13 – 9th May | Two-table queries in SQL. Table aliases. Security. Implementation plan. Post implementation review. | Teacher handouts in-class exercises. Assessment -1. Project Feedback. |
ICAA5046B ICAA5139A ICAB4170A |
Week 14 – 16th May | Action queries in SQL. DB design documented and confirmed. Evaluate Database. | Teacher handouts in-class exercises. Assessment -1. Project Feedback. |
ICAA5046B ICAA5139A ICAB4170A |
Week 15 – 24th May | Revision for TEST. Design reports. Backup and recovery requirements. | Teacher handouts in-class exercises. Assessment -1 Assessment -2: Stage 2 Complete Project Submission. |
ICAA5046B ICAA5139A ICAB4170A |
Week 16 – 30th May | Assessment 3 (TEST) | ICAA5046B ICAA5139A ICAB4170A |
Learning Resources
Prescribed Texts
Peter Rob, Carlos Coronel & Steven Morris, Database Systems: Design, Implementation & Management, 9th Edition, Course Technology. |
0-538-46968-4 |
References
David M. Kroenke, Database Processing: Fundamentals, Design & Implementation, 9th Edition. Prentice Hall. |
0-13-120971-X |
Jeffrey A. Hoffer, Prescott & Topi, Modern Database Management 9/E , Prentice Hall. ISBN 978-0-13-600391-5 |
Other Resources
Overview of Assessment
Assessment tasks will consist of a portfolio of in-class exercises, a project with associated documentation, and a combined theory and practical test.
You will be provided with feedback throughout the course to check your progress.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Assessment Tasks
Assessment 1 (Worksheets): 30%
The purpose of these worksheets (Teacher handouts in-class exercises) is to provide feedback to students from class exercises. Printouts submitted during class. In addition, Elements of the competency will be assessed through the class exercise worksheets.
Assessment 2 (Project) 40%
The purpose of this Project is to ensure that students are able to implement all the skills they have developed to date.
Firstly, students will be required to model a database using client specifications. Each student is expected to develop an individual design using VISIO. Design faults will be eliminated via several prototyping stages, using client feedback.
Sample data will then be loaded once the database design is implemented on a RDBMS platform, and queries will be created in SQL. Forms, reports and VBA modules will also be required. Basic security features and backup procedures will also be implemented.
Assessment 3 (TEST) 30%
Exam includes all the material covered all through the semester.
Assessment Matrix
ICAITAD139A - Design a Database | Assessment – 1 Worksheets (CA / NYC) & 30% |
Assessment – 2 Project (CA / NYC) & 40% |
Assessment – 3 TEST - 30% |
Determine database requirements | Yes | Yes | Yes |
Develop logical data model | Yes | Yes | Yes |
Design data structures | Yes | Yes | Yes |
Design queries, screens and reports | Yes | Yes | Yes |
Design access and security systems | Yes | Yes | Yes |
Confirm database design | Yes | Yes | Yes |
Other Information
Competency Requirements:
To be deemed competent students must demonstrate an understanding of all elements of this 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 work to their teacher to ensure that the relevant competency standards are being met.
All competency-based assessments for this course must be completed in order to achieve a CA (Competency Achieved) award.
Each assessment task will also carry a numerical weighting to be used for grading purposes. The grade applied will only be awarded if a CA has been achieved in all compulsory assessment tasks.
If a student has been assessed as 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, a maximum mark of 50% of the original weighting will be granted for that assessment.
Re-assessments will only be granted to students who were either unsuccessful in the first attempt, or have an approved application for special consideration.
A final TEST worth 30% will be offered to students who have achieved CA.
Course Overview: Access Course Overview