Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Database design: overloading
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Database design: overloading
Miscellaneous
Thread ID:
00351461
Message ID:
00351461
Views:
45
I am redesigning a system that currently uses two tables to record work done by a person. One table called "service" records work that is not related to a piece of equip. The other table is called "summary" for work done on equip. Tables are almost identical. I was thinking of combining these and setting the foreign key to the equip table to be null if the work does not relate to a piece of equip.

Does this violate good relational design? I have heard the term "overloading" but can't find any references.
Next
Reply
Map
View

Click here to load this message in the networking platform