Hello...
This is not an Oracle specific question... And i am almost ashamed to ask it... But here it comes anyway
I have a Database (doh...) It contains several "Objects" (1 Object Type = 1 Table)
I need to extend several (5-6) of those objects with a set of "common properties". I wanted to implement this set of Properties in their own table. This tabe should be refferenced by the other Objects by a foreign key to the new table...
Lets look at a (simplified) example: Order - Address
I "wanted" to do:
Order Table
--------------
Order_ID (PK)
Shipping_Address_ID (FK)
Billing_Adress_ID_Address_
ID (FK)
...
Customer Table
------------------
Customer_ID (PK)
Home_Address_ID (FK)
Name
...
Address Table
-----------------
Address_Id (PK)
Street
....
Now the allmighty custumer decided that this would be an odd approach... He favors this kind of design(Keep in mind its a common set of properties over a whole bunch of tables... Not just 2 like in this example):
Order Table
--------------
Order_ID
Shipping_Street
...
Billing_Street
...
[rest of Order]
Customer Table
------------------
Customer_ID
Name
Home_Street
...
[rest of Custumer]
Address Table
----------------
DELETED
Now...
I know the 2nd design is so WTF that i was so confused when it was suggested, that i have no clue to argument against this besides, that it will make the Software a lot harder to maintain, I need to write tons of redundent code which will cause the project to go over budget, and that you "just dont do it"
But what i need now are some clean and rational resons why this sucks... My Project Lead told me i might not quote Budget as a valid reason :)
So feel free to post :)
Start Free Trial
