A record is one row in a database table. It stores the values for one represented entity or relationship, while each column stores one attribute. In a product table, one record describes one product through values such as its name, description, price, and manufacturer. section 1.3
A record can include a primary-key value that uniquely identifies it. For example, product_id identifies one product record, while the remaining columns describe that product. section 1.3
Product records
The product table can contain a record for the Atomic Nose Hair Trimmer with product_id 1, price 19.99, and manufacturer Mad Inventors Inc. Additional records can be added with INSERT, including multiple records in one statement. section 1.10
INSERT INTO product (product_id, name, description, price, manufacturer) VALUES ( 1, 'Atomic Nose Hair Trimmer', 'Trim your nose hairs... of an atomic clock!', 19.99, 'Mad Inventors Inc.' );
This INSERT statement shows how values become one complete product record by matching the listed columns in order. section 1.10
