Hi meek_misfit, thanks a lot for ur willingness to help.
Business rules
- A customer can rent up to maximum five videos at any one time (allow no more than five checked out videos at any time)
- 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)
- 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_ID |
Branch_Address |
Branch_Telephone |
Branch
No Partial Dependencies
No Transitive Dependencies:
Staff
|
Staff_ID |
Branch_ID |
LName |
FName |
Address |
Salary |
Position |
No Partial Dependencies
Transitive Dependencies: Salary is Dependent on Position
|
Staff_ID |
Branch_ID |
LName |
FName |
Telephone |
Address |
Position |
|
Video_ID |
Catalog_ID |
Branch_ID |
Rental_No |
Status |
Cost |
Title |
Actor |
Director |
Video
Transitive Dependencies: Status, Title, Actor & Director is dependent on Rental_No.
|
Rental_No |
Status |
Title |
Actor |
Director |
|
Video_ID |
Catalog_ID |
Branch_ID |
Cost |
Category
Rental Description
|
Rental_Code |
Description |
Rental_Fee |
No Partial Dependencies
Transitive dependency
Rental Detail
|
RD_No |
Rental_No |
Video_ID |
Due_Date |
Return_Date |
No Partial Dependency
B.C.N.F Dependency
|
Due_Date |
Return_Date |
Rd_No |
Rental
|
Rental_No |
Rental_Date |
Customer_ID |
Customer
|
Customer_ID |
LName |
FName |
Address |
Telephone |
Date_Of_Reg |
Balance_Due |
Branch_Id |
Transitive Dependencies: LName, FName, Address & Telephone are dependent on Customer_ID
|
Customer_ID |
LName |
FName |
Address |
Telephone |
|
Customer_ID |
Date_Of_Reg |
Balance_Due |
Branch_Id |
