no referencing needed at all. will be okay if copy and pasted but need the assignment done
ICTDBS503 Create a Data Warehouse ASSESSMENT TASK 2 Knowledge Questions ICT50120 Diploma of Information Technology ASSESSMENT TASK 2 COVER SHEET Please ensure this form is fully completed prior to submitting. This page MUST be on the front of your assessment and needs to be easily accessible, filled in and signed. Student Number: Student Name: Subject: ICTDBS503 Create a Data Warehouse Course: ICT50120 Diploma of Information Technology STUDENT DECLARATION I hereby certify that: 1. This assessment task is my own work based on my personal study/research and not the work of another student and/or source. 2. I have acknowledged all material and sources used to prepare this assessment task. 3. I have not plagiarised or copied any part of this assessment task from the work of any other student or source either. (I know the penalties for plagiarism include $200 re-assessment fee) 4. This assessment task has not previously been submitted. 5. I am aware of the requirements set by my Trainer & Assessor. 6. I have retained a copy of this assessment task for my own records. 7. I have completed all my assessments, tasks & activities (on Moodle®) successfully. Student’s Signature: _______________________________ Date: _________________ Wentworth Institute RTO Code: 91178 November 2017 Version: 1.0 Student instructions This Assessment is designed to test the knowledge that you have acquired throughout the unit so far. Use the following tips to help you answer the questions: Read each question carefully. Check with your trainer or assessor if you are not sure what the question is asking. HINT: Use these questions as subheadings to create a business style report to answer your assessment Your response to each question should aim to provide enough information to answer the question. In most cases, this can be done with just a few paragraphs. Do not forget to refer to attachments under the heading (question) applicable, e.g. ‘See attached email’. Important: Your assessment must contain this coversheet and your own coversheet (for your “report”) Your answers & assessment submission must be professional in style (Business), content and format. Maximum font size 11 points: Font Arial or Times New Roman; single spacing; clear paragraphs with appropriate punctuation, spellchecking and final submission will need to be proof-read. (i.e., few missing words or typo’s) In particular: - Use clear, non-discriminatory language - Avoid the use of jargon - Write clearly using plain English - Consider your target audience - Ensure that your responses meet the needs of the target audience (in this case your trainer or assessor). All of your work must be original. Performance Evidence Evidence of the ability to: · prepare the specifications for a data warehouse, from a range of organisational information · design a data warehouse system that reflects the current, and future, business specifications, and also the business’s knowledge management strategy · test the data warehouse system · implement the data warehouse design. Note: If a specific volume or frequency is not stated, then evidence must be provided at least once. Knowledge Evidence To complete the unit requirements safely and effectively, the individual must: · explain the functions and features of: · data warehousing and data mining · dimension tables and fact tables · various steps and processes, including transformer steps, program steps, structured query language (SQL) steps, and user-defined program steps · subject areas, warehouse sources and warehouse targets · warehouse agents and agent sites · outline the business operating systems related to the data sources · describe the decision support systems related to the knowledge management strategies · define the parameters for a security plan · outline the system’s configuration parameters · describe the key features of “Big Data” including: · data access speeds and processing · the information handled by large corporations · distribution, via the cloud, across the database servers. Assessment Conditions Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to: · equipment and materials · industry software packages · the business requirements · computers configurable as information servers · the enterprise’s knowledge management strategy · internet connectivity tools · the local area network (LAN), with a relational database management system (DBMS) · proxy server software · specialised internet security software. · Assessors must satisfy NVR/AQTF assessor requirements. To achieve competency for this unit: · All assessment activities in this unit must be successfully completed. · The student must achieve a SATISFACTORY result in all the assessment activities in this unit to be deemed COMPENTENT. · Students must perform to the standard as expressed by the competency standards of the ICT Training Package. Reasonable Adjustment: · Reasonable adjustment is any approved modification or allowance made in assessment to accommodate a disability related function. Reasonable adjustment allows a learner with a disability to participate equitably in assessment procedures and demonstrate required skills and knowledge. Adjustment could be made in the physical environment, the assessment strategies or using assistive technology. Any adjustments made to the assessment must preserve the integrity of the assessment outcome. Marking and Criteria guide: Assessor and student must read this carefully before assessment. · All parts of the assessment must be completed successfully in accordance with the guidance provided in the Marking guide for the student to achieve competence in this unit. · Students & assessors must note that professionally critical aspects/concepts must be included (e.g., obtain knowledge of data warehouse). · All parts (criteria) in the marking guide must be completed successfully for the student to achieve competence in this unit. EDUCATOR to complete. Observation/assessment Satisfactory/not Satisfactory Comments All assessments, tasks & activities (on Moodle®) successfully Add Scale Task 2: Knowledge Questions 1. The student has discussed the modelling rules and conventions with reference to naming processes and events - no less than word count of 50 words Add Scale 2. The student has outlined the features and functions of process mappers - no less than word count of 50 words Add Scale 3. The student has explained the features of data analysis, particularly in determining process flows - no less than word count of 50 words Add Scale Practical Checklist Assessor to complete: (circle) Did you observe the student? Choose an item. Further comments required: Assessment Result SATISFACTORY |_| NOT SATISFACTORY |_| Resubmission Required NO |_| YES |_| Assessor’s Feedback Date resubmission must be handed in: ……………………………………. Assessor’s name and signature: ………………………………………………. Date: ……………… Learner’s Feedback Learner’s name and signature: ………………………………………………. Date: ……………… Case Study Scenario SimpleTec is a tech company that was established in 2006 by founder George Cain. The company are the leaders and distributors in technical parts for computers and other spare parts Australia Wide. They started off with just a small store in Sydney NSW and as time passed, they flourished and now distribute to a variety of stores like Big Lee, JB Hifi, Scorptec, Mwave to name a few. They have become so large and work mainly via cloud-based architecture that they have decided they need a content management system (Data Warehouse) to help with the demand of their sales and other requirements their business needs. The decision to change to a data warehouse was subjected to the fact that the current database can’t handle the workload of the data that is currently being used across multiple networks and is slow. After careful consideration, SimpleTec has decided to review the opportunity to migrate their current infrastructure to a data warehouse. Task 2: Knowledge Questions 1. Identify; a. The organisational data, according to the enterprise’s knowledge management strategy b. the subject areas, according to the business processes and the required enterprise data – the areas in question to be managed by the data warehouse 2. Explore the operational data and define the warehouse sources, record the outcomes Oracle has a service that you have to put in a credit card - it is a free service and doesn’t take money out of your account but has the ability for you to create a data warehouse. 3. Develop the warehouse source specifications, according to the existing data tables and files – Refer to point 2 above and the Tutorial When you create your account with Oracle, create an Autonomous Database (Data Warehouse) 4. Develop the warehouse targets, according to the business processes and the required enterprise data. 5. Identify the warehouse agents (Cloud Tier), according to the system’s configuration by creating the account with Oracle and the tutorial to create the database for the data warehouse. 6. Identify and develop, warehouse steps and processes – research on how to use the oracle data warehouse. 7. Create a database using an excel spreadsheet and add data to it. Alternatively, you can create your data model first and then create the spreadsheet using the same structure. Feedback Form Student Name Student #: Date: UOC Name: Create a Data Warehouse UOC Code: ICTDBS503 I have read the assessment instructions and know the observation criteria and I am ready to participate in the practical assessment Students Signature: _________________________________________________________________ Observation Satisfactory Not Satisfactory Did the candidate: Answered all the given questions |_| |_| Created an account with Oracle |_| |_| Determine the warehouse targets |_| |_| Identified the Warehouse Agents |_| |_| Identified and Developed Warehouse Steps and Processes |_| |_| Create database and excel spreadsheet with data. |_| |_| Satisfactory |_| Not Satisfactory |_| Educator Name and Signature: c:\users\valissam\downloads\onedrive_2021-05-16\create cloud computing services a1 v01_ 170521.docx e:\work\wentworth institute\training\dip of ict\2021\term 4\2. create data warehouse\assessments\ict50120\120 - create a data warehouse a2 v01_90721.docx Page 1 of 2 ICTDBS503 Create a Data Warehouse ASSESSMENT TASK 3 Implement Data Warehouse Data and Security ICT50120 Diploma of Information Technology ASSESSMENT TASK 3 COVER SHEET Please ensure this form is fully completed prior to submitting. This page MUST be on the front of your assessment and needs to be easily accessible, filled in and signed. Student Number: Student Name: Subject: ICTDBS503 Create a Data Warehouse Course: ICT50120 Diploma of Information Technology STUDENT DECLARATION I hereby certify that: 1. This assessment task is my own work based on my personal study/research and not the work of another student and/or source. 2. I have acknowledged all material and sources used to prepare this assessment task. 3. I have not plagiarised