Client Billing--New Assumptions
ClientID PartnerID Date/Time Item Description Hours AmountBilled
115 963 8-4-97 10:03 967 Stress analysis 2 $500
295 967 8-5-97 11:15 754 New Design 3 $750
115 963 8-8-97 09:30 967 Stress analysis 2.5 $650
More realistic assumptions for a large firm.
Each Partner may work with many clients.
Each client may work with many partners.
Each partner and client may work together many times.
The identifying feature is the date/time of the service.
What happens if you do not include Date/Time as a key?