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 administering a field sobriety test to suspected drunks, officers may ask a person to walk in a straight line or close his eyes and touch his nose. Define the Type I and Type II errors in terms of...
-
Why is marketing as important for not-for-profit organizations as profit-driven ones?
-
The following informatiohna s been extracted from the books of Nimmo Limited for the year to 31 December 2009: Additional information: 1. The directors are extremely concerned about the large bank...
-
Kearney Company, operating at full capacity, sold 400,000 units at a price of $246.60 per unit during 2012. Its income statement for 2012 is as follows: The division of costs between fixed and...
-
. Unit 3 Exam - Hands-On - Part 2 Transactione: Apr. 2 Paid cash to establish a petty cash fund, $150.00. Check No. 310. 5 Purchased supplies, $260.00, using debit card. Memorandum No. 149. 9...
-
Natura Cosmeticos SA, Brazils all natural, ethically-sourced, sustainable beauty products company, recently purchased Avon Products Inc. as a way to enter the U.S., Europe, and Chinese cosmetics...
-
If Dana fails her history exam, she is likely to initially attribute her failure to a. not having gone to class or studied enough. b. her lack of basic ability in history -- she is not a history...
-
Fifteen years ago your parents purchased some land with the idea of selling it later to help pay your college expenses. They purchased the land for $100,000. They sold it for $180,000. During the...
-
As result of recent cut back by oil producing nation , we expect the price of gasolin to double in the next year this centence is dicriptive or infrential?
-
The invasion of Normandy during World War II....**Develop the Operational Approach:** The third step is to develop the operational approach. This involves determining the sequence of actions that...
-
Sales in the financial year ending 30 April, 2022 are expected to be 11 000 units for product X and 16 500 units for product Y at the last financial year selling prices. (Note: direct labour hours is...
-
Discuss two examples of how research and development (R&D) is enabling green and/or sustainable manufacturing of engineering products.
-
Crane Company is considering two different, mutually exclusive capital expenditure proposals. Project A will cost $523,000, has an expected useful life of 12 years, a salvage value of zero, and is...
-
A Bloomberg Businessweek subscriber study asked, In the past 12 months, when traveling for business, what type of airline ticket did you purchase most often? A second question asked if the type of...
-
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...
-
Consider a game \(G\) in strategic form. Recall that the commitment game derived from \(G\) is defined by letting player I choose one of his strategies \(x\), which is then announced to player II,...
-
Consider the following two game trees (a) and (b). Payoffs have been omitted because they are not relevant for the question. In each case, how many strategies does each player have? How many reduced...
-
Consider the following three-player game tree. At a leaf, the topmost payoff is to player I, the middle payoff is to player II, and the bottom payoff is to player III. (a) How many strategy profiles...
Study smarter with the SolutionInn App