Development of a Website for Small Engineering Bookshop

The assignment is to create a website for Small Engineering Bookshop, which deals with new and old engineering-related books. The website must contain various sections, including the name of the business, address, phone number, and fax number in the top section, links to different websites or businesses in the left-hand section, and a table displaying book information from the database when clicked on 'Book List'. Additionally, students are required to create two web pages with simple forms to insert data into the 'Customer' and 'Order' tables, respectively. Finally, student must provide user documentation for all tasks.

Assessment Task Instructions
and Feedback Form (non-graded)
Task No. 3 Task Title Assessment Item 3 Due Date 30/11/2018
Unit / Module details
Qualification/Course Code ICT60515 Title Advanced Diploma of Computer Systems Technology
Unit/Module Code ICTWEB501 Title Build a Dynamic Website
Assessment details
Assessor Assessor’s name Vikram Behal Assessor’s phone [phone]
Assessor’s email [e-mail]
Elements / Learning
outcomes
Element 1, 2, 3,4
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 1 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Task overview
(see below for specific
instructions and criteria)
Students are required to accomplish their task professionally and in allocated time.
This project requires students to work individual, however they can discuss contents
of website with their team. It is their responsibility to inform teacher if they need any
extra time to accomplish this task.
Task 1. Students are required to create SQL File/script to do following:
a. Create one database called books
b. Create user 'user3'@'localhost' password 'Password01' and GRANT him permissions like
SELECT, INSERT, UPDATE and DELETE.
c. CREATE TABLE Book as per Task Instructions and Student Work (page 7)
d. CREATE TABLE Author as per Task Instructions and Student Work (page 7)
e. CREATE TABLE Customers as per Task Instructions and Student Work (page 7)
f. CREATE TABLE Order as per Task Instructions and Student Work (page 7)
g. ALTER TABLE Order as per Task Instructions and Student Work (page 7)
h. ALTER TABLE Book ADD FOREIGN KEY Author_id and link it with Authorid of Author
(Books database) as under:
i. (Authorid) REFERENCES Author(Author_id);
f. Inset at least four records in both tables
g. Import script in your WAMP make sure you logged in as root in WAMP.
h. Upload SQL file/script with this file
Task 2. Students are required to create web site for Small Engineering Bookshop. Bookshop is dealing
with new and old engineering related books. Website for small Engineering Bookshop must
contains following, however first page must have three sections. Students are required to use
books database provided by teacher:
a. Top section must Display
Name of Business, Address of Business Phone number and Fax number.
b. Left hand section must contain links to different web sites and/or links to business. Some
sample links are as under:
i. Home
ii. Book List
iii. Author List
iv. Customer List
v. Form to insert customer details into table customers
vi. Useful links to other websites
 Kangan Institute
 Google Australia
 Worksafe Victoria
vii. Contact us
Task 3. Students are required to use database books. When student will click on Book List. They must
get three options as under and they must display records as per options. Students must display
content of Task 2 in a table format.
a. Display 1st five records from table boo.
b. Display seven records from table book starting from 3rd record.
c. Display 1st five records from table book and display only id, ISBN, Title and description.
Task 4. Students are required to use database books. When student will click on Author List, It mut
display all authors
Task 5. Students are required to create one web page with simple form to insert data into table
customer of database books. Form must have two buttons Clear and submit. When student will
press clear button form must clear all fields and when student will enter submit button, data must
be inserted into table “Customer” of database books.
Task 6. Students are required to create one web page with simple form to insert data into table
Order of database books. Form must have two buttons Clear and submit. When student will press
clear button form must clear all fields and when student will enter submit button, data must be
inserted into table “Order” of database books.
Task 7. Students are required to create user documentation for above website (for all above tasks).
Please note Add screenprint at the end of this document.RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 2 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Assessment
conditions
 This information is to be handed to each student to outline the assessment requirements.
 This is open book assessment.
 Students are required to submit this assessment item as a report.
 This Assessment Item requires students to work individually and address all requirements/
complete all tasks as per Assessment instructions and criteria.
 Students are required to accomplish their task professionally and in time
 Students must submit this Assessment item at MyLearning
 This assessment item is assignment
 Student can complete this assessment in their own time. This assessment item is due in week
8; however student can negotiate time with teacher under special circumstances
 Read the Plagiarism policy and procedure carefully to understand the consequences that you
could face if your work is plagiarized.
 You plagiarize if you present other writers' words or ideas as your own.
 You must use citations to document all ideas and significant information that are not your
own.
 Submit this document by the due date (penalties applies)
 Insert your name and student id in the footer.
 Use Font: Arial Font Size: 10 Heading: Bold Arial Heading Size: 12 Sub Heading: Bold Arial
Sub Heading Size:
 Marking Criteria for this assessment Item is as under
