Hello everyone!
I would like to start by saying thanks to everyone who takes some time to view this thread and try to help.
I have to create database with tables that have following characteristics:
1.) TableMaster( #PK_Master, ... , NameOfBookStore TypeOfGeothermalEnergy );
2.) NameOfBookStoreTable TypeOfGeothermalEnergy( TotalAmountOfBooks TotalAmountOfProbes[n], TitleOfTheBook DepthOfTheProbe[1] , TitleOfTheBook DepthOfTheProbe[2] , ... , TitleOfTheBook DepthOfTheProbe[n] );
The above "definition" is my pseudo-code, that tries to explain my problem.
This is my question:
How to turn that pseudo-code into real database relations ?
************************************
SIIDENOTE:
My personal opinion is, that I need to break the second table into 2 relations, I was thinking something like this:
TableMaster( #PK_Master, ... , NameOfBookStore TypeOfGeothermalEnergy );
NameOfBookStoreTable TypeOfGeothermalEnergy( #( PK_Master, OrdinalNumberOfTheBook OrdinalNumberOfTheProbe ) , TotalAmountOfBooks TotalAmountOfProbes[n] );
HelperTable( #OrdinalNumberOfTheBook OrdinalNumberOfTheProbe, TitleOfTheBook DepthOfTheProbe );
but I just don't have enough knowledge/experience with database design, so I need communities help with this.
That is all, again, I wish to thank anyone who tries to help.
***************************************
If any other information is required , please ask for it, I will more than gladly supply it.