Advantages of related tables in a Database


☞ Prevent data redundancy.

☞ Restricts the user from entering invalid data in the referenced fields.

☞ Prevent missing data by keeping deleted data from getting out of synchronise. This is called referential integrity.

☞ Any update in the master table is automatically reflected in the transaction tables.