ICTDBS506 Design databases
- Subject Code :
ICTDBS506
- University :
TAFE NSW Exam Question Bank is not sponsored or endorsed by this college or university.
- Country :
Australia
Project assessment
Criteria
Unit code and name
ICTDBS506 Design databases (1)
Qualification/Course code and name
ICT50220 | Diploma of Information Technology
Student details
Student number
Student name
Assessment declaration
Note: If you are an online student, you will be required to complete this declaration on the TAFE NSW online learning platform when you upload your assessment.
This assessment is my original work and has not been:
- plagiarised or copied from any source without providing due acknowledgement.
- written for me by any other person except where such collaboration has been authorised by the Teacher/Assessor concerned.
Student signature and date
Version: 1.0
Date created: 4 November 2021
Date modified: 20/08/2022
For queries, please contact:
SkillsPoint: Nithin Boddu, Product Manager - ADAPT, Product Group
Contact Details: 02 9217 4768
Location: Parramatta
2021 TAFE NSW
RTO Provider Number 90003 | CRICOS Provider Code: 00591E
This assessment can be found in the: &in=P7ac4831b-430a-4b8d-8b56-f7b32ed5b9cf&q=&type=standard&sort=rank&dr=AFTER">Learning Bank
The contents in this document is copyright TAFE NSW 2021 and should not be reproduced without the permission of TAFE NSW. Information contained in this document is correct at the time of printing: 20 August 2022. For current information please refer to our website or your Teacher/Assessor as appropriate.
Assessment instructions
Table 1 Assessment instructions
Assessment details |
Instructions |
Assessment overview |
The objective of this assessment is to assess your knowledge and performance in undertaking the design of databases for a system or database development project. |
Assessment event number |
1 of 2 |
Instructions for this assessment |
This is a project-based assessment that assesses your knowledge and performance of the unit. |
Submission instructions |
On completion of this assessment, you are required to submit it to your Teacher/Assessor for marking. Where possible, submission and upload of all required assessment files should be via the TAFE NSW online learning platform. Ensure you have included your name at the bottom of each page of documents you submit. It is important that you keep a copy of all electronic and hardcopy assessments submitted to TAFE and complete the assessment declaration when submitting the assessment. |
What do I need to do to achieve a satisfactory result? |
To achieve a satisfactory result for this assessment you must answer all the questions correctly. If a resit is required to achieve a satisfactory result it will be conducted at an agreed time after a suitable revision period. |
What do I need to provide? |
TAFE NSW student account username and password. If you do not know your username and password, contact your campus or service centre on 131601. Computer or other device with word processing software and internet access Writing materials, if required. |
What the Teacher/Assessor will provide |
Access to this assessment and learning resources, including the student workbook and any supporting documents or links. Organisational documentation, policies, and procedures Case studies |
Due date Time allowed Location |
Indicative time to complete assessment: In class: One hour Out of class: Five hours. |
Assessment feedback, review or appeals |
Part of this is an unsupervised, take-home assessment. Your Teacher/Assessor may ask for additional evidence to verify the authenticity of your submission and confirm that the assessment task was completed by you. You may access your referenced text, learning notes and other resources. |
|
In accordance with the TAFE NSW policy Manage Assessment Appeals, all students have the right to appeal an assessment decision in relation to how the assessment was conducted and the outcome of the assessment. Appeals must be lodged within 14 working days of the formal notification of the result of the assessment. If you would like to request a review of your results or if you have any concerns about your results, contact your Teacher/Assessor or Head Teacher. If they are unavailable, contact the Student Administration Officer. Contact your Head Teacher/Assessor for the assessment appeals procedures at your college/campus. |
Specific task instructions
The instructions and the criteria in the tasks and activities will be used by your Teacher/Assessor to determine if you have satisfactorily completed this assessment event. Use these instructions as a guide to ensure you demonstrate the required knowledge and skills.
You may have the option to record your participation and submit as video evidence. If you are submitting video evidence, you must:
- Provide a video clearly meeting all requirements listed below and in the Observation Checklist
- Ensure you have access to the equipment and resources required to participate in the demonstration
- Follow the Video recording instructions (pdf) (Long URL: https://share.tafensw.edu.au/share/items/744af7d4-a241-45e2-adb0-0e13f2fe4950/0/?attachment.uuid=01c3c87a-4599-48c2-91f0-68a00b5bbb4c) which includes useful tips, links to resources and a demonstration video.
Scenario
You will Anthonys Fast food restaurant as your project scenario. Please refer to Anthonys Vision to get a background to the company and to understand their strategic directions. This will enable you to build a system which is in line with their goals and direction.
Tasks
You will work on the design of a database for your project. This is an individual assessment, you may work on different parts of the system, but you need to submit your own individual work.
Complete the following artefacts:
- Create the conceptual model of the database using UML domain model notation.
- Convert/create the conceptual ER model using crows feet notation.
- Create the Logical database schema, with the following annotations
- Default value, range control, null value control, referential integrity
2. Example:
Staff(staffNo,lastName,branchNo)
primary key staffNo NOT NULL (obviously UNIQUE)
foreign key branchNo, references Branch(branchNo)
branchNo NOT NULL
Branch(branchNo,address,managerId, state)
primary key branchNo NOT NULL
foreign key managerId references Staff(staffNo)
state DEFAULT NSW
CONSTRAINT (0 < managerID state=QLD)>
- Data dictionary
- Use data dictionary template
- Normalization (include this as an appendix in your Design Report)
- Exercise 1
2. Exercise 2
- Physical design, consisting of:
- Composite usage map (data volume and usage analysis)
2. 1 example of denormalization with justification
3. 1 example of horizontal partitioning for one table with justification
4. 1 example of vertical partitioning for one table with justification
5. 1 example of an index for one table with justification
You will be taught each technique/modelling tool. You then need to apply it to your part of the system to design the database. Submit your work, and the Instructors will give you feedback. You will correct any omissions or errors and re-submit your work. If they are satisfactory, the Instructor will sign off on the observation sheet.
All the above artefacts will ultimately be part of your Design Report (Assessment Event 2 of 2). Refer to the template for content requirements. If it is satisfactory, the Instructor will sign off on the Feedback sheet.
You need to gain a satisfactory mark in both assessment events to achieve a Competent grade in this phase.
Assessment feedback
NOTE: This section must have the Teacher/Assessor and student signature to complete the feedback. If you are submitting through the TAFE NSW online learning platform, your Teacher/Assessor will give you feedback via the platform.
Assessment outcome
Satisfactory
Unsatisfactory
Assessor feedback
Has the assessment declaration for this assessment event been signed and dated by the student?
Are you assured that the evidence presented for assessment is the students own work?
Was reasonable adjustment in place for this assessment event?
If yes, ensure it is detailed on the assessment document.
Comments:
Assessor name, signature and date
Student acknowledgement of assessment outcome
Would you like to make any comments about this assessment?
