No referencing needed
ICTDBS507 Integrate databases with a website ASSESSMENT TASK 1 Knowledge Questions ICT50220 Diploma of Information Technology ASSESSMENT TASK 1 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: WIN200253 Student Name: Sumit Bhattarai Course: ICT50220 Diploma of Information Technology Subject: ICTDBS507 Integrate Databases with Websites STUDENT DECLARATION I hereby certify that: · This assessment task is my own work based on my personal study/research and not the work of another student and/or source. · I have acknowledged all material and sources used to prepare this assessment task. · 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) · This assessment task has not previously been submitted. · I am aware of the requirements set by my Trainer & Assessor. · I have retained a copy of this assessment task for my own records. · I have completed all my assessments, tasks & activities (on Moodle®) successfully. Students Signature: Sumit Bhattarai Date: 05/04/2022 Wentworth Institute RTO Code: 91178 November 2017 Version: 1.0 Student instructions This assessment must be based on where you work (or have worked most recently). This Assessment is designed to test the knowledge that you have acquired throughout the unit. 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. Don’t 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 typos) In particular: · Use clear, non-discriminatory language · use business-like 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. Written answer question guidance · The following written questions use a range of “instructional words” such as “identify” or “explain”, which tell you how you should answer the question. Use the definitions below to assist you to provide the type of response expected. · Note that the following guidance is the minimum level of response required. Analyse: when a question asks you to analyse something, you should do so in detail, and identify important points and key features. Generally, you are expected to write a response one or two paragraphs long. Compare: when a question asks you to compare something, you will need to show how two or more things are similar, ensuring that you also indicate the relevance of the consequences. Generally, you are expected to write a response one or two paragraphs long. Contrast: when a question asks you to contrast something, you will need to show how two or more things are different, ensuring you indicate the relevance or the consequences. Generally, you are expected to write a response one or two paragraphs long. Describe: when a question asks you to describe something, you should state the most noticeable qualities or features. Generally, you are expected to write a response two or three sentences long. Discuss: when a question asks you to discuss something, you are required to point out important issues or features and express some form of critical judgement. Generally, you are expected to write a response one or two paragraphs long. Evaluate: when a question asks you to evaluate something, you should put forward arguments for and against something. Generally, you are expected to write a response one or two paragraphs long. Examine: when a question asks you to examine something, this is similar to “analyse”, where you should provide a detailed response with key points and features and provide critical analysis. Generally, you are expected to write a response one or two paragraphs long. Explain: when a question asks you to explain something, you should make clear how or why something happened or the way it is. Generally, you are expected to write a response two or three sentences long. Identify: when a question asks you to identify something, this means that you are asked to briefly describe the required information. Generally, you are expected to write a response two or three sentences long. List: when a question asks you to list something, this means that you are asked to briefly state information in a list format. Outline: when a question asks you to outline something, this means giving only the main points, Generally, you are expected to write a response a few sentences long. Summarise: when a question asks you to summarise something, this means (like “outline”) only giving the main points. Generally, you are expected to write a response a few sentences long. Performance Evidence Evidence of the ability to: · access database using a web development language · retrieve and display web-based data · update web-based data. 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: · describe a database structure · outline internet technology as it relates to the use of databases · identify and apply programming control structures, including object-oriented programming and structured query language (SQL) · authentication and web security · hypertext transfer protocol (HTTP) · session management · defining the principles of stateless programming stateless programming. 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 · industry software packages · the requirements documentation · a web server · a database · the web development environment · browsers. · Assessors must satisfy NVR/AQTF assessor requirements. 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., obtaining knowledge on how to Integrate a Databases with a Website). · All parts (criteria) in the marking guide must be completed successfully for the student to achieve competence in this unit. EDUCATOR to complete. Assessment Task 1 – Q & A Observation/Assessment Satisfactory / Not Satisfactory Comments 1. The student has listed at least four (4) different browsers that you might use to test a web application in. 50-250 words. NS Need to elaborate on the browsers and the testing. 2. The student has explained the different types of web programming concepts; · Hypertext Transfer Protocol (HTTP) · Stateless Programming · Session Management · Authentication and Web Security NS Sumit has explained the different types of web programming concepts for http, Stateless Programming, Session Management, This answers the question as to authentication but not web security. 3. Describe what is a database structure? - minimum of 75 words S Sumit has described what is a database structure 4. Describe why you would have to have an industry standard for database structures? - minimum of 50 words S Sumit has described why you would have to have an industry standard for database structures 5. What does SQL stand for? S Sumit has described what does SQL stand for 6. What does NoSQL stand for? S Sumit has described what does NoSQL stand for Assessment Task 1 – Q & A Observation/Assessment Satisfactory / Not Satisfactory Comments 7. Describe the database programming control structures for OOP and database interfaces for SQL S Sumit has described the database programming control structures 8. Describe the database programming control structures for OOP and database interfaces for NoSQL Programming Interface? S Sumit has described the database programming control structures for OOP and database interfaces for NoSQL Programming Interface? 9. Explain the different types of database programs available today. Which ones are the most popular and relevant to websites and/or applications? S Sumit has explained the different types of database programs available today. Which ones are the most popular and relevant to websites and/or applications? 10. Describe the internet/network technology that relates to the use of databases - minimum of 75 words NS This doesn't answer to the technology used to create and use a database. 11. What is a data dictionary and why would it be used? - minimum of 50 words S Sumit has described what is a data dictionary and why would it be used? - minimum of 50 words 12. What is an ERD Diagram and why would it be used? - minimum of 50 words S Sumit has described what is an ERD Diagram and why would it be used? - minimum of 50 words Assessor Declaration: First Attempt |X| Second Attempt ☐ Third Attempt ☐ Assessor name Valissa McBride Assessor signature Valissa McBride Date 3rd May 2022 Assessment outcome: SATISFACTORY ☐ NOT SATISFACTORY |X| Resubmission NO ☐ YES |X| Date Resubmission must be handled in by: 12th May 2022 Feedback: Sumit please refer to comments below and please resubmit. Student result response ☐ My performance in this assessment task has been discussed and explained to me.