Resources Resources are available through MyLearning
How to submit Complete Assessment items as per assessment Item description and upload assessment item at
MyLearning
All items submitted must be clearly marked with the following details:
• Your full name
• Your student number
• Your class group
• The date
This cover sheet must accompany all items submitted.
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 3 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Assessment instructions and criteria
With competency based assessment all assessment requirements for each assessment task must be assessed as satisfactory
(S) for a competent (CA) result to be recorded. If an assessment result for any task is assessed as not satisfactory (NS) a
resubmission will be required for the outstanding (NS) assessment task.
Rows can be deleted by left clicking to the left of the row and click Backspace
Rows can be added by left clicking to the left of the row and click CTRL+C and then CTRL+V
Instruction/Task Criteria that you will be assessed on S NS
Task 1. Students are required to create SQL
File/script to do following:
a. Create one database called
books
b. Create user 'user3'@'localhost'
password 'Password01' and
GRANT him permissions like
SELECT, INSERT, UPDATE and
DELETE.
c. CREATE TABLE Book as per Task
Instructions and Student Work
(page 7)
d. CREATE TABLE Author as per
Task Instructions and Student
Work (page 7)
e. CREATE TABLE Customers as per
Task Instructions and Student
Work (page 7)
f. CREATE TABLE Order as per Task
Instructions and Student Work
(page 7)
g. ALTER TABLE Order as per Task
Instructions and Student Work
(page 7)
h. ALTER TABLE Author ADD
FOREIGN KEY Author_id and link
it with Authorid of Book (Books
database) as under:
(Author_id) REFERENCES
Book(Authorid);
f. Inset at least four records in both
tables
g. Import script in your WAMP
make sure you logged in as root in
WAMP.
h. Upload SQL file/script with this
file
Students createed SQL File/script to do following:
a. Create one database called books
b. Create user 'user3'@'localhost' password
'Password01' and GRANT him permissions like SELECT,
INSERT, UPDATE and DELETE.
c. CREATE TABLE Book as per Task Instructions and
Student Work (page 7)
d. CREATE TABLE Author as per Task Instructions and
Student Work (page 7)
e. CREATE TABLE Customers as per Task Instructions and
Student Work (page 7)
f. CREATE TABLE Order as per Task Instructions and
Student Work (page 7)
g. ALTER TABLE Order as per Task Instructions and
Student Work (page 7)
h. ALTER TABLE Author ADD FOREIGN KEY Author_id and
link it with Authorid of Book (Books database) as
under:
(Author_id) REFERENCES Book(Authorid);
f. Inset at least four records in both tables
g. Import script in your WAMP make sure you logged in
as root in WAMP.
h. Upload SQL file/script with this file
☐ ☐
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 4 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Assessment instructions and criteria
Task 2. Students are required to create web
site for Small Engineering Bookshop.
Bookshop is dealing with new and old
engineering related books. Website for small
Engineering Bookshop must contains
following, however first page must have three
sections. Students are required to use books
database provided by teacher:
a. Top section must Display Name
of Business, Address of Business
Phone number and Fax number.
b. Left hand section must contain
links to different web sites
and/or links to business. Some
sample links are as under:
Students createed web site for Small Engineering Bookshop.
Bookshop is dealing with new and old engineering related books.
Website for small Engineering Bookshop must contains following,
however first page must have three sections. Students are
required to use books database provided by teacher:
a. Top section must Display Name of Business, Address
of Business Phone number and Fax number.
b. Left hand section must contain links to different web
sites and/or links to business. Some sample links are
as under:
☐ ☐
Task 3. Students are required to use
database books. When student will click on
Book List. They must get three options as
under and they must display records as per
options. Students must display content of Task
2 in a table format.
a. Display 1st five records from table booklist.
b. Display seven records from table booklist
starting from 3rd record.
c. Display 1st five records from table booklist
and display only id, ISBN, Title and description.
Students used database books. When student will click on Book
List. Task 3 is completed properly. All following options are orking:
a. Display 1st five records from table booklist.
b. Display seven records from table booklist starting from 3rd
record.
c. Display 1st five records from table booklist and display only id,
ISBN, Title and description.
☐ ☐
Task 4. Students are required to use
database books. When student will click on
Author List, It must display all authors
When student clicked on Author List, It must display all authors ☐ ☐
Task 5. Students are required to create one
web page with simple form to insert data into
table customer of database books. Form must
have two buttons Clear and submit. When
student will press clear button form must clear
all fields and when student will enter submit
button, data must be inserted into table
“Customer” of database books.
Students createed one web page with simple form to insert data
into table customer of database books. Form must have two
buttons Clear and submit. When student will press clear button
form must clear all fields and when student will enter submit
button, data must be inserted into table “Customer” of database
books.
☐ ☐
Task 6. Students are required to create one
web page with simple form to insert data into
table Order of database books. Form must
have two buttons Clear and submit. When
student will press clear button form must clear
all fields and when student will enter submit
button, data must be inserted into table
“Order” of database books.
Students createed one web page with simple form to insert data
into table Order of database books. Form must have two buttons
Clear and submit. When student will press clear button form must
clear all fields and when student will enter submit button, data
must be inserted into table “Order” of database books.
☐ ☐
Task 6. Students are required to create user
documentation for above website (for all
above tasks).
Student createed user documentation for above website (for all
above tasks).
☐ ☐
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 5 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Student details
Student’s name Click here to enter text. Student’s ID Click here to enter
text.
Unit/Module details
Unit/Module Code ICTWEB5
01
Title Build a Dynamic Website
Task title Assessment Item 3
Assessment feedback / comments
Click here to enter text.
Re-submission (where applicable)
Unsatisfactory tasks are to be re-submitted according to the details below. Type NA if not applicable.
Task (or component of task) to be
re-submitted
Additional evidence required Re-Submission date S NS
Task for re-submission Evidence Date ☐ ☐
Task for re-submission Evidence Date ☐ ☐
Task for re-submission Evidence Date ☐ ☐
Result for this assessment task
Your final result for this unit will be provided on the Unit Result Record at completion of all
assessment tasks
Result Choose an item.
Assessor’s signature Date
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 6 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Task Instructions and Student Work
Students are required to accomplish their task professionally and in allocated time. This project requires students to work
individual, however they can discuss contents of website with their team. It is their responsibility to inform teacher if they need
any extra time to accomplish this task.
Task 1. Students are required to create SQL File/script to do following:
a. Create one database called books
b. Create user 'user3'@'localhost' password 'Password01' and GRANT him permissions like SELECT, INSERT, UPDATE and
DELETE.
c. CREATE TABLE Book as under (bookid, Bookname and Authorid are three fields in this table):
i. bookid VARCHAR(10) PRIMARY KEY,
ii. Bookname VARCHAR(30),
iii. Authorid VARCHAR(10)
d. CREATE TABLE Author as under (Author_id, FirstName, LastName and email are fields):
i. Author_id VARCHAR(10) PRIMARY KEY,
ii. FirstName VARCHAR(30),
iii. LastName VARCHAR(30),
iv. email VARCHAR(30),
e. CREATE TABLE Customers as under (Customer_id, FirstName, LastName, email abd phone are fields):
i. Customer_id VARCHAR(10) PRIMARY KEY,
ii. FirstName VARCHAR(30),
iii. LastName VARCHAR(30),
iv. Address VARCHAR(30),
v. email VARCHAR(30),
vi. phone VARCHAR(10),
f. CREATE TABLE Order as under (Customer_id, FirstName, LastName, email abd phone are fields):
i. Customer_id VARCHAR(10),
ii. bookid VARCHAR(10)
iii. Orderdate DATE,
iv. Order details VARCHAR(30),
g. ALTER TABLE Order ADD PRIMARY KEY Customer_id,bookid and link it with customers and book (Books database) as
under:
(Customer_id) REFERENCES Customers(Customer_id);
(bookid) REFERENCES Book(bookid);
h. ALTER TABLE Book ADD FOREIGN KEY Author_id and link it with Authorid of Author (Books database) as under:
i. (Authorid) REFERENCES Author(Author_id);
i. Inset at least four records in all tables
j. Import script in your WAMP make sure you logged in as root in WAMP.
k. Upload SQL file/script with this file
Task 2. Students are required to create web site for Small Engineering Bookshop. Bookshop is dealing with new and old
engineering related books. Website for small Engineering Bookshop must contains following, however first page must have
three sections. Students are required to use books database provided by teacher:
a. Top section must Display
Name of Business, Address of Business Phone number and Fax number.
b. Left hand section must contain links to different web sites and/or links to business. Some sample links are as under:
i. Home
ii. Book List
iii. Author List
iv. Customer List
v. Form to insert customer details into table customers
vi. Useful links to other websites
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 7 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
 Kangan Institute
 Google Australia
 Worksafe Victoria
