P
P
Paul Fawkes2019-06-14 17:59:03
Database design
Paul Fawkes, 2019-06-14 17:59:03

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.

5d03b635139ef860415776.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-06-14
@tsklab

is it right?
No.
For example,
Company could be located in one or several cities
, and you have one.
And don't forget about the physics model: the building is in the city, not the other way around.
I don't quite understand why
Correctly:
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.
A model: Person, Position, Contract, Employee, Check.
Yet again
Employees have a Contract
Contract for a person or position?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question