Intro to DBMS

First Normal Form (1NF)

According to first normal form (1NF),

  • The table should not contain any multivalued attributes. It should only have single (atomic) valued attributes/columns.
  • Column names of entire tables should be unique.

Note: The primary key will be the composite key, i.e. (“Std_ID” and “Std_Course”) in the above example.