Identify and show three triggers that would be helpful

Assignment Help Computer Engineering

Reference no: EM131965482

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

Reference no: EM131965482

Questions Cloud

Find information about the capabilities : Where can I find information about the capabilities, limitations, and application of VM's

Determien the payback period for both projects : Calculate the NPV for both projects. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.)

Disucss the estate and income tax ramifications : Before her death, Lucy incurred and paid certain medical expenses but did not have the opportunity to file a claim for partial reimbursement from her insurance.

Database concepts using microsoft access : Database Concepts Using Microsoft Access 1. Describe why data input validation is important.

Identify and show three triggers that would be helpful : Identify and show at least 3 triggers that would be helpful. Show examples of at least 3 transactions based on your database design and provided case.

Determine the equipments after-tax salvage value : Karsted Air Services is now in the final year of a project. The equipment originally cost $28 million, of which 75% has been depreciated.

Why do professional forensics certifications : Question: Why do professional forensics certifications have ethical standards?

How much are each of the equal payments : A debt of $4500 due in 3 years and $6000 due in 5 years is to be repaid by a single payment of $1000 now and two equal payments that are due each consecutive.

What are your known variables : What are your known variables? ( Be sure to consider whether these variables should be stated as annual values or whether they should be adustd)

User Account

All Pages