Ask a question from expert

Ask now

Grocery Store System Analysis - Use Cases, ERD, SQL Code, Assumptions, Architectural Design, UML Class Diagram

10 Pages858 Words472 Views
   

Added on  2019-09-23

About This Document

This report provides a detailed analysis of the system developed for a grocery store including use cases, ERD, SQL code, assumptions, architectural design, and UML class diagram.

Grocery Store System Analysis - Use Cases, ERD, SQL Code, Assumptions, Architectural Design, UML Class Diagram

   Added on 2019-09-23

BookmarkShareRelated Documents
Student NameStudent ID1Grocery Store – System AnalysisSubmitted ByCourseProfessorDate
Grocery Store System Analysis - Use Cases, ERD, SQL Code, Assumptions, Architectural Design, UML Class Diagram_1
Student NameStudent ID2IntroductionAccording to given scenario, we have to develop an application for grocery store. Mainprocesses which are involved in running a grocery store are – inventory, customer orders,supplier orders etc. The system developed for grocery store will help to maintain the inventory,customer needs, keep pricing accurate as it was difficult to maintain manually. The system willhelp to maintain customers satisfaction at the top. Here, in this report, we have to prepare usecases, ERD and implement database for the store in order to remove redundancy of data andprocess data efficiently.Use CasesAccording to above diagram, user scans the products and make the order by checking out. Thenafter check out, the payment will be processed by counting number of items and calculating priceaccordingly.
Grocery Store System Analysis - Use Cases, ERD, SQL Code, Assumptions, Architectural Design, UML Class Diagram_2
Student NameStudent ID3Adding new product into the system – When a new product enters into the store, a bar code isgenerated for each product so that bar code reader can easily scan the item. All the details of newproduct will be entered into the system by entering its cost price and price on which this productwill be sold.Update Product Details – In this scenario, user go to the option of update product details. Userscans product’s barcode and all the details of the product will be displayed on the screen. Nowuser can update any of its details and save the information.
Grocery Store System Analysis - Use Cases, ERD, SQL Code, Assumptions, Architectural Design, UML Class Diagram_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Primary and Foreign Key | Exercise Solutions
|8
|1070
|31

Business Data Management and Analytics Assignment 2022
|10
|1141
|5

Business Intelligence and Database
|21
|1939
|178

Restaurant Management System Analysis
|15
|1266
|20

Database Design and Development
|23
|2901
|133

Database Management System
|19
|2055
|397