SupplyChainDB

Supply Chain Database

ERD

ToDo

• Admin User creation
• Create Tables
• Insert test data
• Create views
• Create reports

Views :

• ACTIVE_SUPPLIER;
• APPROVAL_WITH_EMPLOYEE
• APPROVAL_WITH_SUPPLIER
• CUSTOMER_PROGRAM_EMPLOYEE
• CUSTOMER_PROGRAM_INVOICE
• CUSTOMER_PROGRAM_PART
• EVALUATION_STATS_EMPLOYEE
• EVALUATION_STATS_SUPPLIER
• INVENTORY_FLOW_STATUS
• PART_APPROVAL_SUPPLIER
• PROJECT_BY_CUSTOMER

Stored Procedures

• Approval Chances By Supplier
• Employee Evaluation
• Approval of Part By Supplier with Employee

Triggers

• REGION_BEFORE_INSERT
• ZIP_BEFORE_INSERT

Function

• Generate Full Address from columns