Creating database tables from flat files. Several independent flat files are shown below. From the fields listed, create the tables indicated.

 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