Relational Database Design and Modeling for Software Engineers

0% completed

​
Solution to Exercise 2

Step 1: Check for First Normal Form (1NF)

To determine if the given table is in 1NF, we need to ensure:

  1. Each column contains atomic values (no multivalued or composite attributes).
  2. Each row is unique and identifiable by a primary key.

Given Table:

Emp_IDEmp_NameDOBAreaCityStateZip
101Alice1990-05-01DowntownNew YorkNY10001

.....

.....

.....

Like the course? Get enrolled and start learning!