I have already studied database and understand how the diagramming of this type of relationship works, but now that I am trying to implement this database using sqlite3 and python I have seen some problems. I have the following database
TheproblemisthatIhavetocreatenewtablesofEsp(U,IV,andVis)foreachoftherowsoftheMastertable.EachrowintheMastertablehasdatacorrespondingtoadayofreadingsofthreesensors.Thesesensorshaveadatareadingoftwocolumnswithdatacorrespondingtoagraph(Cartesianplanex,y).Therewouldbethreex,y(morethanathousandrows)pairsoftablesforeachrowofthemastertableIcanillustratetherelationshipasfollows Where the red highlighting will match the data that should be related.
So my difficulty is in creating the tables, because I can not create two tables with the same name, and then I would have to create the tables Esp with the nomenclature Esp_U1, Esp_U2, Esp_U3 ...? This does not seem right at all
Please tell me what to do about creation, it will be tables with very different nomenclatures. What would be the correct way to do the implementation of the relationship 1: M?