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

  

      

  

b. Tables to create: open bank account table, account holder/account table

  

      

  

c. Tables to create: register for courses table, register for courses/courses 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, ZIIP) Payment terms (e.g., 2/10, n/30) Purchasing agent name (first, last) Transaction number Transaction date Quantity purchased