Information Systems and Control

Describe the significance of the symbols used to denote primary and foreign keys in a database diagram.

What happens if a record in the primary table is deleted while matching records exist in the foreign table?

How do primary keys and foreign keys relate to each other in a relational database?

Explain the importance of maintaining referential integrity in a database.