Assessment Cover Sheet-OCT16 Assessment Cover Sheet This Assessment Cover Sheet is required to be attached to your assessment task prior to submission for marking Student Details Family Name: Given...

1 answer below »
Assessment Cover Sheet-OCT16
Assessment Cover Sheet

This Assessment Cover Sheet is required to be attached to your
assessment task prior to submission for marking
Student Details
Family Name:

Given Name:

Subject Details
Qualification:

Unit Code and Title:
ICTDBS504 – Integrate database with a website
Trainers’ Name:

Assignment Details
Due Date:

Assessment No:
(If applicable)

Date Submitted:

Checklist
· I have kept a copy of my assignment before submitting
· I have completed and signed this page
· I have answered all questions in the assignment
· I have attached any relevant evidence/documentation, as required for the assessment
Declaration
I have been advised of the assessment requirements and have been made aware of my rights and responsibilities as an assessment candidate.
I declare that, to the best of my knowledge and belief, this assignment is my own work, all sources have been properly acknowledged, and the assignment contains no plagiarism. This assignment or any part thereof has not previously been submitted for assessment at this or any other RTO.

Student’s signature:

Date:

Assessment Feedback








Result
Satisfactory
Not Satisfactory
RPL
RCC
NYC – New assessment date scheduled or FIR – Further information Required
Date:
Trainers/Assessors signature:
Date:
Student Comments



· I have received my assessment result and am satisfied with the feedback given on this assessment
Student’s signature:
Date:
Questions:
1.1
List the website functions that typically benefit from a database implementation. What sort of e-commerce system makes use of databases?
1.2
Using MySQL in batch mode, perform the following tasks:
· Connect to MySQL server and create a database (with a name of your choosing)
2.1
List four functions you may wish to perform on the database from the web browser. What is a common setup for input data via a browser? List 3 queries (SQL) to retrieve data from the table
2.2
What does an authentication mechanism aim to do? What organizational document should database permission sets and authorisation parameters for each class of user be based on? List two permission sets.
• Display/select only the customer who has an id of 1
• Display/select email addresses from all records in table
2.3
Show some interface(website structure)
o Pages will be constructed in PHP with basic CSS styling
o Some graphics are included such as the banner are included but students can include their own if they wish for extra practice.
3.1
Create a database (with a name of your choosing)
• Create a table called customers with the following fields:
o customerid (integer, primary key, not null, auto increment)
o givenname (40 characters) o familyname (40 characters)
o email (60 characters)
•Update existing data stored Update table to include:
o address (80 characters)
3.2
• Insert two records into table created above in 3.1, list number of queries can be used to insert data into different formats.
3.3
Delete two records from table reacted above 3.1. List multiple queries to delete data stored in database.
3.4
Research database check or repair tools and validate above database you have created and produce results.
1.8 | Universal Network of Infotech Pty Ltd t/as Institute of Technology Australia | Assessment Cover Sheet-OCT16 | App RTO | 7-Apr-19
1 of 4
1.8 | Universal Network of Infotech Pty Ltd t/as Institute of Technology Australia | Assessment Cover Sheet-OCT16 | App RTO 7-Apr-19
4 of 4
Answered 15 days AfterMay 02, 2021ICTDBS504Training.Gov.Au

Solution

Neha Raghav answered on May 10 2021
27 Votes

Assessment Cover Sheet-OCT16
Assessment Cover Sheet

This Assessment Cover Sheet is required to be attached to your
assessment task prior to submission for marking
Student...

Submit New Assignment

Copy and Paste Your Assignment Here