Skip to content

Latest commit

 

History

History
26 lines (19 loc) · 1.24 KB

README.md

File metadata and controls

26 lines (19 loc) · 1.24 KB

Lab Inventory Management System

📚 Description

Our Lab Inventory Database is a comprehensive solution designed to help researchers manage laboratory supplies and equipment. It focuses on tracking, organizing, and maintaining the stock of chemicals and equipment used in laboratory operations.

Key features:

  • Efficiently manages and analyzes purchase, vendor, and current stock data.
  • Connects purchase and current stock data for effortless identification of items purchased from specific vendors.
  • Enables users to evaluate vendor performance by counting purchases and identifying those with significant purchase volumes.
  • Supports advanced analysis through nested aggregation, displaying items with quantities below the average.
  • Streamlines the tracking of purchase dates from all vendors.

📸 Demo Pictures

📝 ER Diagram

MileStone 1 - ER drawio