ok
Cl_Database_AE_Kn_4of4 Knowledge Assessment: Developing databases Criteria Unit code, name and release number ICTPRG402 Apply Query Language (Release 1) ICTDBS403 Create Basic Databases (Release 1) Qualification/Course code, name and release number ICT40118 Certificate IV in Information Technology (Release 1) Student details Student number Student name Assessment Declaration This assessment is my original work and no part of it has been copied from any other source except where due acknowledgement is made. No part of this assessment has been written for me by any other person except where such collaboration has been authorised by the assessor concerned. I understand that plagiarism is the presentation of the work, idea or creation of another person as though it is your own. Plagiarism occurs when the origin of the material used is not appropriately cited. No part of this assessment is plagiarised. Student signature and Date Document titleVersion 1.0Page 1 of 3 Disclaimer: Printed copies of this document are regarded as uncontrolled. Please check to ensure this is the latest version. © 2011 Department of Education and Communities, TAFE NSW eLearning Hub | Version: 0.0 | Created: dd/mm/2011 Document title: Cl_Database_AE_Kn_4of4Page 5 of 9 Resource ID: TBS_19_013_Cl_Database_AE_Kn_4of4STUDENT NAME: Version:1.0 Date created:26 November 2018 Date modified:08 December 2019 For queries, please contact: Technology and Business Services Skills Point Ultimo © 2019 TAFE NSW, Sydney RTO Provider Number 90003 | CRICOS Provider Code: 00591E This assessment can be found in the: Learning Bank The contents in this document is copyright © TAFE NSW 2019, and should not be reproduced without the permission of the TAFE NSW. Information contained in this document is correct at time of printing: 3 December 2020. For current information please refer to our website or your teacher as appropriate. Assessment instructions Table 1 Assessment instructions Assessment details Instructions Assessment overview The objective of this assessment is to assess your knowledge of developing databases. Assessment Event number 4 of 4 Instructions for this assessment This is a written assessment and it will be assessing you on your knowledge of the units. This assessment is in one part: 1. Short answer questions The assessment also contains: · Assessment Feedback. Submission instructions On completion of this assessment, you are required to upload it or hand it to your assessor for marking. Ensure you have written your name at the bottom of each page of this assessment. Submit the following documents for each part: · Part 1: Short answers · This assessment paper. 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 all questions must be answered correctly. Assessment conditions Assessment conditions will be safe and replicate the workplace, where the conditions are typical of those in the systems analysis and design field of work, including noise levels, production flow, interruptions and time variances. Assessment may be undertaken in normal classroom conditions, which is assumed to be noisy and similar to workplace conditions, or within the workplace. This may include phones ringing, people talking and other interruptions. What do I need to provide? · A pen, if a paper version of assessment is provided · USB drive or other storage method with enough free space to save work to. What will the assessor provide? · Equipment, materials and industry software packages · The internet and web browser software Due date/time allowed Indicative time to complete assessment: · One and a half hours. Assessment location This assessment will take place in the classroom. You may access your referenced text, learning notes and other resources. Supervision This is a supervised, in-class assessment. Reasonable adjustment If you have a permanent or temporary condition that may prevent you from successfully completing the assessment event(s) in the way described, you should talk to your assessor about ‘reasonable adjustment’. This is the adjustment of the way you are assessed to take into account your condition, which must be approved BEFORE you attempt the assessment. Assessment feedback, review or appeals 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 or Head Teacher. If they are unavailable, contact the Student Administration Officer. Contact your Head Teacher for the assessment appeals procedures at your college/campus. Part 1: Short answers Read the questions carefully. Each answer should be 50-100 words. Briefly outline the steps involved in implementing a database (after designing and modelling the database). When implementing a model of a database you can use the crows foot diagram to develop any codes which can be used to implement the database. The database should be built which includes any columns tables and keys once this has been built you can populate the database once the database has been tested. List the processes used for creating entities and attributes, and in populating fields, using both software solutions and script-based input. Activity Processes using software solutions Processes using script-based input Creating entities When creating entities you can use the graphical user interface from database software to create any entities or tables Data Definition Language is a standard for commands that define the different structures in a database. DDL statements create, modify, and remove database objects such as tables, indexes, and users. Common DDL statements are CREATE, ALTER, and DROP. DDL will also allow you to write in a script which can be used to create entities in the database Creating attributes attributes can be created by using a Graphical user interface from database software DDL can be used to write the script which also add attributes such as columns when created it adds the columns name and its datatype into the database as well as primary and foreign keys Populating fields When populating fields the graphical user interface can be used to insert data which you can also use to import data into the database DML Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database. Write a brief definition of data mining. Data mining is the process used to extract usable data from a larger set of any raw data which can be used to identify any patterns and allows you business to see relationships in the data to help solve problems with data analysis. 1. Identify a type of data source and the query language that it can be used with. Outline the characteristics of the data source. Type of data source Query language Characteristics of data source Comma separated value CSV Any query language can be used · Contains only text · Separated by commas or a long text with strings and lines · Helps files to be easily transferred and transformed into other format which is needed · Information storage · Adding information to other applications · Records can be kept on separate lines · Fields which have commas are separated by double quotes Explain the features of an information system. An information system is an integrated set of components which is used for collecting, storing and processing data which is used for providing information, knowledge and digital data. This collection of data is managed by using software applications which can be used either from your browser, desktop applications and even tablet and mobile applications. When the data is entered into an information system it has to be entered in a way in which it can be managed and processed. When the data is processed it turns the data into information which is then output to the end users of the systems. This data is generated from different sources such as different departments within an organisation as well as other external sources. There are various functions of information systems like the collection of input data, storage, processing, and producing the output information. The functions also control the information flow as well as the feedback loop. The systems can be also open and closed systems. The most widely used method of processing stored data is through SQL . Identify typical systems and procedures (two of each) that could be used when working with information systems. Briefly explain how they would help when developing queries. System/ procedure How they would help when developing queries MySQL workbench MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. MySQL workbench has features which include a query builder so when you are writing or developing any query’s it allows you to identify all columns, primary keys, foreign keys and relationships Visual Studio Visual studio has an integrated development environment which has tools which are built in such as SQL server data tools which can be used to create databases in SQL server. Visual studio uses the mssql extension which allows you to see the queries which have been executed and has features such as IntelliSense which can be used to develop queries by helping you validate errors in any codes which have been written. Procedure Backup and security procedure A database backup creates a duplicate of the data that is in the database when the backup completes. Backups are usually scheduled at regular intervals. Restoring from a backup allows the recreation of potentially the entire database in the event of data loss. The restore process overwrites the existing database or creates the database if it does not exist Database security procedures Databases are run on computers, which are vulnerable to attack by viruses, spyware, hackers and disgruntled employees -It is crucial to maintain physical protection of the computers on which a database runs - IT personnel frequently protect database systems in locked rooms and with strong passwords to counter physical breaches -Encryption scrambles data stored in a database according to a set algorithm, which makes it very difficult for hackers to use it -Access control to a database system prevents unauthorized users from viewing data that they're not supposed to see Both the backup and security procedure would be important when developing queries as it prevents any data which has been created to ensure its protection Procedure Confirm requirements for query request And testing the database and any queries The procedure of confirming requirements for the query request would be used to write queries to take out data which can be used to create a report which can include details such as who is the target audience , any inputs and outputs which are required and also when it should be completed by. This procedure can ensure that any request for how the query will be created can gather the correct information needed. The procedure of testing