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.

Collective bargaining provides for a representative of employees to negotiate with a representative of management over labor issues including wages.true or false?

Presented below is a list of possible transactions. analyze the effect of the 18 transactions on the financial statement categories indicated. transactions assets liabilities owners’ equity net income 1. purchased inventory for $80,000 on account (assume perpetual system is used). 2. issued an $80,000 note payable in payment on account (see item 1 above). 3. recorded accrued interest on the note from item 2 above. 4. borrowed $100,000 from the bank by signing a 6-month, $112,000, zero-interest-bearing note. 5. recognized 4 months’ interest expense on the note from item 4 above. 6. recorded cash sales of $75,260, which includes 6% sales tax. 7. recorded wage expense of $35,000. the cash paid was $25,000; the difference was due to various amounts withheld. 8. recorded employer’s payroll taxes. 9. accrued accumulated vacation pay. 10. recorded an asset retirement obligation. 11. recorded bonuses due to employees. 12. recorded a contingent loss on a lawsuit that the company will probably lose. 13. accrued warranty expense (assume expense warranty approach). 14. paid warranty costs that were accrued in item 13 above. 15. recorded sales of product and related service-type warranties. 16. paid warranty costs under contracts from item 15 above. 17. recognized warranty revenue (see item 15 above). 18. recorded estimated liability for premium claims outstanding.

Lavage rapide is a canadian company that owns and operates a large automatic car wash facility near montreal. the following table provides data concerning the company’s costs: fixed cost per month cost per car washed cleaning supplies $ 0.70 electricity $ 1,400 $ 0.07 maintenance $ 0.15 wages and salaries $ 4,900 $ 0.30 depreciation $ 8,300 rent $ 1,900 administrative expenses $ 1,400 $ 0.03 for example, electricity costs are $1,400 per month plus $0.07 per car washed. the company expects to wash 8,000 cars in august and to collect an average of $6.50 per car washed. the actual operating results for august appear below. lavage rapide income statement for the month ended august 31 actual cars washed 8,100 revenue $ 54,100 expenses: cleaning supplies 6,100 electricity 1,930 maintenance 1,440 wages and salaries 7,660 depreciation 8,300 rent 2,100 administrative expenses 1,540 total expense 29,070 net operating income $ 25,030 required: calculate the company's revenue and spending variances for august.