hiCl_Database_AE_Kn_2of4 Knowledge Assessment: Designing databases Criteria Unit code, name, and...

Question

hiCl_Database_AE_Kn_2of4 Knowledge Assessment: Designing databases Criteria Unit code, name, and release number ICTPRG402 Apply Query Language (Release 1) ICTDBS403 Create Basic Databases (Release 1) ICTSAD501 Model Data Objects (Release 1) Qualification/Course code, name, and release number ICT40518 Certificate IV in Programming (Release 1) ICT40118 Certificate IV in Information Technology (Release 1) **Amend the qualification box before distributing to the student. The information here should only contain the qualification the student is enrolled in** 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 acknowledgment 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 title	Version 1.0	Page 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_2of4		Page 11 of 11 Resource ID: TBS_19_013_Cl_Database_AE_Kn_2of4	STUDENT NAME:  Version:	20200212 Date created:	26 November 2018 Date modified:	08 December 2019 For queries, please contact: Technology and Business Services Skills Point Ultimo © 2020 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 are copyright © TAFE NSW 2020, and should not be reproduced without the permission of the TAFE NSW. Information contained in this document is correct at time of printing: 12 February 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 designing databases. 	Assessment Event number 	2 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. 	What do I need to provide? 	· USB drive or other storage method with enough free space to save work to. 	What will the assessor provide? 	· Access to the Learning Management System. 	Due date/time allowed 	Indicative time to complete assessment: · Three hours. 	Assessment location 	This assessment may be completed outside of the classroom. You may access your referenced text, learning notes and other resources. 	Supervision 	This is an unsupervised, take-home assessment. Your assessor may ask for additional evidence to verify the authenticity of your submission and confirm that the assessment task was completed by you. 	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 Answer Questions Outline three information-gathering methods that you could use when determining requirements for queries . 	Method 	Outline of method 	 	 	 	 	 	 Name and outline two common data analysis techniques. 	Analysis technique 	Outline of technique 	 	 	 	 Describe the processes of internal and external validation. 	Validation process  	Description 	Internal 	 	External 	 Describe the procedures that you would follow when validating data models. Describe best practice communication, and accessibility, for audiences with special needs. Briefly outline the steps involved in designing and modelling a database. Describe the function and two features each of the data-modelling techniques entity relationship diagram and crow’s foot diagram. 	Data modelling technique 	Function and features 	Description 	Entity relationship diagram 	Function 	 	 	Feature 1 	 	 	Feature 2 	 	Crow’s foot diagram 	Function 	 	 	Feature 1 	 	 	Feature 2 	 Identify and describe in full the five processes and rules for normalisation. 	Normalisation process 	Description 	Rules 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 Identify four common naming conventions appropriate to database design. Write a definition of what a database identifier is and explain how they impact database usability. Briefly describe regular and delimited identifiers. 	Identifier  	Description 	Regular 	 	Delimited 	 Describe the function and two features each of primary keys, foreign keys and unique keys. 	Key type 	Function and features 	Description of keys 	Primary key 	Function 	 	 	Feature 1 	 	 	Feature 2 	 	Foreign key 	Function 	 	 	Feature 1 	 	 	Feature 2 	 Describe the function and two features of time stamps when used with keys. 	Function and features 	Description of entity relationship model 	Function 	 	Feature 1 	 	Feature 2 	 Describe the function and two features of data types, including how they are used. 	Function and features 	Description of data types 	Function 	 	Feature 1 	 	Feature 2 	 Describe the function and two features of user-defined types, structured types and reference types. 	Data type 	Function and features 	Description of data type 	User-defined types 	Function 	 	 	Feature 1 	 	 	Feature 2 	 	Structured types 	Function 	 	 	Feature 1 	 	 	Feature 2 	 	Reference types 	Function 	 	 	Feature 1 	 	 	Feature 2 	 Describe the hierarchy of sub types, super types and root types and explain how the hierarchy is implemented when developing structured data types. Describe the function and two features of user-defined functions. 	Function and features 	Description of user-defined functions 	Function 	 	Feature 1 	 	Feature 2 	 Assessment Feedback NOTE: This section must have the assessor signature and student signature to complete the feedback. Assessment outcome ☐ Satisfactory ☐ Unsatisfactory Assessor feedback ☐ Has the Assessment Declaration been signed and dated by the student? ☐ Are you assured that the evidence presented for assessment is the student’s own work? ☐ Was the assessment event successfully completed? ☐ If no, was the resubmission/re-assessment successfully completed? ☐ 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 the assessment outcome Would you like to make any comments about this assessment? Student name, signature, and date NOTE: Make sure you have written your name at the bottom of each page of your submission before attaching the cover sheet and submitting to your assessor for marking.   65301 by 65301 65301 Submission date: 15-Sep-2020 10:14PM (UTC-0500) Submission ID: 1388252372 File name: assigmnet-u3tgbgsp.pdf (128.26K) Word count: 3904 Character count: 19720 61% SIMILARITY INDEX % INTERNET SOURCES % PUBLICATIONS % STUDENT PAPERS 1 17% 2 8% 3 4% 4 4% 5 3% 6 3% 7 2% 8 2% 9 2% 65301 ORIGINALITY REPORT PRIMARY SOURCES www.coursehero.com Internet Source pt.scribd.com Internet Source Submitted to Fiji National University Student Paper myassignmenttutor.com Internet Source gradesfixer.com Internet Source ocul.on.ca Internet Source www.mysqltutorial.org Internet Source www.red-gate.com Internet Source www.guru99.com Internet Source 10 2% 11 1% 12 1% 13 1% 14 1% 15 1% 16 1% 17 1% 18 1% 19 1% 20 1% 21 1% www.javatpoint.com Internet Source Submitted to Midlands State University Student Paper orkhanalyshov.com Internet Source www.w3resource.com Internet Source Submitted to Virginia International University Student Paper sheeba27.wordpress.com Internet Source dhimaninfotech1620.blogspot.com Internet Source docplayer.net Internet Source Submitted to University of Southern Queensland Student Paper sqlideablog.wordpress.com Internet Source tafenow.com.au Internet Source Submitted to Williams College Student Paper 22 1% 23 1% 24 1% 25 1% 26 1% 27 1% 28

