Identify Primary and Foreign Keys

The figure given below shows four tables, when a customer orders items, an invoice is stored in

the invoice table and all the products ordered are stored in the Invoice Line Item table. From the

provided list of database tables below, identify the most appropriate primary key for each table.

Justify your selection by explaining how it ensures the uniqueness of records and supports

relational integrity.

Identify the foreign keys in these tables, ensuring that they correctly establish relationships

between the tables. Explain how these foreign keys enforce referential integrity within the

database.

Identifying Indexes

Choose at least two tables from the list and determine where indexes would be most beneficial.

Provide a brief explanation for each index you create, focusing on its expected impact on

database efficiency.