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...
-
Organic Growers Inc. is a successful grower of summer fruits and vegetables. The company has a seasonal business that starts in June and ends in October. The owners use a vast agricultural terrain to...
-
Historically, victims of the Ebola virus had a 30% chance of survival. (a) A new treatment is tested on three victims, and at least two of them survive. What is the probability of this happening, if...
-
Consider an economy with risk-neutral individuals. There are three types of individuals. An individual of type 1 can invest \($200\) and get a gross return of \($400\) with certainty. An individual...
-
1. Your company supplies ceramic floor tiles to Home Depot, Lowes, and other home improvement stores. You have been asked to start using radio frequency identification tags on each case of tiles you...
-
Solve the triangle. (Round to one decimal place as needed.) B
-
On January 1, 2020, K. Crew Inc. reported a $6,000 credit balance in its Accumulated OCIPension Gain/Loss account related to its pension plan. During 2020, the following events occurred. Actual...
-
Can you explain Berlekamp Massey Algorithm for finding the shortest LFSR. And give me the sagemath code of it. Also please write a specific example with the values p0=p3=p4=1; p1=p2=0.
-
In the domain of smart grid optimization, how can mathematical optimization models be employed to optimize energy generation, distribution, and consumption patterns, while considering factors such as...
-
1.What do you mean by Singular and non singular matrix. 2. Evaluate determinant of matrix -25 17 15 10
-
The Ally Gator Corporation of Meadville, PA, make of Ally's electronic components, is considering replacing one of its current hand-operated assembly machines with a new fully automated machine....
-
Q2.The demand and cost functions of a monopolist are given to be x = 500 - p and c = x-59x + 1315x + 2000 respectively. Find his profit maximising level of output and price. [10]
-
Glacier of Armenia is the largest independent ice maker facility in Armenia. Glacier provides ice to bars, restaurants, supermarkets, and food storage facilities, controlling 70% of the market for...
-
D A 1 Condensed financial statements for Games Galore are summarized below: 2 3 Balance Sheet 4 Cash 5 Accounts Receivable, Net 6 Inventory 7 Prepaid Insurance 8 Total Current Assets 9 Property and...
-
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...
-
Is the of a diversified conglomerate close to 1? Why?
-
As a result of a change in the nature of its business, there is a relative rise in the proportion of fixed costs in a group As total costs. Will this affect the risk attached to its share price? If...
-
What law of statistics explains that in the long term, risk disappears? State your views.
Study smarter with the SolutionInn App