Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 6P
To determine
Draw partial relational database for Company PGP. Also, label database tables assigning necessary attributes, foreign and primary key assuming that invoice, purchase orders and receipts contains many items.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
GREEN POND NURSERY (STAND ALONE PC-BASED ACCOUNTINGSYSTEM)Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and gar den spreaders. GPNS's customers are primarily small garden centers and landscape companies in the Mid-Atlantic states. Sales are on credit.GPNS's current information system includes manual procedures supported by independent (non networked) PCs in each department. Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these com plaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS's procedures and internal controls. The following is a description of GPNS's expenditure cycle.Purchasing ProcessThe purchasing…
JC Company sells various merchandize ( building materials, stationery, house hold goods, and assortd groceries) to the general public and government workers on both cash and credit basis. You are a student at one of the universities and the sole trader for JC Company approaches you to write a company profile for him.
Smith’s Market (Small Business Cash Sales Accounting System)
In 1989 Robert Smith opened a small fruit and vegetable market in Bethlehem, Pennsylvania. Originally Smith sold only produce grown on his family farm and orchard. As the market’s popularity grew, however, he added bread, canned goods, fresh meats, and a limited supply of frozen goods. Today Smith’s Market is a full-range farmers’ market with a strong local customer base. Indeed, the market’s reputation for low prices and high quality draws customers from other Pennsylvania cities and even from the neighboring state of New Jersey. Currently Smith’s has 40 employees. These include sales staff, shelf stockers, farm laborers, shift supervisors, and clerical staff. Recently Smith has noticed a decline in profits and sales, while his purchases of products for resale have continued to rise. Although the company does not prepare audited financial statements, Robert Smith has commissioned your public accounting firm to assess his…
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
Knowledge Booster
Similar questions
- GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING SYSTEM) Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNSs customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit. GPNSs current information system includes manual procedures supported by independent (non-networked) PCs in each department Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNSs procedures and internal controls. The following is a description of GPNSs expenditure cycle. Purchasing Process The purchasing agent receives an inventory status report from the inventory control department, which identifies the items that need to be reordered. The agent selects the suppliers, enters this information into the computer terminal to create a digital purchase order, and then prints three hard copies of the purchase order. He sends one copy to the supplier; one copy to the AP department, where it is filed temporarily, and files the third copy in the purchasing department. When the goods are received, the receiving department inspects and verifies them using the packing slip, which is attached to the goods. The receiving clerk manually prepares two hard copies of a receiving report. One copy accompanies the goods to the warehouse for storage. The receiving clerk sends the second copy to the purchasing agent who closes the open purchase order. The purchase agent then forwards the receiving report to the inventory control clerk. The inventory control clerk receives the receiving report and updates the inventory subsidiary. At the close of business, the clerk prepares an inventory summary, which he sends to the general ledger clerk. Accounts Payable and Cash Disbursements Procedures The AP clerk receives the suppliers invoice and reconciles it with the purchase order in the temporary file. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger. The purchases order and invoice are then filed in the department. Each day, the AP clerk visually searches the AP subsidiary ledger from her terminal for invoices that are due to be paid. The clerk prepares the check and records it in the digital check register. The negotiable portion of the check is mailed to the vendor, and a check copy is filed. The clerk then closes the liability in the AP subsidiary ledger and prepares a journal voucher, which she sends to the general ledger clerk. Upon receipt of the inventory summary and journal voucher, the general ledger clerk updates the inventory control, AP control, and cash accounts. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.arrow_forwardSMITH'S MARKET (SMALL BUSINESS CASH SALES ACCOUNTING SYSTEM) In 1989, Robert Smith opened a small fruit and vegetable market in Bethlehem, Pennsylvania. Originally, Smith sold only produce grown on his family farm and orchard. As the market's popularity grew, however, he added bread, canned goods, fresh meats, and a limited supply of frozen goods. Today Smith's Market is a full-range farmers' market with a strong local customer base. Indeed, the market's reputation for low prices and high quality draws customers from other Pennsylvania cities and even from the neighboring state of New Jersey. Currently Smith's has 40 employees. These include sales staff, shelf stockers, farm laborers, shift supervisors, and clerical staff. Recently, Smith has noticed a decline in profits and sales, while his purchases of products for resale have continued to rise. Although the company does not prepare audited financial statements, Robert Smith has commissioned your public accounting firm to assess…arrow_forward(Allocate Transaction Price, Returns, and Consignments) Ritt Ranch & Farm is a distributor of ranch and farm equipment. Its products range from small tools, power equipment for trench-digging and fencing, grain dryers, and barn winches. Most products are sold direct via its company catalog and Internet site. However, given some of its specialty products, select farmimplement stores carry Ritt’s products. Pricing and cost information on three of Ritt’s most popular products are as follows. Item Standalone Selling Price (Cost) Mini-trencher $ 3,600 ($2,000) Power fence hole auger 1,200 (800) Grain/hay dryer 14,000 (11,000) InstructionsRespond to the requirements related to the following independent revenue arrangements for Ritt Ranch & Farm.(a) On January 1, 2017, Ritt sells 40 augers to Mills Farm & Fleet for $48,000. Mills signs a 6-month note at an annual interest rate of 12%. Ritt allows Mills to return any auger that it cannot use within 60 days and receive a…arrow_forward
- (Allocate Transaction Price, Returns, and Consignments) Ritt Ranch & Farm is a distributor of ranch and farm equipment. Its products range from small tools, power equipment for trench-digging and fencing, grain dryers, and barn winches. Most products are sold direct via its company catalog and Internet site. However, given some of its specialty products, select farmimplement stores carry Ritt’s products. Pricing and cost information on three of Ritt’s most popular products are as follows. Item Standalone Selling Price (Cost) Mini-trencher $ 3,600 ($2,000) Power fence hole auger 1,200 (800) Grain/hay dryer 14,000 (11,000) Respond to the requirements related to the following independent revenue arrangements for Ritt Ranch & Farm. On April 25, 2022, Ritt ships 100 augers to Farm Depot, a farm supply dealer in Nebraska, on consignment. By June 30, 2022, Farm Depot has sold 60 of the consigned augers at the listed price of $1,200 per unit. Farm Depot notifies…arrow_forwardYour friend, Wendy Geiger, owns a small retail store that sells candies and nuts. Geiger acquires her goods from a few select vendors. She generally makes purchase orders by phone and on credit. Sales are primarily for cash. Geiger keeps her own manual accounting system using a general journal and a general ledger. At the end of each business day, she records one summary entry for cash sales. Geiger recently began offering items in creative gift packages. This has increased sales substantially, and she is now receiving orders from corporate and other clients who order large quantities and prefer to buy on credit. As a result of increased credit transactions in both purchases and sales, keeping the accounting records has become extremely time- consuming. Geiger wants to continue to maintain her own manual system and calls you for advice. Write a memo to her advising how she might modify her current manual accounting system to accommodate the expanded business activities. Geiger is…arrow_forwardCreate a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customers besides its regular store sales. The automated system greets customers, asks them to choose a tone or pulse phone, and routes them accordingly. The system checks to see whether customers have an existing account. They can wait for the service representative to open a new account. Customers choose between order options and are routed accordingly. Customers can cancel the order. Finally, the system asks whether the customer has additional requests; if not, the process terminates.arrow_forward
- REA Model—Adirondacks Classic Furniture Adirondacks Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and interior furnishing including lamps, desks, and bedframes. ACF’s customer base comprises both private consumers and retail outlets. Consumer’s sales are for cash or by credit card, but business customers are extended a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online, by fax or mailed in hard-copy order. When a credit order is received, the sales clerk verifies inventory availability, prepares a sales order, and sends the stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department, where…arrow_forwardRunway Discount ("Runway" or the "Company") is a privately held online retailer that sells discounted high-end fashion. In an effort to increase its sales and customer base, Runway implemented a customer referral marketing campaign (the "Refer-a-Friend Program") whereby existing customers can refer friends to Runway and receive a $25 credit towards the purchase of future merchandise. The terms of the program are as follows: Runway offers existing customers (the "Existing Customer") a $25 credit (the "$25 Referral Credit") if the Existing Customer refers a friend (the "New Customer") to Runway's Web site and the New Customer purchases merchandise from Runway. After a purchase is made by the New Customer, the Existing Customer receives a$25 credit to be applied to a future purchase from Runway. The $25 Referral Credit represents the fair value of the cost Runway would pay to acquire a new customer from an unrelated third party or marketing firm who is not a purchaser of its products.…arrow_forwardRunway Discount (“Runway” or the “Company”) is a privately held online retailer that sells discounted high-end fashion. In an effort to increase its sales and customer base, Runway implemented a customer referral marketing campaign (the “Refer-a-Friend Program”) whereby existing customers can refer friends to Runway and receive a $25 credit towards the purchase of future merchandise. The terms of the program are as follows: Runway offers existing customers (the “Existing Customer”) a $25 credit (the “$25 Referral Credit”) if the Existing Customer refers a friend (the “New Customer”) to Runway’s Web site and the New Customer purchases merchandise from Runway. After a purchase is made by the New Customer, the Existing Customer receives a$25 credit to be applied to a future purchase from Runway. The $25 Referral Credit represents the fair value of the cost Runway would pay to acquire a new customer from an unrelated third party or marketing firm who is not a purchaser of its products.…arrow_forward
- Create a flowchart for the following telephone-ordering process at a retail chain that specializes in selling books and music CDs. It provides an ordering system via the telephone to its time-sensitive customersbesides its regular store sales. First, the automated system greets customers and identifies whether they have a tone or pulse phone. Customers choose 1 if they have a tone phone; otherwise, they wait for the first available service representative to process their request. If customers have a tone phone, they complete their request by choosing options on the phone. First, the system checks to see whether customers have an existing account.Customers choose 1 if they have an existing account or choose 2 if they want to open a new account. Customers wait for the service representative to open a new account if they choose 2. Next, customers choose between the options of making an order, canceling an order, or talking to a customer representative for questions and/or complaints. If…arrow_forwardLarry's Landscaping Services has extended Net 30 terms to his new customer, Mahoney's Mugs. What sales workflow would you recommend Larry use for Mahoney's? -Create Invoice > Receive Payment > Check Register -Create Sales Receipt > Bank Deposit -Create Invoice > Receive Payment > Bank Deposit -Create Sales Receipt > Receive Payment > Bank Depositarrow_forwardThe controller of E-books reads a widely used textbook that states that “the reciprocal method is conceptually the most defensible.” He seeks your assistance. Describe the key features of the reciprocal method.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College Pub
Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Auditing: A Risk Based-Approach to Conducting a Q...
Accounting
ISBN:9781305080577
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:South-Western College Pub
Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L