Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jake-a friend...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jake-a friend who helps out occasionally at the store-Bill 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. Bill and Tom are more friends and bicycling enthusiasts than businessmen. They've 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." 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 haven't 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. Right now, BSN's "customer credit system" is a box of 3" x 5" cards. Each handwritten card contains customer information on the front and invoice information on the back (Figure 15-19). When a customer pays an invoice, one of the owners simply crosses off the invoice information on #1234 Dan Donaldson 123 Maple Drive, Invoice # Date Amount New City, Virginia 02345 4544 1056 8/12/2018 235.23 home phone: cell: (435) 765-6654 work: ? (232) 122-9843 Visa card #: 1234-445b-5432-0976 expires:8/2019 (A) The front of a 3x5 BSN customer card. (B) The back of a 3x5 BSN customer card. FIGURE 15-19 A customer record for the BSN company. the card. The "supplier accounts system" is similar, except that the vendor box of 3" x 5" cards is green, whereas the customer box is gray. 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 shop's 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 BSN's 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 company's 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" x 5" card in Figure 15-19 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. Bill Barnes and Tom Freeman opened their BSN bicycle shop in 2010. Not counting Jake-a friend who helps out occasionally at the store-Bill 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. Bill and Tom are more friends and bicycling enthusiasts than businessmen. They've 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." 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 haven't 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. Right now, BSN's "customer credit system" is a box of 3" x 5" cards. Each handwritten card contains customer information on the front and invoice information on the back (Figure 15-19). When a customer pays an invoice, one of the owners simply crosses off the invoice information on #1234 Dan Donaldson 123 Maple Drive, Invoice # Date Amount New City, Virginia 02345 4544 1056 8/12/2018 235.23 home phone: cell: (435) 765-6654 work: ? (232) 122-9843 Visa card #: 1234-445b-5432-0976 expires:8/2019 (A) The front of a 3x5 BSN customer card. (B) The back of a 3x5 BSN customer card. FIGURE 15-19 A customer record for the BSN company. the card. The "supplier accounts system" is similar, except that the vendor box of 3" x 5" cards is green, whereas the customer box is gray. 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 shop's 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 BSN's 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 company's 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" x 5" card in Figure 15-19 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.
Expert Answer:
Related Book For
Statistics Principles and Methods
ISBN: 978-0470904114
7th edition
Authors: Richard A. Johnson, Gouri K. Bhattacharyya
Posted Date:
Students also viewed these general management questions
-
To enroll in intermediate algebra, a student at the College of San Mateo (CSM) must score at least 21 points (out of 50) on a placement test. Using four semesters of data, the CSM Mathematics...
-
A student at the University of Wisconsin surveyed 40 students in her dorm concerning their participation in extracurricular activities during the past week. The data on number of activities are...
-
A student at the top of a building of height h throws one ball upward with a speed of vi and then throws a second ball downward with the same initial speed, vi. How do the final velocities of the...
-
Data obtained from asking the wrong questions at the wrong time or in the wrong place can lead to misleading summary statistics. Explain why the following collection procedures are likely to produce...
-
In Exercises 18, (a) Find the five-number summary, and (b) Draw a box-and-whisker plot that represents the data set. 171 176 182 150 178 180 173 170 174 178 181 180
-
In a role-playing exercise, one of the students is asked to take the position in favor of heavy reliance on internal referrals, in particular by combing social sites. Another student is asked to...
-
Redesign and implementation of accounting and reporting systems to incorporate environmental and ecological considerations faces a number of practical considerations. List and rank four of these...
-
U.S. consumers are increasingly viewing debit cards as a convenient substitute for cash and checks. The average amount spent annually on a debit card is $7,790 (Kiplinger's , August 2007). Assume...
-
Wayne Co. has the following Income Statement (in millions): Wayne Co. Income Statement For the Year Ended December 31, 2023 Net Sales $160 Cost of Goods Sold 100 Gross Profit 60 40 $ 20 Operating...
-
For the 2 Ã 3 - 10 centrifugal pump performance curve shown in Fig. 13.28, describe the performance that can be expected from a pump with an 8-in impeller operating against a system head of...
-
Ch. 11 Assignment- Part 2 i Saved 8 Required information [The following information applies to the questions displayed below.] Year 1 total cash dividends Part 2 of 2 Year 2 total cash dividends Year...
-
Luxury Furniture designs and builds factory-made, premium, wood armoires for homes. All are of white oak. Its budgeted MOH costs for the year 2017 are as follows Overhead Cost Pools Purchasing...
-
DeSoto Tools Incorporated is planning to expand production. The expansion will cost $2,600,000, which can be financed either by bonds at an interest rate of 7 percent or by selling 52,000 shares of...
-
2. Here is the polynomial function: k(x) = x 8x + 10x + 2x +4 a) Use the remainder and factor theorems, to determine whether or not the binomial x-2 is a factor of c(x). Show your work. b) If it is,...
-
In the diagram below the displacement-time-graph of a spring oscillator is given. 20+ 10+ t/s 0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.5 1.8 2 -10+ y/cm -20- For a mass of 6.7kg find the maximum potential...
-
Abel is 43 years old, and he owns his car, which he uses to get to work. His collision deductible is $250, and he does not have comprehensive coverage. If his car's safety rating is 22, how much does...
-
Hydrogen cyanide can add to a ketone to form a cyanohydrin (B) through the overall reaction: HO + NaCN + H+ CN +Na+ R R' R R' (B) (A) The mechanism occurs in a (dilute) liquid solution as: 1)...
-
The Smiths buy a house. They borrow 80 percent of the purchase price from the local ABC Savings and Loan. Before they make their first payment, ABC transfers the right to receive mortgage payments to...
-
Suppose the number of different computers used by a student last week has distribution Value Probability 0..............................3 1............................. .4...
-
Laser guns for detecting speeders require an accurate measurement of distance. In one daily calibration test, police measure the known distances 164 feet and 104 feet. The difference in readings...
-
In the survey on which Table D.12 of the Data Bank is based, a large number of persons was each asked "Is it preferable to have 1% of your monthly charges donated to a charity of your choice rather...
-
Assume that Boardmaster sold skateboards to a department store for \($35,000\) cash. How would this transaction affect Boardmasters accounting equation? a. Increase both assets and stockholders...
-
Generally Accepted Accounting Principles (GAAP) are created by the a. Securities and Exchange Commission (SEC). b. Financial Accounting Standards Board (FASB). C. Institute of Management Accountants...
-
Boardmaster is famous for custom skateboards. At the end of a recent year, Boardmasters total assets added up to \($622\) million, and stockholders equity was \($487\) million. How much did...
Study smarter with the SolutionInn App