Question

Which of the following relations is in 1st Normal Form (1NF)?

A. Pilot(PilotID, Name, Address, Phone Numbers)
B. Pilot(PilotID, Name, Date of Birth, Gender).
C. Student(StudentID, Courses).
D. Employee(EmployeeID, Name, Skills).

Answer 1

The correct answer is Option C. Student(StudentID, Courses) is in 1st Normal Form (1NF).

Step-by-step explanation:

The relation that is in 1st Normal Form (1NF) is option C. Student(StudentID, Courses).

In first normal form, each attribute in a relation must contain only atomic values, meaning that it cannot be further divided into smaller pieces. The other options do not meet this requirement.

For example, option A. Pilot(PilotID, Name, Address, Phone Numbers) violates 1NF because the 'Phone Numbers' attribute contains multiple phone numbers, which is not atomic.

Option B. Pilot(PilotID, Name, Date of Birth, Gender) also violates 1NF because 'Date of Birth' contains multiple pieces of information (day, month, year), which should be separated into individual attributes.

Option D. Employee(EmployeeID, Name, Skills) does not meet 1NF because 'Skills' may contain multiple skills, which should be stored in a separate relation.