Answer the question
In order to leave comments, you need to log in
What is the best way to design a R-model of a database in this situation?
Good day everyone!
There is a small snag on how best to design a R-model for entities that are PC components and that are stored in a warehouse.
As an example, there are 4 entities - CPU Model, RAM Model, Disk Model and the warehouse itself (other models will be omitted).
Each of them has specific parameters, so I do not see how to generalize this into one general entity.
Example #1 (composite key circled in red) blue attributes - foreign key:
Answer the question
In order to leave comments, you need to log in
Entity and relationship table
The table describes EQUIP, which has a CPU, which is also described in a separate table, so a link to a line in that table. That's relational relationships.
If you need to describe the warehouse, add WAREHOUSE_ID - a link to the warehouse table
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question