AUR30405 Certificate III in Automotive Mechanical Technology ICTDBS502 – Student Assessment 1 Version 1.0 – April 2019 Southern Cross Education Institute ICTDBS502 Design a database ICT50118 Diploma...

file attached


AUR30405 Certificate III in Automotive Mechanical Technology ICTDBS502 – Student Assessment 1 Version 1.0 – April 2019 Southern Cross Education Institute ICTDBS502 Design a database ICT50118 Diploma of Information Technology Record of Assessment Outcome Student name: Student ID: Summary of evidence gathering techniques used for this assessment: O Questioning O Project O Scenario The evidence presented is: O Valid O Sufficient O Authentic O Current Unit result: Competent O Not Competent O The student has been provided with feedback and informed of the assessment result and the reason for the decision. Assessor name: Date assessed: Assessor signature: RTO contact [email protected] Student declaration on assessment outcome I have been provided with feedback on the evidence I have provided. I have been informed of the assessment result and the reason for the decision. Student name: Date: Student signature: Student Assessment ICTDBS502 – Student Assessment 2 Version 1.0 – April 2019 Southern Cross Education Institute Reasonable Adjustment Was reasonable adjustment applied to any of the assessment tasks? (please tick) Yes O No O If yes, tick which assessment task(s) it was applied to. O Questioning O Project O Scenario Provide a description of the adjustment applied and why it was applied. Name of assessor: Assessor signature: Name of student: Student signature: Student Declaration Plagiarism constitutes extremely serious academic misconduct and severe penalties are associated with it. By signing below, you are declaring that the attached work is entirely your own (or where submitted to meet the requirements of an approved group assessment, is the work of the group). I certify that  I have read and understood the Southern Cross Education Institute’s PP77 Assessment and submission policy and procedures.  This assessment is all my own work, and no part of this assessment has been copied from another person.  I have not allowed my work to be copied by another person.  I have a copy of this work and will be able to reproduce within 24 hours if requested. I give my consent for Southern Cross Education Institute to examine my work electronically by relevant plagiarism software programs. Student signature: .......................................................... Date: ......../........../................ ICTDBS502 – Student Assessment 3 Version 1.0 – April 2019 Southern Cross Education Institute Assessment Outcome Summary and Feedback Assessment Task 1 – Questioning Submission No. Result Date Assessed Assessor Name Assessor Signature O First submission O S O NS O Re-submission 1 O S O NS O Re-submission 2 O S O NS S = Satisfactory NS = Not Satisfactory Feedback to the Student: Assessment Task 2 – Project Submission No. Result Date Assessed Assessor Name Assessor Signature O First submission O S O NS O Re-submission 1 O S O NS O Re-submission 2 O S O NS S = Satisfactory NS = Not Satisfactory Feedback to the Student: ICTDBS502 – Student Assessment 4 Version 1.0 – April 2019 Southern Cross Education Institute Assessment Task 2 – Scenario Submission No. Result Date Assessed Assessor Name Assessor Signature O First submission O S O NS O Re-submission 1 O S O NS O Re-submission 2 O S O NS S = Satisfactory NS = Not Satisfactory Feedback to the Student: ICTDBS502 – Student Assessment 5 Version 1.0 – April 2019 Southern Cross Education Institute Student Instructions This unit describes the performance outcomes, skills and knowledge required to build and implement a database using an established design. To achieve competence the following assessment tasks must be successfully completed in the time allocated with the essential resources. Your trainer/assessor will give you the due date to submit the assessments and provide you with feedback after assessing your work. Refer to the table below for the summary of Assessment Task for this unit: Assessment Task Number Assessment Type Notes 1 Questioning To be completed in own time and submitted to the assessor by the due date 2 Project This assessment task will be completed in part in own time and under direct observation by the trainer/assessor in the classroom. 3 Scenario This assessment task will be completed in part in own time and under direct observation by the trainer/assessor in the classroom.  Students may need to spend some hours outside the class hours without supervision to complete the assessments  All assessment tasks must be satisfactory to achieve competency in the unit  All the units of competency must be deemed competent to complete the qualification and obtain a certificate  The assessment requirement for this unit are presented clearly in the Unit of Competency located at: (http://training.gov.au/Training/Details/ICTDBS502)  In the Student assessment, you must be able to: o Answer all questions o Complete all assessment tasks within the required timeframe o Complete all skills assessments tasks to a satisfactory standard  The following resources are required for this assessment: o Computer with internet access o Word processing and database software o CASE or diagramming software Reasonable adjustment For information on reasonable adjustment please refer to the student handbook located at: http://scei.edu.au/?page_id=45 Record of Assessment Outcome After all of the assessment evidence has been gathered from the assessment tasks for this unit/cluster of units of competency the Record of Assessment stating your result will be completed. Information for the Student If you do not understand any part of the unit or the assessments you are required to undertake, please talk with your trainer/assessor. It is important that you understand all of the aspects of the learning and assessment process that you will be undertaking. This will make it easier for you to learn and be successful in your studies. http://scei.edu.au/?page_id=45 ICTDBS502 – Student Assessment 6 Version 1.0 – April 2019 Southern Cross Education Institute Assessment Task No 1 – Questioning Instructions for completion  You are required to answer all questions in Assessment Task 1 – Questioning  Responses to the questions may be typed or hand written  If hand written, writing must be legible and in pen NOT pencil  Use of correct grammar and spelling is required to demonstrate foundational skills  You must answer ALL questions in your own words or use appropriate referencing  Use of APA referencing must be used where original sources other than your own have been used – to avoid plagiarism  Write your name, student ID, the assessment task and the name of the unit of competency on each piece of paper you attach to this assessment document  You answer all questions correctly to achieve a satisfactory result  Submit to your trainer/assessor by the due date DUE DATE The trainer/assessor will inform you of the due date The due date for this task is _____________________________ 1. What is a conceptual model and what are its features? 2. What does logical data model consist of? In your answer include the following: a. Identify the entities b. Identify the attributes and data type for each entity c. Identify the relationship between the entities d. Normalise the attributes 3. Using diagrams and examples to support your answers, define the following: a. Primary key b. Foreign key c. Unique constraints d. CHECK constraints e. Referential integrity constraints f. Database index g. Data dictionary 4. What does a physical data model consist of? In your answer include the following a. Assign the primary key and foreign keys to table b. Refer to client’s business rules and identify the referential integrity constrains ( given an example) c. Add validation rules to database or tables 5. Explain data redundancy and provide two (2) examples of when used. 6. What is object model design concept? In your answer include the following: a. Data structures b. Queries c. Screens d. Reports ICTDBS502 – Student Assessment 7 Version 1.0 – April 2019 Southern Cross Education Institute 7. What are the steps involved in designing the user interface? You answer should include the following: a. Type of interface b. Fundamental parts of a user interface c. User interface controls 8. Explain the following a. What is SQL? b. What can SQL do? c. What is