[Help] How to create database for control Process in manufacturing company
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Dear all, Currently, I need to create a database for control Process in manufacturing. One Item have got many LotNo, One LotNo thought many Process(ex: Process A, Process B,Process C...) with every Process maybe yes or maybo no use Material How can I build database for: Select all Lot no and Process by ItemNo Slect all Process and status in every Process by LotNo Input ItemNo show all information about Material used on every Process This is my database:
Item(Id_Item,ItemNo,ItemName)
Lot(Id_Lot,Item_Id,LotNo)
Process(Id_Process, ProcessNo, ProcessName)
Lot_Process(Id,Lot_Id,Process_Id)
Material(Id,Process_Id,MaterialName, Quantity)