This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements.
It applies to individuals employed as database administrators and designers who are required to design databases.
No licensing, legislative or certification requirements apply to this unit at the time of publication.
You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)
Evidence Required
List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
ELEMENT
PERFORMANCE CRITERIA
Elements describe the essential outcomes.
Performance criteria describe the performance needed to demonstrate achievement of the element.
1. Determine database requirements
1.1 Meet with the client, and conduct a user-needs analysis, to determine database functionality
1.2 Analyse the results of a user-needs analysis to identify technical requirements
1.3 Develop a conceptual model of the database
1.4 Submit the conceptual model to the client for review
1.5 Evaluate client feedback and make changes as required
2. Develop a logical data model
2.1 Identify the attributes and determine the data types
2.2 Undertake the normalisation of attributes
2.3 Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships
2.4 Document attributes, normalised data, and the ER diagram
2.5 Forward documentation to the client for confirmation
3. Design the data structures
3.1 Confirm primary and foreign keys for tables
3.2 Review client business rules
3.3 Identify the referential integrity constraints
3.4 Establish database management system constraints and incorporate into database design
3.5 Develop the validation rules for data
3.6 Design indexes and develop the data dictionary
3.7 Document the database design
4. Design queries, screens and reports
4.1 Design the user interface for database, including menus, input screens and outputs
4.2 Design queries, based on requirements
4.3 Design output reports, based on requirements
4.4 Compare the physical design with the conceptual model, or user-needs analysis
4.5 Incorporate changes as required
5. Design access and security systems
5.1 Review the business security plan as a basis for commencing the access and security design
5.2 Design the password and access system for the database
5.3 Identify multiple-user requirements
5.4 Develop client access profiles using the client business model
6. Confirm the database design
6.1 Identify the database backup and recovery requirements
6.2 Develop and document the database backup and restore procedures
6.3 Submit the database, and documentation, to the client for final approval
Submission Requirements
List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here
Assessment task 1: [title] Due date:
(add new lines for each of the assessment tasks)
Assessment Tasks
Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.
ELEMENT
PERFORMANCE CRITERIA
Elements describe the essential outcomes.
Performance criteria describe the performance needed to demonstrate achievement of the element.
1. Determine database requirements
1.1 Meet with the client, and conduct a user-needs analysis, to determine database functionality
1.2 Analyse the results of a user-needs analysis to identify technical requirements
1.3 Develop a conceptual model of the database
1.4 Submit the conceptual model to the client for review
1.5 Evaluate client feedback and make changes as required
2. Develop a logical data model
2.1 Identify the attributes and determine the data types
2.2 Undertake the normalisation of attributes
2.3 Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships
2.4 Document attributes, normalised data, and the ER diagram
2.5 Forward documentation to the client for confirmation
3. Design the data structures
3.1 Confirm primary and foreign keys for tables
3.2 Review client business rules
3.3 Identify the referential integrity constraints
3.4 Establish database management system constraints and incorporate into database design
3.5 Develop the validation rules for data
3.6 Design indexes and develop the data dictionary
3.7 Document the database design
4. Design queries, screens and reports
4.1 Design the user interface for database, including menus, input screens and outputs
4.2 Design queries, based on requirements
4.3 Design output reports, based on requirements
4.4 Compare the physical design with the conceptual model, or user-needs analysis
4.5 Incorporate changes as required
5. Design access and security systems
5.1 Review the business security plan as a basis for commencing the access and security design
5.2 Design the password and access system for the database
5.3 Identify multiple-user requirements
5.4 Develop client access profiles using the client business model
6. Confirm the database design
6.1 Identify the database backup and recovery requirements
6.2 Develop and document the database backup and restore procedures
6.3 Submit the database, and documentation, to the client for final approval
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.
Observation Checklist
Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice
Yes
No
Comments/feedback
Meet with the client, and conduct a user-needs analysis, to determine database functionality
Analyse the results of a user-needs analysis to identify technical requirements
Develop a conceptual model of the database
Submit the conceptual model to the client for review
Evaluate client feedback and make changes as required
Identify the attributes and determine the data types
Undertake the normalisation of attributes
Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships
Document attributes, normalised data, and the ER diagram
Forward documentation to the client for confirmation
Confirm primary and foreign keys for tables
Review client business rules
Identify the referential integrity constraints
Establish database management system constraints and incorporate into database design
Develop the validation rules for data
Design indexes and develop the data dictionary
Document the database design
Design the user interface for database, including menus, input screens and outputs
Design queries, based on requirements
Design output reports, based on requirements
Compare the physical design with the conceptual model, or user-needs analysis
Incorporate changes as required
Review the business security plan as a basis for commencing the access and security design
Design the password and access system for the database
Identify multiple-user requirements
Develop client access profiles using the client business model
Identify the database backup and recovery requirements
Develop and document the database backup and restore procedures
Submit the database, and documentation, to the client for final approval
Forms
Assessment Cover Sheet
ICTDBS502 - Design a database
Assessment task 1: [title]
Student name:
Student ID:
I declare that the assessment tasks submitted for this unit are my own work.
Student signature:
Result: Competent Not yet competent
Feedback to student
Assessor name:
Signature:
Date:
Assessment Record Sheet
ICTDBS502 - Design a database
Student name:
Student ID:
Assessment task 1: [title] Result: Competent Not yet competent
(add lines for each task)
Feedback to student:
Overall assessment result: Competent Not yet competent