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. vailable feilds vendor phone purchasing agent ID vendor ID purchasing agent home address vendor address transaction date Inventor Discription

Cost per item Vendor Code invoice total payment terms tranaction number Quanity purchased

B. Create open bank account table and account holder/account table not all feild may be used

Bank account type Current balance date account created transaction type transacion amount Employee ID Total interest earned in current year

Account number account holder names Identify verfied? Transaction date Account holder address Annual interest rate Account holder Email

C. Create register for courses table, Register for courses/course table

Student ID Crourse ID Course Title Registration transaction number Total students currently enrolled Faculty ID number Corse Prefix and number

Maximum enrolllment Regisration date Average GPA students enrolled.