Design and develop the dynamic website

Reference no: EM131240782

Design and Develop the Dynamic Website and Shopping Cart

- To achieve a Competent result, each student is required to achieve a Satisfactory outcome in each marking criteria of this assessment.

- Student is required to redo the assessment in class, if outcome is Not Yet Competent due to being Not Satisfactory against any marking criteria of the given assessment.

- Plagiarism is strictly forbidden. Nil marks will be provided for plagiarism for all involved.

- Students may be asked to explain their assessment work on a regular interval to the assessor to ensure that the relevant competency standards are being met.

- The Assessor is required to the students explain the assessment instructions and required outcome before conducting assessment in class.

- The Assessor is required to record the result (Competent/Not Yet Competent) of the assessment task into the Marking Excel Sheet in accordance with the marking criteria of the assessment tasks for the student and enter the final results into RTO Manager System of the Kent Institute Australia.

- The Assessor is required to record the re-assessment result into the Marking Excel sheet in accordance with the marking criteria of the re-assessment tasks for the student and enter the final results into RTO Manager System of the Kent Institute Australia.

- The Assessor must check the student's work on each Assessment Day and provide on-going feedback to the student in class.

Build a dynamic website

1. Define and analyse the technical requirements

1.1 Identify the business requirements and appropriate standards

1.2 Determine and document, the purpose, expectations and functionality of the website

1.3 Analyse the user-interface design requirements, including user needs, design principles and operating systems

2. Produce the software design specifications

2.1 Produce a hierarchy of the website showing navigation

2.2 Ensure that the content is logical and accessible to the user

2.3 Produce the prototype of the user interface

2.4 Determine and document, the architectural requirements

2.5 Design the data storage requirements

3. Develop the website to the specified design

3.1 Create the software components of the website

3.2 Test the components of the website

3.3 Integrate the components to produce the web application

4. Test the web application

4.1 Test the website against the requirements

4.2 Complete and document the design structure

4.3 Obtain client feedback and adjust web applications as appropriate

1. Determine database requirements

1.1 Meet with the client, and conduct a user-needs analysis, to determine database functionality

1.2 Analyse the results of a user-needs analysis to identify technical requirements

1.3 Develop a conceptual model of the database

1.4 Submit the conceptual model to the client for review

1.5 Evaluate client feedback and make changes as required

2. Develop a logical data model

2.1 Identify the attributes and determine the data types

2.2 Undertake the normalisation of attributes

2.3 Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships

2.4 Document attributes, normalised data, and the ER diagram

2.5 Forward documentation to the client for confirmation

3. Design the data structures

3.1 Confirm primary and foreign keys for tables

3.2 Review client business rules

3.3 Identify the referential integrity constraints

3.4 Establish database management system constraints and incorporate into database design

3.5 Develop the validation rules for data

3.6 Design indexes and develop the data dictionary

3.7 Document the database design

4. Design queries, screens and reports

4.1 Design the user interface for database, including menus, input screens and outputs

4.2 Design queries, based on requirements

4.3 Design output reports, based on requirements

4.4 Compare the physical design with the conceptual model, or user-needs analysis

4.5 Incorporate changes as required

5. Design access and security systems

5.1 Review the business security plan as a basis for commencing the access and security design

5.2 Design the password and access system for the database

5.3 Identify multiple-user requirements

5.4 Develop client access profiles using the client business model

6. Confirm the database design

6.1 Identify the database backup and recovery requirements

6.2 Develop and document the database backup and restore procedures

6.3 Submit the database, and documentation, to the client for final approval

1. Connect to the database

1.1 Identify site data needs from the technical requirements

1.2 Connect to the database from a web application using a web development language

2. Retrieve data from database and display on web pages

2.1 Retrieve data using structured query language (SQL)

2.2 Display the data in the most appropriate control

2.3 Format the data so that it is displayed in the most effective way

3. Update the database data from user input

3.1 Update the existing data stored in the database with user-supplied input

3.2 Insert the data in the database with user-supplied input

3.3 Delete the data stored in the database

3.4 Validate the data and check for errors

Bazaar Ceramics are seeking to develop a dynamic website and shopping cart that enables new and existing customers to select products for purchase. A web presence will enable them to showcase their wares, increase sales and enable feedback from potential customers.

You have been asked to develop their dynamic website and shopping cart. The project will be implemented over a number of assessments.

The Client

The owner of the company - Kim Hayward - has become increasingly aware of the importance of the Internet as a marketing and sales tool.

Many of their competitors and industry partners now have websites and Kim has decided that in order not to be left behind, the company must develop a web presence.

The Brief

Your task is to review the requirements document to develop an understanding of the dynamic website and shopping cart and then design and develop based on these requirements.

Assessment Requirements

At the completion of this assessment of the project, you must submit the following items.

1. Technology report for Dynamic Website and Shopping Cart

To implement an online catalogue and ordering system you will be using PHP and MySQL. You are required to write a technology report on PHP and MySQL. You should:

