Answer

Solved Step By Step with Explanation :  Explain What Primary And Foreign Keys Are And They Relate To Referential Integrity

Primary keys and foreign keys are both used in relational databases to establish relationships between tables and ensure referential integrity.

The benefits of normalization include:

Reduced data redundancy: By eliminating redundant data, normalization helps to conserve storage space and reduces the chances of inconsistencies and errors.

You would need to use an inner join when you want to retrieve data from multiple tables based on their shared values. It allows you to combine related data from different tables into a single result set. Inner joins are useful for querying data that is distributed across multiple tables and requires consolidation for analysis or reporting purposes. In an inner join, the result set includes only the rows that have matching values in the joined columns. Any unmatched rows or data from either table will not be included in the result set. Inner joins help to establish relationships between tables and retrieve data that satisfies specific criteria or conditions.