Draw a Conceptual Data model ( You Must attache photo of First draft ERD). Data Requirements The
Question:
Draw a Conceptual Data model ( You Must attache photo of First draft ERD).
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 crea te 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.
Between order table and product table should have Order Item table connection
Reports, screens and automated queries
The following reports and screens must be created 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
Admin Account:
3 Admin User
1 Admin Manager
Admin user can create ne items and update item stock level. Admin manager got same authority as admin but also get authority to create new admin account.
Register User requirement:
First Name, Last Name, Postal Address, Email(Use as Username), Phone number(Optional), Passwords(minimum of 10 character, Combined uppercase and lowercase, special character).
Product information Includes:
Product name, Brand, Description(Max 250 Character), Price, Can be sale item, 1 image, color, Categories(Men, Women, Unisex, Children)
Product should be able to define as active or inactive.
Sale product maximum purchase amount is one per item.
For Unregistered User Shopping Cart only exist while on the website, for the registered user shopping cart last 30days.
Auditing The Art and Science of Assurance Engagements
ISBN: 978-0133405507
13th Canadian edition
Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Joanne C. Jones