Reference no: EM133422787
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.
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.
Question 1. Draw a Conceptual Data model (First draft ERD).
Question 2. Explain the Conceptual Data model ERD in plain English.
Question 3. Perform normalization process 1NF - 3NF ensure cardinality is displayed (Draw ERD each steps and explain in plain English)
Question 4. Draw Final ERD