logo

Assessment Item 3 for ICTWEB501 - Build a Dynamic Website

11 Pages3042 Words209 Views
   

Added on  2019-09-23

About This Document

This assessment task requires students to create a dynamic website for a small engineering bookshop using SQL and database management. The task includes creating tables, inserting records, and creating web pages with forms and links. The assessment criteria are provided in the instructions.

Assessment Item 3 for ICTWEB501 - Build a Dynamic Website

   Added on 2019-09-23

ShareRelated Documents
Assessment Task Instructions and Feedback Form (non-graded)Task No.3Task TitleAssessment Item 3Due Date30/11/2018Unit / Module detailsQualification/Course CodeICT60515TitleAdvanced Diploma of Computer Systems TechnologyUnit/Module CodeICTWEB501TitleBuild a Dynamic WebsiteAssessment detailsAssessor Assessor’s nameVikram BehalAssessor’s phone03 9254 6130Assessor’s emailvbehal@kangan.edu.auElements / Learning outcomesElement 1, 2, 3,4RTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page 1 of 11
Assessment Item 3 for ICTWEB501 - Build a Dynamic Website_1
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 booksb.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 tablesg. Import script in your WAMP make sure you logged in as root in WAMP.h. Upload SQL file/script with this fileTask 2.Students are required to create web site for Small Engineering Bookshop. Bookshop is dealingwith 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.Homeii.Book Listiii.Author Listiv.Customer Listv.Form to insert customer details into table customersvi.Useful links to other websitesKangan InstituteGoogle AustraliaWorksafe Victoriavii.Contact usTask 3.Students are required to use database books. When student will click on Book List. They mustget 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 authorsTask 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 mustbe 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 01218GVersion 1.0Last saved 21/11/2018Page 2 of 11
Assessment Item 3 for ICTWEB501 - Build a Dynamic Website_2
Assessment Task Instructions and Feedback Form (non-graded)Assessment conditionsThis 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 timeStudents must submit this Assessment item at MyLearningThis assessment item is assignmentStudent can complete this assessment in their own time. This assessment item is due in week8; however student can negotiate time with teacher under special circumstancesRead 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 underResourcesResources are available through MyLearningHow to submitComplete Assessment items as per assessment Item description and upload assessment item at MyLearningAll items submitted must be clearly marked with the following details:•Your full name•Your student number•Your class group•The dateThis cover sheet must accompany all items submitted.RTO Identifier 3077 | CRICOS provider number 01218GVersion 1.0Last saved 21/11/2018Page 3 of 11
Assessment Item 3 for ICTWEB501 - Build a Dynamic Website_3
Assessment Task Instructions and Feedback Form (non-graded)Assessment instructions and criteriaWith 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 BackspaceRows can be added by left clicking to the left of the row and click CTRL+C and then CTRL+VInstruction/TaskCriteria that you will be assessed onSNSTask 1. Students are required to create SQL File/script to do following:a.Create one database called booksb.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 bothtablesg. Import script in your WAMP make sure you logged in as root in WAMP.h. Upload SQL file/script with this fileStudents createed SQL File/script to do following:a.Create one database called booksb.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 andStudent 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 andlink it with Authorid of Book (Books database) as under: (Author_id) REFERENCES Book(Authorid);f. Inset at least four records in both tablesg. 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 01218GVersion 1.0Last saved 21/11/2018Page 4 of 11
Assessment Item 3 for ICTWEB501 - Build a Dynamic Website_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Design, Development and Testing of a Website for Fitzroy Catholic Bookshop
|15
|4680
|337

Database Design & Development - PDF
|16
|1036
|22

COS80001 - Software Development for Cloud Computing Assignment
|6
|1958
|314

Advanced Object Oriented Programming
|8
|591
|53

Object Oriented and Web Programming
|9
|2238
|33

Develop and Apply Knowledge of Marketing and Communication Industry- Assessment
|10
|2607
|206