A. Create data base tables, purchase inventory, purchase inventory/inventory table not all feilds will be used.

Available 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.