Tiêu đề GROUP 4 - PROJECT REPORT.docx ✅

NATIONAL ECONOMIC UNIVERSITY -------***------- GROUP ASSIGNMENT TOPIC OF GROUP 4: Development Of Database Application System For Online Sales Management At Fiin Store. Student name: 1. Nguyen Quang Anh - 11190329 2. Nguyen Quy Duong - 11196515 3. Phung The Dat - 11191013 4. Nguyen Phuong Hoa - 11191993 5. Dao Duc Minh - 11196161 6. Duong Ha Phuong - 11194193 7. Lang Duc Tam - 11194594 8. Nguyen Duc Thanh - 11194714 9. Nguyen Minh Thu - 11196421 10. Phung Minh Van - 11195747 11. Nguyen Le Van - 11195726 Class: Advanced International Business 61A Lecturer: Assoc. Prof. Dr. Tran Thi Song Minh HANOI, 2021
2 ACKNOWLEDGMENTS Computerization in management has reduced human labor, saved time, rendered high accuracy and convenience compared to manual document management as before. It narrowed the storage space, avoided data loss, automate and concretized information according to human needs. Specifically, Access, the database management system in the Microsoft Office suite for personal computers and computers running on local networks, is a very useful tool to help companies manage local data. In this report, group 4 will build a management program of Fiin Store company on Access. Regarding the origin of the data set, we were allowed to collect this dataset by the Fiin Store company through a member of the team who is a former employee at the company. We sincerely thank the Fiin Store business for facilitating our group to exploit this dataset for our learning purposes. With the knowledge learned and the research process, especially the enthusiastic guidance of the lecturer - Assoc. Dr. Tran Thi Song Minh, my group has completed our assignment. In the fulfilling process, we may make mistakes, so we are looking forward to receiving your comments to gradually improve ourselves. Group 4 sincerely thanks!
3 TABLE OF CONTENTS ACKNOWLEDGMENTS 1 TABLE OF FIGURES 3 CHAPTER 1: SYSTEM DESCRIPTION 4 1.1. Overview of Fiin Store 4 1.2. Describe the organization of the parts related to the problem 4 1.2.1. Product management 4 1.2.2. Customer information management 4 1.2.3. Order management 4 1.2.4. Shipment management 5 1.2.5. Report 5 1.2.5. Checking information 5 CHAPTER 2: DATA ANALYSIS 5 2.1. Identify entities and attributes 5 2.1.1. First entity: Customers 5 2.1.2. Second entity: Order’s informations 5 2.1.3. Third entity: Order’s detail information 6 2.1.4. Fourth entity: Products 6 2.1.5. Fifth entity: Delivery unit 6 2.1.6. Sixth entity: Shipping record 6 2.2. Describe the relationship between attributes and diagram 6 2.2.1. Entity Relationship Diagram (ERD) of Fiin Store 6 2.2.2. Business Function Diagram (BFD) of Fiin Store 7 2.2.3. Data Structure Diagram (DSD) of Fiin Store 8 CHAPTER 3: INTERFACE DESIGN AND SYSTEM INSTALLATION 9 3.1. The main interface of the program 9 3.2. Main Forms 10 3.2.1. Form “Create Order” 10 3.2.2. Form “Customer Information” 11 3.2.3. Form “Product” 11
4 3.2.3. Form “Order History” 12 3.3. Design report 12 3.3.1. Theoretical basis 12 CHAPTER 4: CONCLUSION AND DIRECTION TO THE DEVELOPMENT 14 4.1. Preliminary assessment of results received 14 4.2. Limitations 14 4.3. Direction of development of the system 15 REFERENCES 15