Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Term Project - A small sales site will be developed (As explained in two different lecture sessions) - No Frameworks are allowed - Zero Code

image text in transcribed
image text in transcribed
image text in transcribed
Term Project - A small sales site will be developed (As explained in two different lecture sessions) - No Frameworks are allowed - Zero Code Similarity (Similarity will be controlled both by the instructor and plagiarism software) - A ZIP or RAR file must be submitted - Your compressed file must contain; - your CSS, HTML, JS, PHP files - A text file for CREATE DATABASE, CREATE TABLE and INSERT INTO queries Minimum You have to have the following pages - A Login Page - A Signup Page - Search/List Products - View Past Purchases - View Current Cart - Add Products to the Cart Remove Products from the Cart - Purchase Page (Payment Page) - Confirm Purchase Remove Products from the Cart - Purchase Page (Payment Page) - Confirm Purchase - Logout Page - Admin Page to add, remove, modify products In your Database you should have the following tables (minimum) - User Table - username; - password - name - surname - address - email - telno - Products - prod_code - brand - model - name - desc - price - Purchases - user_id - prod_id - quantity - date_time - User Table - username; - password - name - surname - address - email - telno - Products - prod_code - brand - model - name - desc - price - Purchases - user_id - prod_id - quantity - date_time - purchased (boolean) - invoice_no (optional) - Invoice (Optional) - invoice_no - product - price - amount - vat

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

Students also viewed these Databases questions

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago

Question

Explain the characteristics of a good system of control

Answered: 1 week ago

Question

State the importance of control

Answered: 1 week ago

Question

What are the functions of top management?

Answered: 1 week ago

Question

Know how to use reservations systems to inventory demand.

Answered: 1 week ago