need suggestions for data model

Sybrand Bakker · *nix forums Guru Joined: 03 Apr 2005 Posts: 1766

On 7 Jul 2006 12:26:55 -0700, soalvajavab1@yahoo.com wrote:

soalvajavab1@yahoo.com · *nix forums beginner Joined: 17 May 2005 Posts: 2

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.

PLEASE ADVICE YOUR PROPOSAL...Many Thanks

Google