Is it possible to make such a connection as in the table "Brigade"

If I make a database in MS SQL Server using this scheme, will it be correct to make such a connection as mine from the “Crew” table?

  • It is impossible to say something on the model, not seeing the formulation of the problem. Those. without knowing what will happen with the system. In general, the table of managers looks strange separately from the workers. If a person was an ordinary worker and became a foreman, should he be removed from one table and inserted into another? And the system does not assume that there is a certain warehouse, everything bought is shipped immediately to the brigades. And if a batch of drills is purchased and they are divided between all the brigades, you will start this purchase separately for each brigade, breaking it into pieces. Oh, and the drills from the physicist bought - Mike
  • I mean, is it possible that several external keys are formed from one primary key - Danil
  • Sure you may. just to this place of your scheme no complaints - Mike

0