I need advice on how to design a database -
I currently have three objects:
Service
Agreement
Contract
Any of the objects can be made up of any of the other objects.
Ex.
Service A is made up of:
- Agreement 1
- Contract I
Agreement 1 is made up of:
- Service B
- Agreement 2
- Contract II
Service B is made up of:
- Contract III
- Contract IV
The types of objects can change.
I want to add the new object Warranty
Now:
I have for objects:
Service
Agreement
Contract
Warranty
Service A is made up of:
- Agreement 1
- Contract I
- Warranty a
...
What are some goods DB designs for this type of data?
They type of queries I will be wanting to perform would be:
If I make a change to Warranty a, list all the objects that will be affected.
Thanks for your input!
Thanks,
Gabe
I currently have three objects:
Service
Agreement
Contract
Any of the objects can be made up of any of the other objects.
Ex.
Service A is made up of:
- Agreement 1
- Contract I
Agreement 1 is made up of:
- Service B
- Agreement 2
- Contract II
Service B is made up of:
- Contract III
- Contract IV
The types of objects can change.
I want to add the new object Warranty
Now:
I have for objects:
Service
Agreement
Contract
Warranty
Service A is made up of:
- Agreement 1
- Contract I
- Warranty a
...
What are some goods DB designs for this type of data?
They type of queries I will be wanting to perform would be:
If I make a change to Warranty a, list all the objects that will be affected.
Thanks for your input!
Thanks,
Gabe