Create the logical database schema, Database Management System

1. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for each table (as shown in class). Label the types of dependencies (partial, transitive).