\"Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jakea friend who helps out occasionally at the storeBill and Tom are the only employees. The shop occupies a small commercial space that was once a restaurant. The former kitchen now stores spare parts and provides space for bicycles repairs while the former dining area in the front is now the retail sales area. The corporate office is just a desk and file cabinet in the back corner of the retail area.<\/p>
Bill and Tom are more friends and bicycling enthusiasts than businessmen. Theyve pretty much sunk their life savings into the shop and are anxious that it succeed. In the first year of operations, they worked hard to convert the space into its present condition, which includes an old-timey sign above the door with their name BSN Bicycles.<\/p>
With all the other work that had to be done the first year, marketing efforts have been limited to chatting with friends, distributing flyers at bicycle races and similar sporting events, and placing a few ads on the Internet. Similarly, the owners havent paid much attention to accounting tasks. Who has time with all the other things that must be done? But at least two things are now clear to the owners: (1) some of their loyal customers prefer to buy items on credit, and (2) all of their suppliers want to be paid on time.<\/p>
Right now, BSNs customer credit system is a box of 3 5 cards. Each handwritten card con- tains customer information on the front and invoice information on the back (Figure 8-21). When a customer pays an invoice, one of the owners simply crosses off the invoice information on the\"card. The supplier accounts system is similar, except that the vendor box of 3 5 cards is green, whereas the customer box is grey. Jake is a student at the local university. He is taking an AIS course that includes a segment on Microsoft Access. He is still learning about database theory, but thinks that converting the shops current accounting systems to a DBMS might be a good idea. He thinks, for example, that BSN needs a customer table and a vendor (supplier) table. He also thinks that BSN will need an inventory table to keep track of inventory, but that even more tables might be required. Can you help them? Requirements 1. Identify the resources, events, and agents for BSNs accounting systems. Draw one or more E-R diagrams that illustrate the relationships between these items. 2. Identify the tables that you would need to create a working database for the companys receiv- ables, payables, and inventory. 3. Using Access or another DBMS required by your instructor, create at least three records for each of the tables you identified in part 2. Hints: (1) Use the information on the front of the 3 5 card in Figure 8-21 for the customer record structure. (2) The data fields for the Vendors table should include the vendor ID, vendor name and address information, phone number, fax number, and contact person. (3) The data fields for the Inventory table should include item number, item description, units (e.g., dozen, each, etc.), unit cost, unit retail sales price, and quantity on hand. 4. Create relationships for your various tables. 5. Document your work by printing the relationships window.\" 5. Document your work by printing the relationships window. (Simkin 269) Simkin, Mark G., Carolyn Norman, Jacob Rose. Core Concepts of Accounting Information Systems, 13th Edition. Wiley, 2014-11-17. VitalBook file. The citation provided is a guideline. Please check each citation for accuracy before use. <\/p>", "transcribed_text": "", "related_book": { "title": "Fundamentals Of Statistics", "isbn": "978-032184460, 032183870X, 321844602, 9780321838704, 978-0321844606", "edition": "4th Edition", "authors": "Michael Sullivan III", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/445.jpg", "uri": "\/textbooks\/fundamentals-of-statistics-4th-edition-445", "see_more_uri": "" }, "free_related_book": { "isbn": "0691193924", "uri": "\/textbooks\/the-complete-birds-of-the-world-every-species-illustrated-1st-edition-978-0691193922-302125", "name": "The Complete Birds Of The World Every Species Illustrated", "edition": "1st Edition" }, "question_posted": "2024-06-28 08:56:09", "see_more_questions_link": "\/study-help\/questions\/business-banking-2021-September-12", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/lawncare-usa-provides-lawn-care-and-landscaping-services-to-commercial", "description": "LawnCare USA provides lawn care and landscaping services to commercial clients. LawnCare USA uses activity-based costing to bid on jobs and to evaluate their profitability. LawnCare USA reports the...", "stars": 3 }, { "url": "\/study-help\/psychology\/general-broad-training-at-the-doctoral-level-in-clinical-counseling-1980896", "description": "general broad training at the doctoral level in clinical, counseling, or school psychology including supervised practica;", "stars": 3 }, { "url": "\/study-help\/questions-and-answers\/read-the-following-case-study-marauder-corporation-operates-a", "description": "Read the following Case study: Marauder Corporation operates a chemical plant in northern Michigan. The terms of a state-issued permit require Marauder to test and report on the water quality of a...", "stars": 3 }, { "url": "\/study-help\/questions\/applying-the-accounting-equation-and-assessing-financial-statement-linkages-9885939", "description": "- Applying the Accounting Equation and Assessing Financial Statement Linkages Answer the following questions. (Hint: Apply the accounting equation.) a. Intel had assets equal to $103.065 million and...", "stars": 3 }, { "url": "\/study-help\/questions\/a-company-must-decide-between-scrapping-or-reworking-units-that-8175935", "description": "A company must decide between scrapping or reworking units that do not pass inspection. The company has 22,000 defective units that have already cost $132,000 to manufacture. The units can be sold as...", "stars": 3 }, { "url": "\/study-help\/questions\/provide-a-pointform-summary-of-the-case-supreme-court-of-2809879", "description": "Provide a point-form summary of the case Supreme Court of Canada Rivtow Marine Ltd. v. Washington Iron Works[1974] S.C.R. 1189 Date: 1973-08-27 Rivtow Marine Ltd. (Plaintiff) Appellant; and...", "stars": 3 }, { "url": "\/study-help\/questions\/s-numbered-3-to-5-are-based-on-the-following-1272660", "description": "Stan purchased a $15,000 compound Canada Savings Bond on November 1, Year 1. Suppose that in the first bond year, the CSB earns 3% and, in the second bond year, it earns 4.5%. What amount of interest...", "stars": 3 }, { "url": "\/study-help\/questions\/on-halloween-night-a-small-boy-decided-to-dress-up-3464951", "description": "On Halloween night, a small boy decided to dress up as a bank robber. He went to house where the lights were on, indicating that the owner was receiving trick-or- treaters. When the homeowner, a...", "stars": 3 }, { "url": "\/study-help\/questions\/2-con-los-siguientes-datos-de-la-industria-automotriz-en-4551389", "description": "2. With the following data from the automotive industry in Mexico. a) Calculate and analyze the behavior of the CR4 and the HHI in 1980, 1994 and 2004. Sales volume (units) Number of companies 7 6 21...", "stars": 3 }, { "url": "\/study-help\/questions\/hello-there-i-was-wondering-if-you-had-any-luck-3356110", "description": "Accrual Basis Accounting SLO Health Care Inc. is owned and operated by Morgan Denby, the sole stockholder. During January 20Y6, SLO Health Care entered into the following transactions: Jan. 1...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/consider-the-following-information-for-three-stocks-stocks-x-y-4278512", "next": "\/study-help\/questions\/1-consider-the-following-statements-i-only-variable-manufacturing-costs-4278514" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010.", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/bill-barnes-and-tom-freeman-opened-their-bsn-bicycle-shop-4278513" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } } } }