a little help? Functional Dependencies
Date: 28 Nov 2003 15:40:48 GMT
Message-ID: <20031128104048.11680.00000945_at_mb-m22.aol.com>
Unified Hire Service hires out equipment for building repairs and alterations, decorating, gardening, etc. Charges for items are based on the number of days of the hire. There is a basic daily charge for each item, with a discounted rate for a one-week hire, and a surcharge daily rate for items kept longer than specified in the initial hire agreement.The "Return Date" is the date the item is due to be returned.
When payment is made in cash an additional deposit of £50 is required before any item is issued. If all items are returned on or before their due date this is refunded, otherwise it is used to cover some or all of the surcharge for extra days. When payment is made by credit card no deposit is required, but the customer signs an open payment slip, which is completed when all items have been returned.
The old manual system is to be replaced by a relational database system. This
must include the following attributes (you may wish to include other relevant
attributes):
" Date
" Hire number
" Branch No
" Branch Name
" Branch Address
" Staff ID
" Staff Name
" Customer Number
" Customer Name
" Customer Address
" Customer Postcode
" Item Number
" Item Type
" Type Description
" Daily Charge
" Weekly Charge
" Daily surcharge
" Issue Date
" Due return Date
" Actual Return Date
" Item Cost
" Item Surcharge
" Advance Total Cost
" Final Total Cost
Now ive got to list the functional dependencies... This is what i have so far... anyone give me any pointers hints? Thanks in advance. Jen x
Functional Dependencies
Staff ID --> Staff Name, Staff Address
Branch No -->Branch Name, Branch Address
Customer Number --> Customer Name, Customer Address, Customer Postcode,
Customer Tel No,
Item Number --> Item Type, Type Description, Item Cost, Item Surcharge,
Item Cost --> Issue Date, Due return Date, Daily charge, Weekly charge,
Item Surcharge --> Due return Date, Actual return date, Daily Surcharge,
Deposit --> Payment Method,
Refund Total --> Deposit, Item surcharge,
Advance Total Cost--> Deposit, Item Cost, Quantity,
Final Total Cost--> Refund Total, Advance Total Cost,
Assumptions made:
" Type description refers to Item Type description
" Item Charge depends on if it was hired by the day/week and if over due
" Quantity - there might have been more than one tool type e.g. customer
might have wanted to hire 2 paste brushes
" Daily surcharge is the daily surcharge of the item and item surcharge
is the total surcharge for the item.
Received on Fri Nov 28 2003 - 16:40:48 CET