Neha · Accepted Answer

cldatabaseaekn2of4-s1nfl0ll.docx
Part 1: Short Answer Questions
1. Outline three information-gathering methods that you could use when determining requirements for queries.
	Method
	Outline of method
	Interview
	The information gathering interview can be defined as a directed conversation which has a specific purpose and it uses a question and answer format. The interviews considered as a easy approach for data sharing and expressing needs effectively between the stockholders and the clients. The questions which are asked in the interview can be open Android or closed ended. 
	
Questionnaire
	A questionnaire can be defined a set of questions which I used to find out the information from large audience. this forward allows us to get more information from the clients in less time and at cheaper rates.
	
Document Analysis
	The document analysis is a technique which is used to analyse and gather the information from the current document. This technique is used by level we need to enhance or replace the existing system. The engineers need to have a lot of patience and time to read the document carefully and use all the important out of it. 
2. Name and outline two common data analysis techniques.
	Analysis technique
	
Outline of technique
	
Statistical Analysis
	In this method we used past data and analyse at to find out what happened. This method involves interpretation pharma analysis, presentation and data modelling. it allows us to analyse sample data on set of data. 
	
Predictive Analysis
	in this method we use data and try to make predictions to find out future outcomes. It uses past and current data to estimate the results. The accuracy is depended on the amount of detailed information we have or how much we can dig into it.
3. Describe the processes of internal and external validation.
	Validation process
	
Description
	
Internal
	The internal validation can be defined as checking that date values about and entity whether they are in correct sequence or not which means that we cannot finish a project before starting it. 
	
External
	External validation is used to check a date against the real world. Company does not start before any particular date then we cannot have any company information before that date.
4. Describe the procedures that you would follow when validating data models.
In this model the developer will have continuous interaction with the client and everything is discussed with the system expert during the design process. The system experts will supervise the output and will try to determine the relation between the simulation output and the real system output. We can use statistically method to compare the output with the real system.
5. Describe best practice communication, and accessibility, for audiences with special needs.
When the audience has accessible communication that it allows them to get clear, direct and easy information for their understanding. It allows to remove different barriers which can create issues to access information and helps them to get opportunities to share their feedback.
6. Briefly outline the steps involved in designing and modelling a database.
The first step is to find out the purpose to design a new database. Once the purpose is defined then we can collect different types of information which we want to store in the database. All the information is divided into different entities and these entities becomes the table of the database the information about the item will be stored as the columns into the tables. 
Each table will have a primary key for unique identification, and it will allow us to identify each row uniquely. The next step is to set up the relationship between the different tables and refined the design. At last data normalization rules are applied to make sure that tables have a correct structure. 
7. Describe the function and two features each of the data-modelling techniques entity relationship diagram and crow’s foot diagram.
	Data modellin g techniqu e
	
Function and features
	
Description
	
Entity relationship diagram
	
Function
	The entity relationship diagram allows us to present the logical structure of the database using a pictorial representation. 
It allows us to draw design of the database and also help us to understand the connection between different entities.

Cl_Database_AE_Kn_2of4 Knowledge Assessment: Designing databases Criteria Unit code, name, and release number ICTPRG402 Apply Query Language (Release 1) ICTDBS403 Create Basic Databases (Release 1)...

Answer To: Cl_Database_AE_Kn_2of4 Knowledge Assessment: Designing databases Criteria Unit code, name, and...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment