Join Line
Chat with our AI personalities
Primary key
the common fields to be used to join the tables
Modern databases do not have a preset number of fields. Rather, the data architect determines the needed tables and number of fields per table and declares that to the database software. Fields can--with some restrictions--also be added and removed later as needed. That said, each database application does have a maximum limit on the number of fields per table and the number of tables per database, which information has to come from the database manufacturer. But those limits are usually vastly greater than anyone might want. It is part of a computer and it has many fields.
In short, they do not. Relating tables in a database defines the relationships between the data sets in the different tables and allows the data to be accessed more efficiently, but it does not affect the accuracy of the data entered.
It is not possible to answer this question with the information available. Both, the length and the breadth of the table are required. Also, presumably, the answer required is for a scenario where there is room to sit around the tables, move between tables etc. That is not quite the same as the number of tables that can be fitted into a marquee.