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

Options: ReplyQuote


Subject
Written By
Posted
General design time question
January 09, 2015 07:13AM
January 11, 2015 03:42PM
January 12, 2015 06:26AM


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.