need suggestions for data model

From: <soalvajavab1_at_yahoo.com>
Date: 7 Jul 2006 12:26:55 -0700
Message-ID: <1152300415.819573.54030_at_m79g2000cwm.googlegroups.com>



 need to produce a data model diagram with attribute names for the following scenario which include cardinalities in the diagram.

Richard's Construction has hired you to produce a data model to aid them in creating a database to store information on the houses they are working on and the people working on them.

Richard builds houses in remote communities and hires a number of workers to aid in the construction. Each worker is paid based on the number of hours they work and the position they are working on. After a certain number of hours in any week, they are paid double time for overtime. Richard is also interested in compiling reports on who worked on which house and for how long for performance statistics.

If a worker leaves before his contract is complete, he is responsible for reimbursing Richard for a portion of his travel expenses. This must be captured in the data base as well.

Richard maintains a number of houses for his people to stay in while working. These houses are eached managed by one of the senior workers whe recieves a bonus for managing the house in addition to their regular duties. The workers staying in the house are deducted a minimal amount for food and lodging from each paycheck for the number of days they spend in the house.

Richard is also worried about the utilization of his houses. He wants to be able to get reports on a regular basis showing the number of people staying in each house and a warning if the number of people in a house falls below a preset limit for a length of time.  

[Quoted] PLEASE ADVICE YOUR PROPOSAL...Many Thanks Received on Fri Jul 07 2006 - 21:26:55 CEST

Original text of this message