澳洲論文代寫 > IT作業代寫 > > 正文

IT作業代寫

ICTDBS403 Create basic databases

Details of Assessment
Term and Year Term 3 2015 Time allowed -
Assessment No 2 of 2 Assessment Weighting 50%
Assessment Type Written Project and Practical
Due Date Week No. 8 Room  
 
Details of Subject
Qualification ICT40115 - Certificate IV in Information Technology
Subject Name Database Development
 
Details of Unit(s) of competency
Unit Code (s) and Names ICTDBS403 Create basic databases
ICTPRG402 Apply query language
 
Details of Student
Student Name  
College   Student ID  
Student Declaration:  I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. Signature: ___________________________
Date: _______/________/_______________
 
Details of Assessor
Assessor’s Name  
Assessment Outcome
Results  
 Competent        Not Yet Competent
   
Marks                         /50
         
 
FEEDBACK TO STUDENT
Progressive feedback to students, identifying gaps in competency and comments on positive improvements:
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
 
Student Declaration:  I declare that I have been assessed in this unit, and I have been advised of my result.  I am also aware of my right to appeal and the reassessment procedure.
 
Signature:   ____________________________
Date:          ____/_____/_____
Assessor Declaration:  I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback
 
 Student did not attend the feedback session.  
         Feedback provided on assessment.
 
Signature:    ____________________________
Date:           ____/_____/_____
 

 
Purpose of the assessment
The purpose of this assessment is to assess the student in the following outcomes: Competent
(C)
Not yet Competent
(NYC)
Performance Criteria : ICTDBS403 Create basic databases
1. Analyse the requirements for the database    
1.1 Determine the information that the database is required to hold    
1.2 Develop a written requirement report for the functionality of the database    
1.3 Complete the documentation, and submit it to the appropriate person for approval    
2. Use data modelling to design the database to suit requirements    
2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold    
2.2 Develop primary and foreign keys to link the entities    
2.3 Develop a data dictionary    
2.4 Complete the documentation, and submit it to the appropriate person for approval    
3. Create a database on a web or database server    
3.1 Use the appropriate language on a web or database server to create one or more databases    
3.2 Use the appropriate language on a web or database server to create tables    
3.3 Populate the database fields    
4. Test the database and debug    
4.1 Test the database on the web or database server    
4.2 Ensure that the information represented matches the requirements    
Performance Criteria : ICTPRG402 Apply query language
1. Determine the requirements of developing queries    
1.1 Recognise various query-related terminologies    
1.2 Identify the type of data source for a chosen query language    
1.3 Identify and use the necessary tools, and environment, in building queries    
2. Write queries to retrieve and sort values    
2.1 Use an expression to retrieve values from a single unit    
2.2 Use an expression to combine values from more than one unit    
2.3 Use an expression to sort values into a certain order    
3. Write queries to selectively retrieve values    
3.1 Use an expression to filter a sequence, based on a predicate or a condition    
3.2 Use an expression to filter the subset of a sequence, based on a predicate or a condition    
3.3 Use an expression to extract a specific value by position    
4. Perform a calculation in queries    
4.1 Use an expression to perform a calculation on numeric values    
4.2 Use an expression to perform an operation on text values    
4.3 Use an expression to perform an operation on date and time values    
Assessment/evidence gathering conditions
Each assessment component is recorded as either Competent (C) or Not Yet Competent (NYC). A student can only achieve competence when all assessment components listed under “Purpose of the assessment” section are recorded as competent. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYC (Not Yet Competent) is eligible for re-assessment.
Resources required for this assessment
  • Computer with relevant software applications and access to internet
  • Weekly eLearning notes relevant to the tasks/questions
