Identify and fully document the database data requirements

Assignment Help Computer Engineering

Reference no: EM133422828

Project Scope

The project involves the creation of a front-end website supported by a back-end database to implement an online shop for TAFE Sunnies. Customers will be able to view and order products online. The website must be responsive to different screen sizes. No gateway payment is included in this project.

Data Requirements

The purpose of this assessment item is to identify and fully document the database data requirements for the project. The database must be able to store information about:

Products
Customers details
Registration (creation of customer accounts)
Customer login
Admin login
Shopping cart
Sales records (The permanent records that you must keep for accounting and taxation purposes)

The product information must be stored in the database. Images of the products must also displayed in the website from the image path stored in the database.

Customers can send products to the shopping cart, view the shopping cart and also add (change quantity) and delete cart products.

They can buy products as guests or they can create an account and become site members.

Once they proceed to checkout, they are asked to login or provide guest details. Once this step is done, an invoice will be displayed on the screen.

The role of the admin users in the system is to be able to add new products and modify existing ones (e.g. updating prices or deleting products). There are two level of privileges amongst the admin users. The admin manager can create new admin user accounts while the admin users cannot.

Reports, screens and automated queries

The following reports and screens must be create d and must be supported by the corresponding MySQL queries:

Login screen
Registration screen
Display products (all products)
Display products by category
Display shopping cart screen
Invoice report
Permanent sales records for a specific date and/or date range
Permanent sales records by customer

Reference no: EM133422828

Questions Cloud

Determine the size of the equal replacement payments : Diana has to settle a debt, for which scheduled debt payments of $3800.00 was due seven months ago, $4700.00 was due two months ago, and $8800.00 due in five

Difference between psychology-anthropology : What is the difference between Psychology, Anthropology, and Sociology? What does each of them study? Can one exist without the other?

How did amazon use process design : how did amazon use process design? what type of processing did they use ? did they use technology innovation ? what kind kd automation did they use ?

Would we expect gasoline inelasticity to differ between : Consider that although the demand for gasoline is generally inelastic, the demand for gasoline from any single gas station, or chain of gas stations

Identify and fully document the database data requirements : identify and fully document the database data requirements for the project. The database must be able to store information about

What is science behind junk food pretending to be real food : What is the science behind junk food "pretending to be real food"?

Explain firm behaviour in monopolistic competition market : Explain the firm behaviour in the Monopolistic competition market.

Identify the highest converting goals : Identify the pages with the highest bounce rates. Identify the page with the highest exit rate and Identify the micro-converting landing page

Compare vitro and in vivo models of secondary haemostasis. : Describe the routine tests for the assessment of secondary haemostasis and include the possible sources of error. Comment on the patient's laboratory results.

User Account

All Pages