Back to the Data Model
Subject: to make datamodel
Question: A company wants staff help to improve operations.
The staff are invited to submit suggestions for improvements.
Good suggestions will be rewarded with money.
The company is divided into sections, leaves another's finance department,
HR department and sales department.
A department can have many employees, but an employee can only belong to one department.
Employees can submit suggestions for improvements in some areas.
Some examples of activities can be safety, environment and human well-being.
A unique proposal can only belong to a business, a business can have several suggestions.
Any good suggestions are rewarded with money.
A unique proposal can only be rewarded with a reward once.
l a reward occurs at a certain date and approved by the head of someone on staff, each unique reward,
only to make a unique proposal.
An employee may submit multiple proposals, the proposal may be submitted by several employees.
If three people are sitting and talking during coffee breaks, and along comes a good proposals that
generate 9000 Dollars the reward must be had in the data model to ensure that there are three people
who will share the reward.?
August 19th. 2011