Consider the following table: ID | Name | Item | Price | Quantity. Explain primary key, normalization, and 1NF in relation to this table.

Does the table contain an entire primary key? Explain your answer. Yes, the table contains a primary key. The No column uniquely identifies each record in the table, as each value from 1 to 20 appears only once.

The General Sales table is not normalized. Give two explanations for this, in the spaces below. Reason 1: Data Redundancy. Customer names (e.g., "Gabriel Kome") and item details (e.g., "Spanner" with "900" unit price) are repeated across multiple rows, leading to inefficient storage and potential inconsistencies. Reason 2: Update Anomalies. If a customer's name or an item's unit price needs to be changed, it would require updating multiple records. Failing to update all instances would result in data inconsistency.

Give a reason why the table is in 1NF. The table is in First Normal Form (1NF) because all attributes (columns) contain atomic values, meaning each cell holds a single, indivisible piece of data, and there are no repeating groups of columns.