Database Answers Online Gaming
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Suggestions Schemes 
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.? 
Barry Williams
August 19th. 2011
Principal Consultant
Database Answers
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map