Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions