Working With Oracle on Windows: Part 2 - Relationships (Page 3 of 7 )
Why use more than one table? Well the answer is simple. Using relational databases - i.e. a database with two or more tables related to one another) - reduces the time wasted waiting for query once executed, it is easier to manage and much easier to enter data.
The three types of relationships are as follows,
One-to-one - One record in a table is related to only one record in another table.
One-to-many - One record in a table can be related to many records in another table.
Many-to-many - One record in a table can be related to one or more records in another table, and one or more records in the second table can be related to one or more records in the first table.