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 b Tables to create open bank account table, account holder account table c Tables to create register for courses table, register for courses courses table Available Fields Vendor phone Inventory description Purchasing agent ID Cost per item Vendor ID Vendor code Purchasing agent home address Invoice total Vendor address (street, city, state, ZIIP) Payment terms (e g , 2 10, n 30) Purchasing agent name (first, last) Transaction number Transaction date Quantity purchased

Question: 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 Inventory description Purchasing agent ID Cost per item

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

Vendor ID Vendor code Purchasing agent home address Invoice total Vendor address

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

(street, city, state, ZIIP) Payment terms (e.g., 2/10, n/30) Purchasing agent name

Available Fields Vendor phone Inventory description Purchasing agent ID Cost per item Vendor ID Vendor code Purchasing agent home address Invoice total Vendor address (street, city, state, ZIIP) Payment terms (e.g., 2/10, n/30) Purchasing agent name (first, last) Transaction number Transaction date Quantity purchased

Step by Step Solution

★★★★★

3.31 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer Explanation a Tables to create purchase inventory table purchase inventoryinventory table Ava... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

What are the management benefits of supply chain management system?: How has supply chain been affected during the Covid epidemic? What have you experienced personally of this situation?

Table Tops, a manufacturer of occasional tables for the home, operates in a just-in-time environment. The company is currently evaluating its operations to find areas where the company is incurring...

Create and edit tables for Coast Jewlers. a. Create a new table for Coast Jewelers that includes fields labeled Buyer ID, Buyer Name, and Buyer Phone. The first field (Buyer ID) is an AutoNumber data...

The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their...

Early in 2010 Aragon Company switched to a just-in-time inventory system. Its sales, cost of goods sold, and inventory amounts for 2009 and 2010 are shown below. Determine the inventory turnover and...

A sociologist claims that children ages 617 spent more time watching television in 1981 than children ages 617 do today. A study was conducted in 1981 to find the time that children ages 617 spent...

Your firm has audited the Rock Island Quarry Company for several years. Rock Islands main revenue comes from selling crushed rock to construction companies from several quarries owned by the company...

Refer to Figure and Table. How would you determine the amount of cash that Freds Train Shop has at any point intime? TABLE 18-1 Table Names and Attribute Placement for Figure 18-4 ATTRIBUTES FOREIGN...

Comprehensive Fixed-Asset Problem Darby Sporting Goods Inc. has been experiencing growth in the demand for its products over the last several years. The last two Olympic Games greatly increased the...

Selig Sporting Goods Inc. has been experiencing growth in the demand for its products over the last several years. The Olympic Games have greatly increased the popularity of basketball around the...

Solution 4,5,6? 4. What was MVC's net cash inflow from operating activities for 20X7? a) $44,000 b) $45,000 C) $46,000 d) $51,000 5. What was MVC's net cash from investing activities for 20X7? a)...

Selected hypothetical comparative statement data for the giant bookseller Barnes & Noble are presented here. All balance sheet data are as of the end of the fiscal year (in millions). 2022 2021 Net...

Refer to Figure 6-9. What is the price buyers will pay after the tax is imposed? Refer to Figure 6-9. What is the amount of the tax per unit imposed in this market?

Fullan (2014) mentions a variety of components that are needed for change to occur. What 3 leadership strategies do you feel are foremost in working through the change process and why? Support in the...

7. In a large water tank experiment, water waves are gener- ated with straight, parallel wave fronts, 3.00 m apart. The wave fronts pass through two openings 5.00 m apart in a long board. The end of...

What makes Shenzhen Development Bank (SDB) an attractive target for investment, and what are the potential sources of value? What are the key risks for investing in SDB, and how can Newbridge...

The investment committee of Fortune Ltd is currently considering an investment in a new Project that requires an investment of $ 40,000. The company uses straight-line depreciation, and no residual...

At 31 December 20X9, the end of the annual reporting period, the accounts of Huron Company showed the following: a. Sales revenue for 20X9, $ 2,950,000, of which one- quarter was on credit. b....

exhibit. All interfaces are configured with duplex auto and ip ospf network broadcast. Which configuration allows routers R14 and R86 to form an OSPFv2 adjacency and act as a central point for...

Why is it important for an organizations response to an ethics violation to be viewed as fair by other employees?

Crosser Company budgets on a quarterly basis. The following beginning and ending inventory levels (in units) are planned for the first and second quarters of 2009. Required If Crosser Company were to...

What is the focus of a usage variance?

Even before the record gas prices during the summer of 2008, an article written by Will Lester of the Associated Press reported on a poll in which 80% of those surveyed say that Americans who...

A random sample was selected from a population having a normal distribution. Calculate a 90% confidence interval estimate for m for each of the following situations: a. x 134, n 10, s 3.1 b. x ...

Allante Pizza delivers pizzas throughout its local market area at no charge to the customer. However, customers often tip the driver. The owner is interested in estimating the mean tip income per...