Betaaaaa PDF

Preview

Summary

Project 1SELLING COMPUTER COMPONENTSWEBSITEBIT01-K63 – Group 8Person madeNGO VAN HUY NGUYEN MINH HANG Instructor Mr. KIEU DUC HANHs - Hanoi, 12 /2019 –CONTENT1. Problem Definition**1. Problem Abstraction The Current System The Proposed System Boundaries of the System Hardware and Software Requiremen...

Description

Hanoi University of Science and Technology

Project 1 SELLING COMPUTER COMPONENTS WEBSITE

BIT01-K63 – Group 8 Person made Instructor

NGO VAN HUY NGUYEN MINH HANG Mr. KIEU DUC HANH

s - Hanoi, 12 /2019 –

Selling Computer Components

Page 1 of 25

Hanoi University of Science and Technology

CONTENT

1. Problem Definition 1.1. Problem Abstraction 1.2. The Current System 1.3. The Proposed System 1.4. Boundaries of the System 1.5. Hardware and Software Requirements 1.5.1. Minimum Requirements 1.5.2. Recommended Requirements 2. Customer Requirements Specification 2.1. Users of the System 2.2. System functions 3. System Designs 3.1. Database Design 3.2. Entity Relationship Diagram 3.3. Website structure 3.4. Algorithms 4. Checklists 4.1. Check List of Validation 4.2. Submission Checklist

Selling Computer Components

Page 2 of 25

Hanoi University of Science and Technology

1.Problem Definition 1.1. Problem Abstraction Today, when the demand for exchanging and searching information of people is increasing, almost everyone needs to equip themselves with a computer to be able to serve the individual needs of each person. Therefore, this website was born to serve the needs of each person rising to offering customers quality products and know how to protect and use in a way that results. Sales website is an exchange tool between seller and buyer. Where sellers can introduce products to buyers in need and fulfill their needs online. So just a few clicks, users were able to complete the task buyer's products. Facing the needs of individuals and businesses website design as well as the passion for web application programming. We chose the topic: "Website Selling computer Components" to be the subject of Project I.

1.2. The Current System The idea of a selling computer components online website is not new, for those who surf the web with just one click can find many websites selling computer components. For example, when you need to buy a computer components, you can go to many websites and some big websites are: https://www.hanoicomputer.vn/, https://www.anphatpc.com.vn/… However, through thorough research, we found that the above systems have the following disadvantages:  Firstly, manufacturers and authorized dealers only introduce their own cosmetics. When a customer wants to see a company's product, they mus find out through its website or go to its authorized agent, which makes it very difficult for customers to compare their products with together .  Finally, most online shopping websites have a simple interface and lack of aesthetics leading to not attracting many customers. Selling Computer Components

Page 3 of 25

Hanoi University of Science and Technology

1.3. The Proposed System The website for selling computer components built and deployed by my team can be described as an online electric supermarket. In that online supermarket, w will let component companies rent places and business methods. In short, we are not the direct suppliers of the product, we only create an intermediary environment between phone companies and customers, then each order or question will be directed directly to the corresponding carrier requested by that customer.  This new system will have the following functions:  For consumers: Creating favorable conditions for consumers to be able to evaluate and search for cosmetics of the same manufacturer or different brands, so that they can choose for themselves the right product.  For manufacturers: the website helps promote the image of the manufacturer. More important than the website is where it can sell its products in the fastest and most effective way. In addition, the focus o many firms enables each firm to capture the needs of customers for it products with other firms devising new sales strategies to compete with other brands.  Compared to the old system, this new system has overcome and added the following new functions:  Eye-catching interface, suitable for the aesthetic of many different social classes.  Search function by cosmetic type, cosmetic name, manufacturer, quick search by price.  Function allows customers to manage accounts and shopping cart conveniently Selling Computer Components

Page 4 of 25

Hanoi University of Science and Technology

1.4. Boundaries of the System  Currently, due to objective conditions, the system still has no payment function. Search function by product name is still difficult and not real accurate.  The scope of the project is to deploy in large cities, where information systems are relatively developed. Users are those who access the network. In addition, due to weak resources, limited time and inexperience, some features such as security, database design and interaction between website and users are limited.

1.5. Hardware and Software Requirements 1.5.1. Minimum Requirements Selling Computer Components

Page 5 of 25

Hanoi University of Science and Technology

Hardware

Software

Server

Client

* Ram 64 Mb

* Ram 64 Mb

* CPU 800 MHZ

* CPU 266 MHZ

* Connect Internet or LAN * Windows Server 2000

* Connect Internet or LAN * Windows 98 * IE 4.0 or firefox 1.0

* SQL Server 2000 * ISS

1.5.2. Recommended Requirements

Hardware

Software

Server

