Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
The development of an e-commerce website using php and mysql. It covers the system architecture, including the use of the mvc (model-view-controller) design pattern in laravel, the database design using an entity relationship diagram (erd), and the implementation of various use cases such as user registration, product management, and shopping cart functionality. The document also includes wireframes, screenshots of the web application, and a discussion of the advantages and future improvements of the website.
Typology: Thesis
1 / 47
This page cannot be seen from the preview
Don't miss anything!
Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Semi Project Submission date Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Student ID Class Assessor name Ngo Thi Mai Loan Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature Grade
Grade: Assessor Signature: Date: Signature & Date:
1.1.Operational Users can use it directly on browsers such as Google Chrome/Firefox/Microsoft Edge/Coc Coc/.... The platforms are usable on Windows, MacOS, Kali and even Android and IOS can be used as long as the devices are connected to the internet and have a browser. The screen will display in sizes with large - medium and small sizes to fit any device. The system is built on PHP platform and MySQL database. Only Website. Google Chrome / Firefox / Microsoft Edge /… MacOS / Android / Window / … 1.2.Performance Capacity: 1000 People accessing at the same time Allows users to connect, access the website with 1000 at the same time. Up to 1ms latency, performance will be optimized to bring the smoothest possible experience to the user. 1.3.Security The system will be firewalled through the cloud by Cloudflare and can use HTTPS/SSH and MFA security styles for authentication. In this website platform, all user information will be completely secure and encrypted. To ensure that the system does not experience security problems, the entire system will be continuously updated once a week at 02:00 - 04:00. During the update period, users can still access products normally but cannot pay for orders. HTTPS/SSH MFA Cloudflare 1.4.Political Culture The system will use the main language is English. However, there will be a foundation to help the translation system into Vietnamese. Currency used: Vietnam Dong Payment: VISA/Momo/Mastercard (use QR Code) Website policies will be updated not based on sexist, racist rules. QUACH CONG TUAN – BHAF Color: #303030 - #ff5f17 - #f5f5f Licensed trademarks: Local Brand
Figure 1 Use Case Diagram 1
“Are you sure you want to sign out of this device?” Message when the actor clicks the Log out button. MS
#UC01: Logout Name Log out Code UC Description Allow the actor to logout the account from the system Actor Admin/ Customer Trigger Actor presses log out button Pre-condition Actor has successfully logged into the system. Post condition Go to login page. Activities Actor System Main Flow: Log out successfully 1 Actor clicks on Logout button on profile management page 2 Confirm logout then go to the Log in page System Message
#UC02: Edit Account/Username Name Edit Username/Account Code UC Description Allow the actor to edit the account (eg: username, ...) Actor Admin/ Customer Trigger Actor presses done button Pre-condition Actor has successfully edited the account Post condition Go to admin manage user page. Activities Actor System Main Flow: Edit User Successfully 1 Actor clicks on Logout button on profile management page 2 Confirm logout then go to the Log in page
#UC04: View Products Name View products Code UC Description Allow actor to view product details Actor Admin/ Customer Trigger Actor clicks on the product Pre-condition Post condition Go to product detail page Activities Actor System Main Flow: View product 1 Click on the homepage button 2 Load product on the shown product page 3 Click on the product you want to see details 4 Load into product detail page
#UC05: View Product Detail Name View Product Detail Code UC Description Allow the actor to view product detail on the system Actor Admin/ Customer Trigger Actor presses buy now button Pre-condition Post condition Go to Product Detail pages Activities Actor System Main Flow: View product detail 1 Actor clicks on product button in product page 2 Load product detain on the shown product detail page 3 Click on the button to add to cart 4 Load into cart page
II. System Designs
Link Sitemap: https://www.gloomaps.com/GeR2qNQxV Figure 3 Sitemap
Figure 4 ERD
2.1.4. Color Field Name Data Type Constraint Explanation ColorID Int Primary Key Auto Increment ID of Color Color Varchar(255) Not Null Color name Description Text Not Null Description for color 2.1.5. Size Field Name Data Type Constraint Explanation SizeID Int Primary Key Auto Increment ID of size Size Varchar(255) Not Null Size name Description Text Not Null Description for size 2.1.6. Product Field Name Data Type Constraint Explanation ProductID Int Primary Key Auto Increment ID of product ProductName Varchar(255) Not Null Product name Price Int Not Null Price of product Category Int Foreign Key Category of product Color Int Foreign Key Color of product Description Text Not Null Description for product Images File Upload Not Null Images of product Images2 File Upload Not Null Sub-Images of product Images3 File Upload Not Null Sub-Images of product Images4 File Upload Not Null Sub-Images of product Images5 File Upload Not Null Sub-Images of product
2.1.7. Detail Field Name Data Type Constraint Explanation DetailID Int Primary Key Auto Increment ID of detail (table connect between product and size) ProductName Int Foreign Key ID product/ProductName Size Int Foreign Key ID size/Size 2.1.8. Cart Field Name Data Type Constraint Explanation CartID Int Primary Key Auto Increment ID of detail (table connect between username and detail) Username Varchar(255) Foreign Key Username of user DetailID Int Foreign Key DetailID of detail
