Question

What is 1st Normal Form?

1) All non-key attributes (of composite key tables) are fully functionally dependent on the key
2) Look for: Calculated Attributes, Reference Tables and Unit Prices
3) All non-key attributes are independent of other non-key attributes
4) Each attribute is single-valued and there is a unique attribute for each entity

Answer 1

1st Normal Form (1NF) is a property of a relation in a relational database which ensures that it contains only atomic (indivisible) values and each record is unique. It requires that each column has atomic values, the values are all of the same type, each record is unique, and the order of stored data does not affect the database integrity.

Step-by-step explanation:

1st Normal Form (1NF) is the most basic level of normalization in database design which ensures that each table in the database is free of repeating groups or arrays. To satisfy 1NF, a table must meet several criteria:

• Each attribute must be single-valued and unique for each entity.
• Each column must contain atomic values, meaning that the values are indivisible and there should be no sets or lists in a single column.
• The order in which data is stored does not affect the database's integrity.
• All entries in a column must be of the same data type.
• Each table must have a primary key that uniquely identifies each row.

By ensuring that each attribute is single-valued and that there's a unique attribute for each entity, it helps to eliminate redundancy and prepare the database for further normalization.