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 Purchasing agent ID Vendor ID Purchasing agent home address Vendor address (street, city, state, ZIP) Purchasing agent name (first, last) Transaction date Inventory description Cost per item Vendor code Invoice total Payment terms (e.g. 2/10, n/30) Transaction number Quantity purchased

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

Available Fields Bank account type (e.g. checking) Current account balance Date account created Transaction type (e.g. deposit) Transaction amount Employee ID Total interest earned in current year Account number Account holder name Identity verified? Transaction date Account holder address (street, city, state, ZIP) Annual interest rate Account holder email

c. Tables to create: register for courses table, register for courses/courses table

Available Fields Student ID Course ID Course title Registration transaction number Total students currently enrolled Faculty member ID Course prefix and number (e.g. Acc 305) Maximum enrollment Registration date Average GPA of students enrolled