Please review the assignement and let me know what you think.

Learner achievement (please circle) NB: All learner achievement is provisional until confirmed at the AVA Awards Board.

Level Achieved:

L3

Achievement

(Level 3 units only)

Resubmission?

Y

N

Title of Access to HE Diploma:

(e.g. Science)

Unit title(s): Creating Database Driven Web Pages

Unit code(s):

Learner:

Description of Assignment:

This assignment is both a written and practical assignment that will demonstrate your skills in the creation of database driven web pages

TASK 1

Create a MySQL database containing a single table (games) for an online games store. The games table will store information about games with the minimum of the following fields: game title, genre, year of release, publisher, screenshot, and a written review and (possibly) other fields of data relating to games. Choose appropriate data types and widths for each field.

Note 1) As your database server might not allow you to choose the database name any name is acceptable for this

Note 2) The screenshot data does not need to be stored inside the table. Commonly this will contain a local file path or URL that can be used as a web hyperlink

Use PhpMyAdmin to add 5 records to the games table based on existing information which you will research on existing games websites.

Create a username and password that can access this database using your firstname+lastname and a password of your own choice. This account should have full access to the database.

Create a webpage that connects to your database using PHP. Store the information the connection needs (database name, table name, username /password) in PHP variables. Display a message in the webpage when a successful connection is 2.3]

Create a Word document Task1 that contains

1. A screenshot of your working webpage

2. A well commented listing of your HTML/PHP code
   Show this to your tutor to progress to the next stage

TASK 2

You will build on your work in task 1 and develop the database to the next stage

Using the existing records in your games db you will need to create the following:

• You will create a display all records page which lists all the items in the database in a html table using a control structure [1.3]

• You will create an insert form to allow games to be added to the database, implement validation checks so that data is correctly entered. [4.2] [5.4]

• Create a complex query by creating an update page which will allow users to edit the games in the database [4.3]

• You will create a delete page which will allow you to delete games records in the database. [4.4]

• You will create a basic search engine form which allows the user to search on multiple fields on the database and give back a results page based on those fields

For this You will need to create a complex query using SQL and execute this query on the remote database. This results page will use single control structures for selection and iteration such as conditional statements and loops to go through all the records. [3.1] [4.1]

• You will extend this page to show a list of games titles outputted as hyperlinks which then take you to more detail about the game that is chosen [3.2] [3.3]

• You will make a single page which has links to all these different pages you have made – all records, insert record, delete record, update records and search .

• Finally you will password protect access to this page [6.1]

Show this all working to your tutor to progress to the next stage

To document this work, you will create software documentation for the user, this will have three parts.

Task 2a) Write an introductory section which explains how requirements can vary between the client (games store owner) and end user and explain the importance of an effective user experience [1.1]

Task 2b) Create and justify your user interface by producing design documentation in the form of wireframes and sketches to meet the specific client requirements as outlined below. [1.2]

The client requirements are

• The website application should work on mobile phones

• There should be a main menu to move between the different pages such as display all records, insert, delete, update and search

• Instructional text and menu labels should be intuitive

• There should be prompts where forms are not filled out correctly prompting the user to enter data correctly

Task 2c) Create a user guide document with live links and screenshots of your working pages and well commented page listings to show your understanding. Use current web development conventions in your approach.

TASK 3

You will write a report which addresses the following questions within a word limit of 1500 words. Please indicate supporting references.

1. What are the differences and similarities between clientside and server-side scripting. Draw your conclusions by giving some practical examples of code within the types of languages involved and explain where you may use these giving real examples [2.1]

2. Explain the environment or framework you have chosen to develop your web database application [2.2]

3. What are the differences between (GET and POST) in relation to the published and tested multi-page scripting you have completed using request.form and query strings. [5.3]

4. Why would you need to password protect parts of a website? [6.1] Why would you use a hidden form element on a website [6.2]

5. Why would you need to validate user input for a website with a database? Describe the validation checks have you implemented? [5.4]

6. Finally review and evaluate the success of your uploaded files for your web database application suggesting areas for future development [7.2]
   File naming. Your tasks should be labelled in the following format
   firstname_surname_Task1_ddwp.doc
   firstname_surname_Task2_ddwp.doc
   firstname_surname_Task3_ddwp.doc
   Upload this to Moodle to the designated final submission area by the deadline

Date set:

Date for draft submission

(if applicable):

Date for final

submission: 29th May 2022

Extension date

(if agreed):

Signed by Tutor/Assessor to agree extension:

Date

submitted:

Internal Moderation: Yes / No

Date:

Signed by internal moderator:

ON TIME / LATE

Learner declaration:

 The explanations and evaluations in this work have been developed and written by me.

 I have not submitted material copied from the Internet, text books or other sources in place of my own thinking and writing.

 When I have referred to the work of others I have done so to discuss, comment on or argue their ideas.

 I have kept quotation and paraphrasing to an absolute minimum and only to support points I have made.

 I understand that referencing the names of authors whose ideas I have used without including my own interpretation of those ideas, does not meet the assessment criteria and cannot attract the Pass, Merit or Distinction grades.

 I have not copied the work of my peers.

Learner comments: (please use this space to comment on any aspect of the assignment when handing in your work)

Signature:

Date:

Level 3

Unit title:

Learning outcomes

Assessment criteria

This is what you will learn on the unit.

This is what you must be able to demonstrate that you can do in your assignment in order to achieve the unit.

The learner will:

The learner can:

1. Understand the client/server

architecture involved in web-database

