General design time question
Posted by:
Zero-G. _
Date: January 09, 2015 07:13AM
Hey
I am redesigning my database. And I now came into the final thoughts.
In my existing database I do have a table, related to my customers.
Each customer has some identical fields for right side and left side:
Table:
Right_Power
Right_PowerType
Right_PowerDimension
Left_Power
Left_PowerTyle
Left_PowerDimension
So, now I thought, I could split this into two tables and generate a 1:1 relation.
Table Power:
Id
Power
PowerType
PowerDimension
Table Order:
RightPower -> Power
LeftPower -> Power
Where the table order has the fields RightPower and LeftPower and they are related to the Power Table.
This would work or course. - Could somebody give me some hints of Advantage /disadvantage to do it so!?
THX a lot - Have a nice weekend
Subject
Written By
Posted
General design time question
January 09, 2015 07:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.