Course Title: Design a database
Part B: Course Detail
Teaching Period: Term2 2009
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:firstname.lastname@example.org
Name and Contact Details of All Other Relevant Staff
Catherine Han Lin
BTS (ICT) Teacher
Building 108-level 14
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
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
Determine database requirements
1.1 Meet with client and conduct a user needs analysis to determine database functionality
2.1 Identify attributes and determine data types
3.1 Confirm primary and foreign keys for tables
4.1 Design user interface for database, including menus, input screens and outputs
6.1 Identify database back up and recovery requirements
Details of Learning Activities
Theory presentations, practical lab classes, tutorial sessions plus out-of-class research and homework
Refer to the Study Guide Class handout for detailed weekly breakdown
Jeffrey A. Hoffer, Prescott & Topi, Modern Database Management 9/E , Prentice Hall, ISBN 978-0-13-600391-5
Peter Rob & Carlos Coronel, Database Systems: Design, Implementation & Management, 5th Edition, Course Technology, ISBN 0-619-06269-X
David M. Kroenke, Database Processing: Fundamentals, Design & Implementation, 9th Edition. Prentice Hall, ISBN 0-13-120971-X
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 1 (Worksheets): 10%
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, Element 3, Element 4, Element 5 and Element 6 of the competency will be assessed through the class exercise worksheets.
Assessment 2 (Test): 35%
The purpose of the test is to ensure that the students have understood the basic concepts of design including Determinant – Dependencies, Data Redundancy, Normalisation, BR and ERD.
Assessment 3 (Project) 30%
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 4 (Exam) 25%
Exam includes all the material covered all through the semester.
|ICAITAD139A - Design a Database||
Assessment – 1 Worksheets
Assessment – 2 Test
Assessment – 3 Project
|Assessment – 4
Exam - 25%
|Element 1 ||No||Yes||Yes||Yes|
Assessment methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks.
To be deemed competent students must demonstrate an understanding of all elements of a competency including employability skills.
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.
Students must achieve competency (CA) in each competency based assessment task.
Each assessment task will also carry a numerical weighting to be used for grading purposes to reflect participation, quality and professionalism.
A student’s final grade will be the total of their accumulated marks across all assessment tasks.
Course Overview: Access Course Overview