Instructions for Students
Please read the following instructions carefully
·         This assessment has to be completed      In class    At home
·         The assessment is to be completed according to the instructions given by your assessor.
·         Feedback on each task will be provided to enable you to determine how your work could be improved. You will be provided with feedback on your work within two weeks of the assessment due date. All other feedback will be provided by the end of the term.
·         Should you not answer the questions correctly, you will be given feedback on the results and your gaps in knowledge. You will be given another opportunity to demonstrate your knowledge and skills to be deemed competent for this unit of competency.
·         If you are not sure about any aspect of this assessment, please ask for clarification from your assessor.
·         Please refer to the College re-assessment for more information (Student handbook).
 
ICTDBS403 Create basic databases 

 
Assessment marking and observation sheet for trainers
 
Part A: Question and Answers
Part B: Practical Exercise
 
 
Marking List Marks
Part A: Question and Answers – 10 Marks
Question 1 /1
Question 2 /1
Question 3 /1
Question 4 /1
Question 5 /1
Question 6 /1
Question 7 /4
Part B: Practical Exercise Documentation – 20 Marks
TASK 2  
Question A /4
Question B /1
Question C /1
TASK 2  
Question A /1
Question B /1
Question C /1
Question D /1
Question E /1
Question F /1
Question G /1
Question H /1
Question I /1
BONUS MARKS (for completing Task 1 and 2) /4
SUB TOTAL /30
Part B: Practical Exercise (Observation of Practical) – 20 Marks
SUB TOTAL /20
TOTAL /50
 

 
Assessment  - Written + Practical/Observation
 
Part A: Question and Answers (10%)
  1. SQL (1 marks)
     
  2. RDRMS (1 marks)
     
  3. What is MySQL? List at least 4 other type of database system. List 5 strength of MySQL. (1 marks)
     
  4. DML, DDL (1 marks)
     
  5. Using INSERT statement, explain table, row and column? (1 marks)
     
  6. In MySQL, using an example explaining the ER diagram, table, entity, relationship, foreign key. (1 marks)
     
  7. Using the screenshots and description explain the query development and testing environment. A. Development PHP/MySQL in Dreamweaver (Code interface showing a query, like insert) B. Publishing PHP file (In file manager). C. Database Interface (Showing the tables you created) (4 marks)
 

 
Part B: Practical Exercise / Evidence (20%)

Based on the class exercises and tutorials do the following practical. Assessment II resource material zip file should also be downloaded from eLearning.

Task 1: (Total 6 Marks)
A.   CREATE TABLES: students, subjects (presume each subject can be studied by many students). Ensure use of primary and foreign key that are underlined below.
Table students (stuid, stuname, gender, age, email, mobile, sbjid, enroltimestamp)
Table subjects (sbjid, sbjname, sbjcode, sbjdescription )
(4 marks).
 
B.   INSERT: You will need 15 students in the table, 3 subjects in the subjects table.
(1 Mark).
 
C.   Use your SQL Server to capture data dictionary of above tables.
(1 Mark).
 
Task 2: (Total 10 Marks)
  1. ER diagram of this two tables. (1 Mark)
  2. Make a PHP page with query to list all students in the students table with all columns. (1 Mark)
  3. Make a PHP page with query to list all students with “stuname, gender, age, sbjcode, sbjname”, the result is sorted with age. (1 Mark)
  4. Make a PHP page with query to list all students who is older than 20. (1 Mark)
  5. Make a PHP page with query to list all students who is older than 20 and also male in gender. (2 Mark)
  6. Make a PHP student list page, with each student row made into a link. Once the link is clicked, it opens a PHP student details page. It must have all students’ detail as well as the subject he/she studies. (1 Mark)
  7. Make a PHP student list page, at the end showing the average, youngest, and eldest age of the students by query. (1 Mark)
  8. Make a PHP student list page of the students whose name is less than 10 characters in length. Make a PHP student list page of the students whose name’s first 10 characters include ‘u’. (1 Mark)
  9. Make a PHP page showing students enrolled in this year using extract year function of timestamp. (Yes, that might be all the students, but that’s OK as only as the query is correct.). (1 Mark)
 