- Search the Internet (try https://www.php.net/ and https://www.mysql.com) for information on PHP and MySQL.
- Write a report detailing the hardware and software requirements of these technologies.
- Include in the report any issues that will need to be considered when designing for the e-commerce to the dynamic website.
2. Design documentation and Prototype for Dynamic website and Shopping Cart

You are required to write a brief summary of the requirements for the Bazaar Ceramics dynamic website.

You should:

- Review the Requirements document. A requirements document was created in Assessment two (Business requirements) and Assessment three (Technical requirements) of the project. Your teacher will give you details of where to find the requirements document.

- Write a brief summary of the website requirements using the requirements summary template.

- You are required to investigate design alternatives for the website and develop a report explaining the reasons for the choices you have made for the design of the website. You should:

- Investigate what type of metaphor would be appropriate for your website (e.g. organisational, functional, or hybrid). Write a brief report (half a page) detailing your choice and the reasons for your decision.

- Develop a detailed navigation map based on the metaphor you have chosen for your website. The navigation map should show all the pages that you intend to develop on your website. These pages must be numbered.

- Write a design report using the design report template

Shopping Cart Design Documentation

- Create a navigation map and mockup of the shopping cart pages. For example what will the pages look like for the online catalogue and ordering system?

Dynamic Website and Shopping Cart Prototype

- Choose your authoring tool (this can be a simple HTML editor) or a commercial application such as Dreamweaver or Front page.

- Create a prototype to test the navigation (menu) system. You will need to create some top level "prototype" pages to test the menu.

- Test to ensure the menu system works correctly and that pages display correctly.

- Create the pages and HTML forms required for the shopping cart.

- Create multimedia elements for these pages (discuss this with your assessor).
For example you could create:

- A banner using scrolling text.

- An image map which displays explanatory text as the mouse rolls over different parts of the image.

- A short slide show sequence using images from the Bazaar Ceramics collection.

- Get approval of Prototype from the client using client requirements check list sign-off document template.

3. Developing the dynamic website and shopping cart

You are required to develop a Dynamic Website and Shopping Cart

1) Database requirements report
You are required to write a report which identifies the database requirements of the e-commerce enhancements to the Bazaar Ceramics website. You should:
- Review the project specifications
- Write a database requirements report listing the type of data and the size of the fields required for the database tables described in the specifications.
- Modify your database tables in consultation with the supervisor.
- You are required to create the database to match the tables in the database requirements report.

2) Security policy
You are required to develop a naming convention and password policy for security to the database.

3) Dynamic Website and shopping cart

You are required to test the development environment organised at Kent Institute.

Organise access to a server at Kent Institute. Check with your assessor about what method should be used for this. Create a test web page and load it onto the server.

Develop a dynamic website and shopping cart based on the prototype developed. Ensure that you include:
- Facility for customers to add their name to a mailing list
- Facility for customers to fill out an order form
- You are required to setup and test a database connection to your web server.
- You should: Install and configure PHP and MySQL (Both are pre-installed an pre-configured at Kent Institute)

- Create a PHP script to open a database connection to the database server
- Test the connection by querying the "test" database
- You are required to implement the e-commerce functions in the prototype specifications document.
- Include PHP scripting language and MySQLQuery as per required in the prototype files.
- Test to ensure the dynamic website pages and shopping cart pages work correctly and that pages display correctly. Record the test result into Test result document
- Review Test Result document to fixed the bugs and submit bug free Dynamic Website and Shopping Cart.

Attachment:- Resources.rar

Reference no: EM131240782

Questions Cloud

What is the velocity vpi of the plank relative : (a) What is the velocity vpi of the plank relative to the surface of the ice? (b) What is the girl's velocity vgi relative to the ice surface?

Under the standard merger guidelines of the fed : The banking industry in Athens, Ohio currently has 4 banks with market shares of 60%, 20%, 15% and 5%. The 2 smallest banks have proposed merging. Under the standard merger guidelines of the Fed and DOJ, is a merger likely to be approved? If so, why?..

Calculate the price elasticity of demand for pineapples : Calculate the percent change in price that occurs in moving from point A (the "base" case) to point B, using the midpoint formula. (If directed by your instructor, also calculate this using the log-difference formula.)

Compute probability that flight depart late or arrives early : Calculate the probability that a flight will depart early or on-time. Calculate the probability that a flight will arrive late. Calculate the probability that a flight departs late or arrives early.

Design and develop the dynamic website : DWDP2v15-Website Development Project - Design and Develop the Dynamic Website and Shopping Cart and To achieve a Competent result, each student is required to achieve a Satisfactory outcome in each marking criteria of this assessment - Determine and..

Calculate the amount of revenue the seller would receive : Reasoning from the results you just calculated, is the demand for bananas elastic or inelastic, in this range of prices? How do you know?

Draw a diagram of a perfectly inelastic demand curve : A limited number of Civil War uniforms have been preserved. No matter how much buyers are willing to pay for these uniforms as collectors items, there ;s no way to increase the quantity of uniforms in existence. Show the supply curve for authentic..

Formation of oil and natural gas : What is the difference in the source material for the formation of coal as opposed to the formation of oil and natural gas?

How you would orient the new employee and introduce him : Prepare 4-5 page paper describing how you would orient the new employee and introduce him/her to your organization's culture. Consider probation periods and the initial reviews necessary to ensure that the new hire is successful.

User Account

All Pages