Designing a logical data model for a sales and inventory management system
Mahat, Hari Krishna (2013)
Mahat, Hari Krishna
Turun ammattikorkeakoulu
2013
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-201402112200
https://urn.fi/URN:NBN:fi:amk-201402112200
Tiivistelmä
The aim of this thesis was to design a Sales and Inventory Management System (SIM), that is, a database describing the customer orders and products distributed by the company.
The SIM system shall help in the management of product sales and processing, inventory management process and operation outside the book-keeping system already in use. The SIM system shall be based on a Database Management System. The purpose of the SIM database system is to maintain the data that is used and generated from the warehouse staff and sales staff. Then the data stored will be used to facilitate smooth running of sales operation and stock management. The sole aim and objective of this thesis was to create a logical data model independent of Relational Database Management System for Sales and Inventory Management System.
All the data generated during the business process was studied to design a very well functioning database that will comfort the growth of company. Sales staff and warehouse staff were interviewed, in total 11, on their needs and requirements. These needs and requirements were given high importance throughout the design process. A system independent logical database design was produced from this project work.
The data dictionary, ER diagrams, conceptual data model, high level data transaction details, data flow diagrams and logical data model are the outcome of this project work.
The SIM system shall help in the management of product sales and processing, inventory management process and operation outside the book-keeping system already in use. The SIM system shall be based on a Database Management System. The purpose of the SIM database system is to maintain the data that is used and generated from the warehouse staff and sales staff. Then the data stored will be used to facilitate smooth running of sales operation and stock management. The sole aim and objective of this thesis was to create a logical data model independent of Relational Database Management System for Sales and Inventory Management System.
All the data generated during the business process was studied to design a very well functioning database that will comfort the growth of company. Sales staff and warehouse staff were interviewed, in total 11, on their needs and requirements. These needs and requirements were given high importance throughout the design process. A system independent logical database design was produced from this project work.
The data dictionary, ER diagrams, conceptual data model, high level data transaction details, data flow diagrams and logical data model are the outcome of this project work.