Assignment
Requirments
You are required to design an ER Model in MySQL Workbench for the provided case.
The ER Model should account for all data that is presented in IMS-1 through IMS-6
[This part is done, the result is the "File1", and based on the "File1", the problems in below should be solved.]
Requirements:
- Identify all the necessary check constraints
- Identify and show at least 3 triggers that would be helpful
- Identify and show examples of at least 3 transactions based on your database design and provided case
- Identify and design a minimum of 4 VIEWS that would be helpful in presenting data as shown
- Implement the database from ER model with:
o All of the check constraints
o All of the triggers
o All of the views
-Design Bute, Shipping List (Purchase Order), Inventory Report Ex) QIS QOO QOB, and etc..
o Perform the necessary insert records in the tables
o Demonstrate the transactions.
Attachment:- Files.rar