Be precise. Give me table names, attibutes with its datatypes and which flavor of SQL you are using. And the god damn database you are building the trigger on.

Hi meek_misfit, thanks a lot for ur willingness to help.

Business rules

1. A customer can rent up to maximum five videos at any one time (allow no more than five checked out videos at any time)
2. Late return penalty is $2 each day late. The fine should be automatically calculated and added to the balance.(this balance here means the fine balance, we do need to worry about customer total balance)
3. No rental is allowed if a customer's unpaid balance fine exceeds $15

I need three triggers to satisfy the above business rules. thanks a lot once again.

Branch

No Partial Dependencies

          No Transitive Dependencies:

Staff

No Partial Dependencies

Transitive Dependencies: Salary is Dependent on Position

Video

Transitive Dependencies: Status, Title, Actor & Director is dependent on Rental_No.

Category

             Rental Description                

No Partial Dependencies

Transitive dependency

Rental Detail

No Partial Dependency

B.C.N.F Dependency

Rental

Customer

Transitive Dependencies: LName, FName, Address & Telephone are dependent on Customer_ID