Creating database tables from flat files. Several independent flat files are shown below. From the fields listed, create the tables indicated. (Not all fields will be used in creating the indicated tables.) a. Tables to create: purchase inventory table, purchase inventory/inventory table Available Fields Vendor phone Inventory description Purchasing agent ID Cost per item Vendor ID Vendor code Purchasing agent home address Invoice total Vendor address (street, city, state, ZIP) Payment terms (e.g., 2/10, n/30) Purchasing agent name (first, last) Transaction number Transaction date Quantity purchased b. Tables to create: open bank account table, account holder/account table Available Fields Bank account type (e.g., checking) Account number Account holder name(s) Current account balance Identity verified? Date account created Transaction type (e.g., deposit) Transaction date Account holder address (street, city, state, ZIP) Transaction amount Employee ID Annual interest rate Total interest earned in current year Account holder email c. Tables to create: register for courses table, register for courses/courses table Available Fields Student ID Faculty member ID Course prefix and number (e.g., Acc 305) Course ID Course title Maximum enrollment Registration transaction number Registration date Total students currently enrolled Average GPA of students enrolled Creating database tables from flat files. Several independent flat files are shown below. From the fields listed, create the tables indicated. (Not all fields will be used in creating the indicated tables.) a. Tables to create: purchase inventory table, purchase inventory/inventory table Available Fields Vendor phone Inventory description Purchasing agent ID Cost per item Vendor ID Vendor code Purchasing agent home address Invoice total Vendor address (street, city, state, ZIP) Payment terms (e.g., 2/10, n/30) Purchasing agent name (first, last) Transaction number Transaction date Quantity purchased b. Tables to create: open bank account table, account holder/account table Available Fields Bank account type (e.g., checking) Account number Account holder name(s) Current account balance Identity verified? Date account created Transaction type (e.g., deposit) Transaction date Account holder address (street, city, state, ZIP) Transaction amount Employee ID Annual interest rate Total interest earned in current year Account holder email c. Tables to create: register for courses table, register for courses/courses table Available Fields Student ID Faculty member ID Course prefix and number (e.g., Acc 305) Course ID Course title Maximum enrollment Registration transaction number Registration date Total students currently enrolled Average GPA of students enrolled