Advanced SQL Project Assignment
This is a SQL-based simulation that use triggers, stored procedures, stored functions and views to model business/production line workflow.
This project consists of 5 small programs, which are
- Configuration Tool
- Workstation Andon
- Workstation Simulation
- Assembly Line Kanban
- Working Simulation (Runner)
Configuration tool can config order amount,running interval of runner, and number of stations
Where to assemble parts
- Experienced worker : 60 seconds, +/- 10%.
- New employees : 50% longer than experienced worker.
- Very experienced (super) workers : 15% less than experienced worker.
- New/Rookie 0.85%
- Experienced/Normal 0.5%
- Experienced/Super 0.15%
Graphic representation of the part counts and status of a single workstationn
To display the status of the entire assembly line. This displays:
- Order amount
- Passed amount
- In process amount
- Number produced
- Yield
Simulation of a runner. A runner picks up all cards from the tray every 5 minutes. Runner goes to the stock room, picks up a new bin of the specific part and location on the card, and then goes to the station and replaces it with the old one.
- .Net Framework core
- Sql Server
- Visual studio
-
Execute the queries in Schema.sql file to create tables
-
Execute the queries in Functions.sql file to create stored procedures and functions
-
Execute Assembly Line to let the workers to assemble the parts
-
Execute the Runner. If the runner program is not running, the empty bin cannot be replaced
-
Execute the Workstation simulation to check how many parts are left in the bins of each station
-
Execute the Workstation Andon to monitor production status
- Sql Server- The Database used
- Winform - The UI
- .Net Core - The Framework used