This page creates the tables enabled for third normal form and appropriate constraints enforced, for indexing to be applied

Problem Description


For the purpose of comparison of query execution times, separate set of tables are created for indexes to be created on and the query execution time against these tables with indexes are compared with those created earlier without indexes.

Operation


Create the tables in third normal form with appropriate constraints.

Result


The tables in third normal form with appropriate constraints are created.