4
4
441bed98-4948-48de-b87f-52017-01-21 20:15:10
Database design
441bed98-4948-48de-b87f-5, 2017-01-21 20:15:10

How to properly partition a relational database table?

It is necessary to store information about the components of the optical passive network in the database. Components are divided into 2 categories active and passive. Depending on the type of component, characteristic attributes differ. There are tables with relationships Components(id (PK); idProperties (FK) ), Properties (id (PK); idComponentType (FK)), ComponentTypes (id (PK)). The Properties table stores the characteristics of the components for active and passive at the same time, because of this there are many NULL fields. I would like to divide this table into ActiveComponentProperties and PassiveComponentProperties. But it is not entirely clear how then to link them to the Components table. Would love to see advice on how to do this.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Skorzhinsky, 2017-01-23
@AndyKorg

An example structure might look like this1b26046e62be4d468772bd27494d05a9.JPG

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question