Client

* Ram 256 Mb

* Ram 128 Mb

* CPU Celeron 1.8 * Connect Internet or LAN * Windows Server 2003

* CPU 800 MHz *Connect Internet or LAN * Windows 98 * IE 6.0 or Firefox 2.0

* SQL Server 2000 * ISS

2. CUSTOMER REQUIREMENTS SPECIFICATION 2.1. Users of the System Objects of the system include: GUEST (Current customers) MEMBERS (MEMBERS) ADMIN (SYSTEM MANAGEMENT) Selling Computer Components

Page 6 of 25

Hanoi University of Science and Technology

2.2. System functions GUEST (Current customer) a. sign up Description Allow customers to register for membership of the system Input Registration form i Show:  Full name  Account  password  Email  phone number  Registration button  Login button Handling

Output Note

Customers see the login of personal information in the registration form Click the register button The system updates customers' information to the member list Registration is complete enough a customer back to home page Customers become members of the system Enter complete information to fill out

b. View product information Description Allow members to view product information in the store Input Handling Extracting information from Database Data Selling Computer Components

Page 7 of 25

Hanoi University of Science and Technology

Database connection The system shows product information:  Product code, product name, photo, price, description Close database connection Members see details about the selected product Display information on the product just clicked

Output Note

c. Search product Description Guests h à n g entering information into the search bar to search for products Input Handling The product name that customers want to search Show search bar Get information from the database Database connection If the result is received, the search results will be returned to the user If the product can not be found , the system will send a message: "No results found" Close database connection Redirecting to products that users have just searched for Notify, display results from the system Need to keep the product name are looking for

Output Note

d ) Add to cart Description Input Handling

Allow members to click on add to cart Get information from the database Database connection

Selling Computer Components

Page 8 of 25

Hanoi University of Science and Technology

Table showing product information:

Output

 Product name, photo, price, order button Close database connection Display products and order buttons and then convert to shopping cart

Note

MEMBERS Has full functions like Guest. There are also functions: a) Log in: Members use their existing account to access the site. Description Input

Allow members to log into the system For m login display:    

Handling

Output Note

Account password Login button Registration button

Enter your account and password into the login form Account checking system, password If the login is successful, return to the home page If the login is incorrect, the system will switch to the registration form Members login successfully and can use the functions provided by the system Enter the correct account registered

b) Order: Allow members to select items and save items to buy in the cart. Description

Save item and item code to cart

Selling Computer Components

Page 9 of 25

Hanoi University of Science and Technology

Input Handling

Output

Retrieve the database and save the cart that member chooses to the database. Display detail items in cart like product code, quantity, price, and total value.

c) Logout: The member exits from logging in to the website Description Input Handling

Output

Sign out of your account Open session Disable user session Return to the system's login page Display the homepage

d) Change personal information: Description Input Handling

Allow members to change the registration information Members choose to edit personal information Get information from the Database Database connection

Selling Computer Components

Page 10 of 25

Hanoi University of Science and Technology

Existing system of current member information:

Output Note

Customer name, email, password , phone number, address, correction information Click the edit information button If successful will notify "successful repair" Close database connection Bring members back to the personal information form Display personal information that has been successfully corrected User must login account

e) Payment: Description Input Handling

Allow members to create orders to proceed with product payment Members press payment to create orders Get information from the Database

Selling Computer Components

Page 11 of 25

Hanoi University of Science and Technology

Database connection The system shows product information:

Output Note

 product code, product name, photo , quantity, unit price, purchase, continue purchases  Association of Israel continue to enter information:  Customer code, Customer name, Phone number, Email, Address  Select the purchase confirmation function Close database connection The system will notify successful purchase When paying the invoice will be saved to the database

f ) Order history: Description Input Handling

Allow members to review purchase history Retrieve information from the database Database connection The system shows the purchase history: Bill Code, Product code, Price, Order date , Quantity Close database connection Show order history table from database Need to purchase product to show 

Output Note

Admin (SYSTEM MANAGEMENT) Admin has all the functions like Member (member) : In addition, Admin also has the following functions:

a) Module customer management: Selling Computer Components

Page 12 of 25

Hanoi University of Science and Technology

Description

Allow Admin to view and update customer related information.

Input

Customer Code, Customer Name, Email, Password, Address, Phone Number, Address Database connection The system displays Admin information Close database connection Administrators have 2 choices: Edit, delete If the Administrator enters the edit, the message "Repair successful" If the Administrator enters the delete, the message "Successful modification".

Handling

Output

Show customer information after update.

b) Admin management module Description Input Handling

Allow Admin to manage information of every Admin Admin Name, Email, Password, Phone Number, Permissions code, Add, Edit, Delete Database connection The system displays Admin information

