Draw the dependency diagrams
a. Given the structure shown in Table P6.6, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependencies. b. Draw the dependency diagrams that are in 3NF. (You might have to create a few new attributes. Also make sure that the new dependency diagrams contain attributes that meet proper design