Procurement Management System
INFORMATION SYSTEM FOR MANAGERS
Report
Procurement Management System
Submitted by:
Ishita Anand
Rashima Sharma
Punya
Priyanka Malhotra
Prinsu Panda
Abhishek Shah
Rahul Gupta
Anurag Singh Acknowledgment
We would like to sincerely thank Mr. Venkateswara Rao for introducing us to a novel concept as well as giving us the much awaited opportunity to make this project. It was an interesting project, and also enabled us to appreciate the various theoretical concepts of DBMS.
We thank him for his constant guidance and active support throughout the preparation of the project. Table of Contents
Scope of the Project 4
Organization and Its Working 4
The existing system of functioning 4
The Processes Followed in the Company 5
Drawbacks of the Existing System 6
PROPOSED PROCUREMENT MANAGEMENT SYSTEM 7
Entity Relationship Diagram 7
Entities in the MIS: 8
Normalization 14
Analysis of Entity Relationship Diagram 16
The various associations with cardinalities are as follows 17
E-R Diagram of the Procurement Management System through MS-Access 20
E-R Diagram of the Procurement System through MS-Visio 21
Forms 22
3. Inventory Info Form: This form allows for easy access to store inventory information for each product and their respective valuation. 24
4. Purchase Order Info Form: This provides the complete information regarding the products that have been purchased, which site has purchased, the supplier, quantity, unit costs, transaction ids etc. 25
5. Site/Supplier Form: This form provides the info regarding how many suppliers have been supplying to a particular site and their respective ids and names. 26
6. Supplier Info Form: This form shows with which suppliers the company is currently dealing with. The suppliers can be added and edited or deleted also. 27
Queries 27
Reports 31
Anticipated Benefits of the New System 34
Conclusion 35 INTRODUCTION
Scope of the Project
The Project intends to propose an MIS for an engineering
Report
Procurement Management System
Submitted by:
Ishita Anand
Rashima Sharma
Punya
Priyanka Malhotra
Prinsu Panda
Abhishek Shah
Rahul Gupta
Anurag Singh Acknowledgment
We would like to sincerely thank Mr. Venkateswara Rao for introducing us to a novel concept as well as giving us the much awaited opportunity to make this project. It was an interesting project, and also enabled us to appreciate the various theoretical concepts of DBMS.
We thank him for his constant guidance and active support throughout the preparation of the project. Table of Contents
Scope of the Project 4
Organization and Its Working 4
The existing system of functioning 4
The Processes Followed in the Company 5
Drawbacks of the Existing System 6
PROPOSED PROCUREMENT MANAGEMENT SYSTEM 7
Entity Relationship Diagram 7
Entities in the MIS: 8
Normalization 14
Analysis of Entity Relationship Diagram 16
The various associations with cardinalities are as follows 17
E-R Diagram of the Procurement Management System through MS-Access 20
E-R Diagram of the Procurement System through MS-Visio 21
Forms 22
3. Inventory Info Form: This form allows for easy access to store inventory information for each product and their respective valuation. 24
4. Purchase Order Info Form: This provides the complete information regarding the products that have been purchased, which site has purchased, the supplier, quantity, unit costs, transaction ids etc. 25
5. Site/Supplier Form: This form provides the info regarding how many suppliers have been supplying to a particular site and their respective ids and names. 26
6. Supplier Info Form: This form shows with which suppliers the company is currently dealing with. The suppliers can be added and edited or deleted also. 27
Queries 27
Reports 31
Anticipated Benefits of the New System 34
Conclusion 35 INTRODUCTION
Scope of the Project
The Project intends to propose an MIS for an engineering