Selling Computer Components

Page 13 of 25

Hanoi University of Science and Technology

Output

Close database connection Administrators have 3 choices: Insert, edit, delete If the Administrator enters an insert, the message "Add success" If the Administrator enters the edit, the message "Repair successful" If the Administrator enters the delete, the message "Successful modification". Admin will be saved to database

c) Product management module: Description Input

Allow Admin to change product information Product code, Product name , quantity, photo, price, description, order status, insert, edit, delete

Handling

Database connection The system displays the order information Close database connection Administrators have 3 choices: Insert, edit, delete

Output

If the Administrator enters an insert, the message "Add success" If the Administrator enters the edit, the message "Repair successful" If the Administrator enters the delete, the message "Successful modification". Products will be changed on database

d) Manufacturer management module: Description Input

Allows Admin to manage manufacturer information Manufacturer code, Manufacturer name, insert, edit, delete

Selling Computer Components

Page 14 of 25

Hanoi University of Science and Technology

Handling

Output

Database connection The system displays customer information Close database connection Administrators have 3 choices: Insert, edit, delete If the Administrator enters an insert, the message "Add success" If the Administrator enters the edit, the message "Repair successful" If the Administrator enters the delete, the message "Successful modification". Manufacturer information will be changed on the database

e) Order management module: Description Input

Handling

Output

Allow Admin to check and confirm order information Bill Code, Customer code, Booking time, Recipient's phone number, Recipient's address, Order status, delete Database connection The system displays the order information Close database connection Administrators have a choice: Delete If you click delete, the message "Successfully deleted" Orders will be saved on database

3.

System Designs

3.1. Database Design

Selling Computer Components

Page 15 of 25

Hanoi University of Science and Technology C Customer C

s

Address

name Customer code

Customer password 1 Email Admin code

Hav e

Admin Admin name

phone number

ber

maHD N

Email

maKH Bill

Addres s

password Phone Number

TenNguoiNhan

mber

N ĐCNhanHang

Manufa

tenNSX

Name SĐTNguoiNhan

Manufac maNSX Code

Manufacturer

1 N

Have

Product maSP maLoai maNSX tenSP

Mô tả Giá

Selling Computer Components

Ảnh

Page 16 of 25

de

Hanoi University of Science and Technology

3.2 DATA BASIS DESIGN 1. Key Primary key

Foreign key

2.

Admin panel (To store admin information) School's name Datatypes ma_admin

int

Admin code

ten_admin

Varchar (50)

Admin name

email

Varchar (50)

Email

mat_khau

Varchar (50)

Password

sdt

Char(20)

Phone Number

cap_do

tinyint (1)

Permissions Code

Table members (To store member information) Key School's name Datatypes

Primary key

Description

Description

ma_khach_hang

Int

Member ID

Ten_khach_hang

Varchar (50)

Member name

email

Varchar (50)

Email(Username)

mat_khau

Varchar (50)

Password

sdt

Char (20)

Phone number

Text

Address

dia_chi

3.

Manufacturer table (For storing manufacturer information) Key School's name Datatypes Description

Primary key

ma_nha_san_xuat

int

Manufacturer Code

ten_nha_san_xuat

Varchar (50)

Manufacturer Name

Selling Computer Components

Page 17 of 25

Hanoi University of Science and Technology

4.

Product table (For storing product information) Key School's name Datatypes

Primary key

Foreign key 5. Key

Description

ma_san_pham

int

Product code

ten_san_pham

Varchar(50)

Product name

mo_ta

Text

Describe

gia

Float

Product price

anh

Varchar(50)

Photo

ma_nha_san_xuat

Int

Product code

Bill table (To store orders) School's name

Datatypes

Description

Primary key

ma_hoa_don

int

Bill Code

Foreign key

ma_khach_hang

int

Customer's code

thoi_ gian_dat

Datetime

Booking time

ten_nguoi_nhan

Varchar (50)

Recipient's name

sdt_nguoi_nhan

Char(20)

Phone number

dia_chi_nguoi_nhan

Text

Receiver's address

tinh_trang_don_hang

int

Status

6. Key

Detailed bill (To store information products in order) School's name Datatypes

Description

Primary key

ma_hoa_don

int

Detailed Bill Code

Foreign key

ma_san_pham

int

Product code

so_luong

int

Amount

3.2. Entity Relationship Diagrams Selling Computer Components

Page 18 of 25

Hanoi University of Science and Technology

Selling Computer Components

Page 19 of 25

Hanoi University of Science and Technology

3.3. WEBSITE STRUCTURE

Website Selling Computer Components

Admin

Guest

Admin

Members

Registration

Search

See the product Customer

Search Cart

Product

See the product

Cart

Log in

Personal information

Manufacturer Orde...