Hello.

Help, pliz, advice. I decided to create a database in aktsessse. This is my first base (learning). The task before me is this. Car arrives at the technical center. Repairs produce several locksmiths (one-to-many connection), in turn, they repair several nodes of the car. Look at the screen and tell me, pliz, did I create the tables correctly or maybe something else to add?

alt text

  • @Amangeldi, If you are given an exhaustive answer, mark it as correct (click on the check mark next to the selected answer). - Vitalina

1 answer 1

  1. Maybe it does not interest you, but the cost of the work must also be somehow taken into account (in the left table).
  2. I would connect the second table on the right of the workers employed in the outfit not with the attire (this is a mass grave for them: how then to take into account the work of each?), But with the second table from the left (much to much), unleashing this connection with an intermediate table.
  3. I do not know about the versatility of repairmen (after all, a motor mechanic and a body builder are different qualifications).