applications.

1. 1. Explain the differences between clientside and server-side scripting.

   2. Publish and test a page that uses two variables.

   3. Publish and test pages that use single control structures for selection and iteration.

   4. Explain the differences between the published and tested multi-page scripting using request.form and query strings

1. Know how to create a connection to a

data source

1. 1. Explain the purpose of ODBC and identify an ODBC complaint DBMS.

   2. Create the DNS-less link to the database.

   3. Create a complex query using SQL and execute that query on a remote database

1. Know how to create a data driven web

search form

1. 1. Create a search form allowing the user to search on multiple fields in the database.

   2. Create a hyperlink output list displaying the results of the searches on the different fields.

   3. Create an output form to display search details from the different fields.

1. Be able to create a data driven web

update form.

1. 1. Create an Insert form allowing data to be inserted into the database.

   2. Create an Update form allowing users to edit data in the database.

   3. Create a Delete facility allowing users to delete data in the database.

1. Know how to customise and enhance

data forms.

1. 1. Explain the need for password protection and implement password protection for parts of the site.

   2. Explain the need for the validation of user input and implement validation checks.

   3. Explain the purpose of hidden form element implemented.

1. Be able to upload to a local web

server.

1. 1. Identify suitable ISP host sites and upload to a local web server.

Level 3 units only:

Learners achieve a Pass if they meet all Level 3 Assessment Criteria for a unit. You will achieve a Merit or Distinction by meeting the following Grade Descriptors. Your tutor will give you feedback for all three grades.

Grade Descriptor

Merit

(Choose one or more relevant grade components)

Distinction

(Choose one or more relevant grade components)

GD1. Understanding the subject

1 demonstrates a very good grasp of the relevant knowledge base

2 is generally informed by the major conventions and practices of the area of study

3 demonstrates very good understanding of the different perspectives or approaches

associated with the area of study.

1 demonstrates an excellent grasp of the relevant knowledge base

2 is consistently informed by the major conventions and practices of the area of study

3 demonstrates excellent understanding of

the different perspectives or approaches

associated with the area of study

Grade Descriptor

Merit

(Choose one or more relevant grade components)

Distinction

(Choose one or more relevant grade components)

GD 3. Application of Skills

1. Generally selects appropriate Techniques

2. Applies appropriate (selected or given) Skills with very good

• Confidence

• Consistency

1. Consistently selects appropriate Techniques

2.Applies appropriate (selected or given)

Skills with excellent

• Confidence

• Consistency

Grade Descriptor

Merit

(Choose one or more relevant grade components)

Distinction

(Choose one or more relevant grade components)

GD7: Quality

Is structured in a way that is generally logical & fluent

Contains some ambiguities or limitations in the expression of arguments or ideas

Taken as a whole, demonstrates a very good response to the demands of the brief/assignment

Is structured in a way that is consistently logical & fluent with clear expression of ideas.

Taken as a whole, demonstrates an excellent response to the demands of the brief/assignment

Grade Guidance: Learners must carefully read the guidance below which is linked to the components above

MERIT: (e.g. To achieve a Merit your work will show…..)

GD1 : To achieve merit you will have been generally informed by the major conventions and practices in web development with evident references to support this.

GD3: To achieve merit, you should generally select appropriate techniques and apply skills to complete the database driven web page programming tasks with very good confidence and consistency. The code should run correctly with a good user experience.

GD7: To achieve merit, your work be complete, well thought out and commented appropriately. Both your programming and SQL code should be thought through with thought to efficiency where possible. You will need to reference external sources to show how you have extended your learning.

DISTINCTION: (e.g. To achieve a Distinction your work will show…..)

GD1 : To achieve distinction you will have been consistently informed by the major conventions and practices in web development with substantial evident references to support this.

GD3: To achieve distinction you should consistently select appropriate techniques and apply skills to complete the database driven web page programming tasks with excellent confidence and consistency. The code should run with an excellent user experience with meaningful feedback to the user.

GD7: To achieve the higher grades of distinction, your work be complete, very well thought out and very well presented and commented appropriately. It should be a model to others who are learning how to make database driven web pages and demonstrate the depth of your understanding. Both your programming and SQL code should be well thought through with thought to redundancy and efficiency using functions where possible.

Part A: Feedback on credit level

AC no

Credit achieved (L3)

Location of evidence

Tutor/Assessor comments on assessment criteria

(the assessor may also indicate on the work itself where each AC is met)

1.1

1.2

1.3

1.4

2.1

2.2

2.3

3.1

3.2

3.3

4.1.

4.2

4.3

5.1

5.2

5.3

6.1

Level achieved

Tutor/Assessor’s signature:

Date:

Resubmission (if applicable) If any of the assessment criteria for this assignment have not been met at Level 3, a resubmission may be permitted. Resubmission must follow the QAA guidelines and be permitted only once.

Requirements for resubmission/new Task set:

Feedback on resubmission:

Level achieved

after resubmission:

Tutor/Assessor’s signature:

Part B: Feedback on grading (Applicable only if all assessment criteria achieved at Level 3)

Grade Descriptor

Tutor/Assessor comments against grade descriptors

Grade indicator

(P/M/D)

Please enter the final grade on page 1 based on this grade profile e.g. PPM=P

GD1. Understanding the subject

GD3. Application of knowledge

GD7: Quality

Tutor/Assessor’s reason for final grade decision (if applicable):

Areas for development (how will the learner be able to use and improve on what they have learnt on this unit and the skills that they have used in their further studies?)