Answer the question
In order to leave comments, you need to log in
Company database, right?
I want to ask if I did it right? and how to implement the last three points can you tell me? or give advice
There is a Сompany and Employees of this Company
The Company could be located in one or several cities, in one or several buildings. The company can occupy the whole building or just a part of a building.
Employees have some Positions in a Company
Employees have a Contract
An Employee can be Promoted periodically
An Employee passes Assessment procedure once a year. As a result of Assessment, he/she could be either promoted or not.
At each Company's location there must be at least one Employee with “Fire-protection safety” role.
Answer the question
In order to leave comments, you need to log in
is it right?No.
Company could be located in one or several cities, and you have one.
I don't quite understand whyCorrectly:
City (ID, Name),
Building (ID, City (FK City), Name),
Location (ID, Building (FK Building), Company (FK Company), Name)
can you help with the last three points?Maybe my English is bad, but
An Employee passes Assessment procedure once a year.there is no certainty: is there a certain period of verification or the next verification is not less than a year later.
Employees have a ContractContract for a person or position?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question