BONUS MARKS (Total 4 Marks) are given for the ability to complete all TASK 1 and 2, including where queried information matches the records.
                                                                                  
 
You must submit:
  1. Digital copy of all pages
  2. Screenshot proof of the code (query part), PHP page published result. Tables and column structure in the database interface.
 
 
 ICTDBS403 Create basic databases

Part B: Observation of Practical                                 
 
Student name:  
Student ID:  
Assessor name:  
Date of assessment:  
Subject: Database Development
Unit of competency:

ICTDBS403 Create basic databases

ICTPRG402 Apply query language

Assessment Name: Practical Project/Observation
Did the student perform the following skills: Yes No 1 Mark
each
TASK 1:      
(A) Determine the information that the database is required to hold      
(A) Develop primary and foreign keys to link the entities      
(A) Use the appropriate language on a web or database server to create one or more databases      
(A) Use the appropriate language on a web or database server to create tables      
(B) Populate the database fields      
(C) Develop a data dictionary      
TASK 2:      
(A) Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold      
(B) Use an expression to retrieve values from a single unit.      
(C) Use an expression to sort values into a certain order (C)      
(D) Use an expression to filter a sequence, based on a predicate or a condition      
(E) Use an expression to perform an operation on text values      
(E) Use an expression to filter the subset of a sequence, based on a predicate or a condition      
(F) Use an expression to combine values from more than one unit      
(G) Use an expression to extract a specific value by position      
(H) Use an expression to perform a calculation on numeric values      
(I) Use an expression to perform an operation on date and time values      
BONUS MARKS      
Test the database on the web or database server      
Identify and use the necessary tools, and environment, in building queries      
Ensure that the information represented matches the requirements      
Recognise various query-related terminologies      
The student’s performance was: Competent Not Competent      Sub Total /20
Feedback to student
 
Candidate signature:
 
 
Assessor signature:
 
 
             
 

 
Knowledge and Skill Checklist
  Knowledge and Skill Checklist Demonstrated Competency (Y/N)
1 Analyses textual information to establish requirements *
2 Uses technically appropriate language and presents information in a format, and layout, that is appropriate to the requirements *
3 Listens, and participates, in oral exchanges to effectively identify and confirm requirements *
  Presents information using appropriate and effective language in negotiating the best outcome *
4 Recognises and follows, both explicit and implicit, procedures, and meets the expectations associated with own role when submitting the documentation for approval *
5 Recognises and applies the protocols governing what to communicate, with whom and how, in a range of work contexts, when submitting the documentation to the appropriate person for approval *
6 Plans a range of routine, and some non-routine, tasks, accepting stated goals and aiming to achieve them efficiently *
7 In more complex, non-routine situations, uses a formal decision-making process, setting or clarifying goals, gathering information, and identifying and evaluating several choices against a limited set of criteria *
8 Applies formal problem-solving processes when tackling an unfamiliar problem, breaking complex issues into manageable parts, and identifying and evaluating several options for action *
9 Understands key principles and concepts underpinning the design, and operation, of digital systems and tools, and applies these when designing and creating a database *
10 Analyses and interprets technical data to determine requirements *
11 Writes and edits, computer code and technical data, ensuring the correct syntax and accuracy *
12 Makes basic calculations involving arithmetical operations *
13 Makes estimates and comparisons involving date and time data *
14 Uses digitally-based technologies and systems to enter, store and manage data  
15 Analyses textual information to establish requirements  
Comments:
 
 
Trainer Signature: (This is combined to use the coversheet trainer signature)
 
<标题>  ICTDBS403 Create basic databases

tag:
下一篇:沒有了

Contact us / 聯系我們

QQ: 273427
QQ: 273427

Online Service / 在線客服

Hours / 服務時間
全天24小時為您服務

熱情 專業 誠信 守時
Copyright ? 2008-2018 assignment代寫

在線客服

售前咨詢
售后咨詢
微信號
Badgeniuscs
微信