2NF

3NF

1NF

4NF

Physical allows changing storage without affecting logical schema

Logical concerns internal schema only

Physical affects users directly

Logical means changing user interface

Add STUDENT_ID as attribute in COURSE

Add COURSE_ID as attribute in STUDENT

Create a new relation ENROLLS with foreign keys to both STUDENT and COURSE

Merge both entities into one table

The domain of Sub is alpha string.

The domain of Auth1 is alphanumeric string.

The domain of PID is alpha string - nullable.

The domain of Sub is alpha string.

The domain of Auth1 is alphanumeric string.

The domain of PID is alpha string - nullable.

EMP(Emp_ID) and DEPT (Dept_ID, Dept_Name)

EMP(Emp_ID, Dept_ID) and DEPT(Dept_ID, Dept_Name)

EMP(Emp_ID, Dept_ID) and DEPT(Dept_Name)

SELECT

GROUP BY

WHERE

FROM

Validation Technique

Lock Conversion

Timestamp Ordering

Two-Phase Locking

Derived attribute

Multivalued attribute

Weak entity

Strong entity

Incharge -> Experience

Experience -> Incharge

Incharge -> Department