Course Title: Build a database

Part B: Course Detail

Teaching Period: Term1 2011

Course Code: COSC5317C

Course Title: Build 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 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 build and implement a database using an established design.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAB4170A Build a database

Element:

1. Confirm database design

Performance Criteria:

1.1 Review database design documentation, including data structures, queries, reports and user interface
1.2 Compare database access and security feature design with organizational security plan
1.3 Document inconsistencies in database and security design

Element:

2. Create prototype

Performance Criteria:

2.1 Develop prototype according to database design
2.2 Populate database tables with suitable data, including current business data
2.3 Write conversion programs to import data from existing systems
2.4 Develop test data to assess database features
2.5 Assess functionality of prototype with client, including identifying errors in program code and modifying screens and reports
2.6 Incorporate feedback from client into prototype
2.7 Obtain client sign off for the prototype

Element:

3. Test database

Performance Criteria:

3.1 Develop implementation plan for the database
3.2 Install database management system software on network
3.3 Populate database tables with business data
3.4 Implement security and access controls
3.5 Test database output and security controls and record results

Element:

4. Evaluate database

Performance Criteria:

4.1 Review database with client for final approval
4.2 Complete database documentation
4.3 Identify and document user training requirements
4.4 Seek and secure client acceptance of database


Learning Outcomes



Details of Learning Activities

Theory sessions, practical lab sessions, tutorial sessions, assignments 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. The weekly breakdown is for the ICPT group ONLYICPT: Weekly Schedule - Semester 1 , 2011
Week beginningTopic/Learning ActivitiesAssessment TasksNational Codes
Week 1 – 7th FebCourse introduction & overview. Database concepts. Single table databases, Primary keys, Forms, Data StructuresTeacher handouts in-class exercises. Assessment -1ICAA5046B
ICAA5139A
ICAB4170A
Week 2 – 14th FebBusiness requirements. Intro to ERD’s. 1:M relationships & foreign keys. VBA basics. Teacher handouts in-class exercises. ICAA5046B
ICAA5139A
ICAB4170A
Week 3 – 21nd FebMore on ERD’s. M:N relationships & bridging tables, Binary & Ternary. VBA basics : LoopsTeacher handouts in-class exercises. Assessment -1ICAA5046B
ICAA5139A
ICAB4170A
Week 4 – 28th FebERD’s continued. VBA continued.Teacher handouts in-class exercises. Assessment -1. Project Posting.ICAA5046B
ICAA5139A
ICAB4170A
Week 5 – 7th MarchReferential integrity. Data entry for 1:M and M:N relationships, Business Rules. VBA Continued.Teacher handouts in-class exercises. ICAA5046B
ICAA5139A
ICAB4170A
Week 6 – 14th MarchBuilding up more complex ERD’s. Logical Database design. Teacher handouts in-class exercises. Assessment -1ICAA5046B
ICAA5139A
ICAB4170A
Week 7 – 21st MarchERD’s Continued. GUI components Teacher handouts in-class exercises. ICAA5046B
ICAA5139A
ICAB4170A
Week 8 – 28th MarchDeterminant & dependencies . GUI components continued. Teacher handouts in-class exercises. Assessment -1ICAA5046B
ICAA5139A
ICAB4170A
Week 9 – 4th AprilData Redundancy & Anomalies. Form and subform. Teacher handouts in-class exercises. Assessment -1ICAA5046B
ICAA5139A
ICAB4170A
Week 10 – 11th AprilSteps 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 AprilNormal 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
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 – 2nd MayIntro 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 MayTwo-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 MayRevision for final 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 : TESTICAA5046B
ICAA5139A
ICAB4170A
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

1. Jeffrey A. Hoffer, Prescott & Topi, Modern Database Management 9/E , Prentice Hall, ISBN 978-0-13-600391-5

2. Microsoft Office Access Help (Accompanying MS Access)


References

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

2. Smith & Sussman, Beginning Access 2000 VBA Wrox, ISBN 1-861001-76-2.


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 is to provide feedback to students from class exercises. Printouts are to be 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 build a database prototype using client specifications in MS Access / MS SQL Server / MySQL.
Test data will be loaded, and queries will be created in SQL. Forms, reports and VBA modules will also be required. Basic security features will be implemented.
Implementation plan will be developed, post implementation review is conducted, system documentation is written and user training requirements are identified.

Assessment 3 (TEST): 30%
A TEST which includes all the material covered all through the semester.


Assessment Matrix

ICAITB170A - Build a DatabaseAssessment – 1
Worksheets
CA / NYC &
30%
Assessment – 2 Project
CA / NYC & 40%
Assessment – 3 TEST
30%
Confirm database design             Yes                   Yes                     
Create prototype             Yes                   Yes                       Yes
Test database             Yes                   Yes                       Yes
Evaluate database            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 TESTworth 30% will be offered to students who have achieved CA.

Course Overview: Access Course Overview