Revision history [back]

One approach could be to use a relational database model with multiple tables connected by foreign keys. Each set of information could be stored in a separate table with a primary key that links it to the main table representing the row of the table. Then, using a JOIN query, the information from each table can be combined and presented in a single row of the table. Alternatively, if the different sets of information are of the same or similar data type, they could be stored in separate columns of the main table, with the corresponding values entered for each row.