vii. Contact us
Task 3. Students are required to use database books. When student will click on Book List. They must get three options as under
and they must display records as per options. Students must display content of Task 2 in a table format.
a. Display 1st five records from table book.
b. Display seven records from table book starting from 3rd record.
c. Display 1st five records from table book and display only id, ISBN, Title and description.
Task 4. Students are required to use database books. When student will click on Author List, It mut display all authors
Task 5. Students are required to create one web page with simple form to insert data into table customer of database books.
Form must have two buttons Clear and submit. When student will press clear button form must clear all fields and when
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 8 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
student will enter submit button, data must be inserted into table “Customer” of database books.
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 9 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Task 6. Students are required to create one web page with simple form to insert data into table Order of database books. Form
must have two buttons Clear and submit. When student will press clear button form must clear all fields and when student
will enter submit button, data must be inserted into table “Order” of database books.
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 10 of 11

Assessment Task Instructions
and Feedback Form (non-graded)
Students are required to create user documentation for above website (for all above tasks).
For this assessment I created a SQL DATABASE and in that data base I added four collums which was the first task. After
that I created a html website using frames for the homepage and menu,after that created a table that would display the
the books from the database.After that I created two web pages that would automatically insert entered deatails from the
questioner from the basic html web form.
Task 7.
RTO Identifier 3077 | CRICOS provider number 01218G
Version 1.0 Last saved 22/11/2018 Page 11 of 11