I used Azure to create a database. I used Azure Data Studio and https://github.com/R0tenur/visualization to create the following Entity Relationship Diagram / Relational Model (?). Are the object-oriented tables in this database in Third Normal Form (3NF)?

According to 1, the main criteria that distinguishes a table in Second Normal Form from a version of that table in 3NF is that the table “contains no transitive dependencies. A transitive dependency is when one non-key field’s value depends on another non-key field’s value.” Considering table instructors for example, does column is_current_employee depend on column name?

1. Rod Stephens (2008). “Chapter 7. Normalizing Data”. Beginning Database Design Solutions. https://learning.oreilly.com/library/view/beginning-database-design/9780470385494/ch07.html#what_is_normalization_question. Access 07/20/2024.