B
B
B1ackGh0st2019-02-04 05:41:51
Database design
B1ackGh0st, 2019-02-04 05:41:51

How to design a database with multiple relationships?

Hello. There was a task to collect all electric communications in a DB. Since I have no experience in creating complex applications, I hit a dead end when designing a database.
My task is this:
There is a cabinet, from this cabinet multi-core cables go to other cabinets where they branch out on the terminal blocks along the cores to other cables and go to other cabinets and terminal blocks. Moreover, the number of cabinets on each branch of the main cabinet is different.
Prompt how to organize a DB or give the link to the similar project. Thank you in advance.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2019-02-04
@Rsa97

Just describe the entities that you have:
cabinet (id, number, description)
terminal block (id, cabinet_id, number, description)
cable (id, cabinet_id1, cabinet_id2, number, description)
conductor (id, cable_id, terminal_id1, terminal_id2, number , description)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question