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 Denaldson 123 Maple Drive, Invoice # Amount tas v Date New City, Virginia o2345 235.23 home phone: (435) 765-6654 work: ? cell: J056 (232) 122-843 Visa card : a34-445-S432-0976 expires:Rlaor (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. CHAPTER 15 / Organizing and Manipulating the Data in Databases 485 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. 15-16. BSN Bicycles II (Creating Queries in Access) Business has been growing at BSN Bicycles, and the store owners have been using their Access database to store information about their customers. Now that the store is a little more established, the owners are thinking more about how best to attract more customers to their store. One idea is to see where their current customers live. The owners also want a complete list of their credit customers. Requirements 1. If you have not already done so, create a database for BSN and the customer's table described in Case 15-17. Be sure to create at least 10 customer records for the company, including one with your name. Several of the customers should live in the states of Texas (TX) and Massachusetts (MA), and several customers should have zip code "12345." The customers in TX and MA and the customers with zip code 12345 do not have to be the same. 2. If you have not already done so, create several invoices for your customers. 3. Create a query that selects all customers living in TX or MA. 4. Create a query that selects all customers living in zip code 12345. 5. Create a query that selects all customers living in TX who also have zip code 12345. 6. Create a query that selects all credit customers. (Hint: Use the word "Yes" for the criteria in this query.) 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 Denaldson 123 Maple Drive, Invoice # Amount tas v Date New City, Virginia o2345 235.23 home phone: (435) 765-6654 work: ? cell: J056 (232) 122-843 Visa card : a34-445-S432-0976 expires:Rlaor (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. CHAPTER 15 / Organizing and Manipulating the Data in Databases 485 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. 15-16. BSN Bicycles II (Creating Queries in Access) Business has been growing at BSN Bicycles, and the store owners have been using their Access database to store information about their customers. Now that the store is a little more established, the owners are thinking more about how best to attract more customers to their store. One idea is to see where their current customers live. The owners also want a complete list of their credit customers. Requirements 1. If you have not already done so, create a database for BSN and the customer's table described in Case 15-17. Be sure to create at least 10 customer records for the company, including one with your name. Several of the customers should live in the states of Texas (TX) and Massachusetts (MA), and several customers should have zip code "12345." The customers in TX and MA and the customers with zip code 12345 do not have to be the same. 2. If you have not already done so, create several invoices for your customers. 3. Create a query that selects all customers living in TX or MA. 4. Create a query that selects all customers living in zip code 12345. 5. Create a query that selects all customers living in TX who also have zip code 12345. 6. Create a query that selects all credit customers. (Hint: Use the word "Yes" for the criteria in this query.)
Expert Answer:
Related Book For
Discovering Advanced Algebra An Investigative Approach
ISBN: 978-1559539845
1st edition
Authors: Jerald Murdock, Ellen Kamischke, Eric Kamischke
Posted Date:
Students also viewed these accounting questions
-
Draw an entity-relationship diagram to illustrate the data structures required for the expenditure and revenue cycle. Regular Sales. The Wooden Nickel has yearly sales of between $700,000 and...
-
Draw the ER diagram for the two instance diagrams depicted here. NEW ASSET S1 Assigned to S2 Scheduled for S3 AIRFORCE BASE NAVAL BASEE r1 S4 r8 A1 N1 r2 A2 S5 Se A3 A4 AS S7 S8 N3 S9 S10 S11...
-
Draw Venn diagrams to show the relationships between these sets of numbers. a. Real numbers and complex numbers b. Rational numbers and irrational numbers c. Imaginary numbers and complex numbers d....
-
Mien Co. is budgeting sales of 53,000 units of product Nous for October and 60,000 units of product Nous for November. The manufacturing of one unit of Nous requires 4 kilos of chemical Loire. During...
-
In Exercises 17, (a) Find the five-number summary, and (b) Draw a box-and-whisker plot that represents the data set. 39 36 30 27 26 24 28 35 39 60 50 41 35 32 51
-
The director of HR has appointed you to a committee responsible for investigating allegations that reliance on internal referrals through social sites undermines the diversity efforts of the firm....
-
Implementation plays a critical part in environmental management.Why might environmental management fail at the implementation stage? Can these reasons for failure be corrected or avoided?
-
If you were a chief marketing officer, what metrics might you use to evaluate the performance of the IS organization in your company?
-
Azhan started his business in 2013 as a sole trader, registered under the name of Nahza Trading (accounting year end 31 December). In 2016 he got married, and in 2017 Azhan set up a company as an...
-
A company wishes to create a trust fund through a savings plan with either annual or monthly deposits under an APR of 5% over 30 years. During that time, the company has the following cash flows: a...
-
Jem Jewel Pte Ltd (JJ) uses normal and job order costing. JJ had two jobs in process at the start of March: job number 84 ($34,000) and job number 85 ($54,000). JJ applies manufacturing overhead on...
-
Presented below is information related to Skysong Company. Cost Retail Beginning inventory $150,815 $283,000 Purchases 1,369,000 2,130,000 Markups 93,200 Markup cancellations 14,700 Markdowns 35,900...
-
A is 66.0 m long at a 32.0 angle with respect to the +x-axis. B is 51.0 m long at a 55.0 angle above the -x-axis. What is the magnitude of the sum of vectors A and B? What angle # does the sum of...
-
The following information relates to Lily Co. for the year 2020. Owner's Capital, January 1, 2020 $65,600 Advertising expense $8,100 Drawings during 2020 7,300 Rent expense 10,100 Service revenue...
-
The following data were adapted from a recent income statement of The Procter & Gamble Company (PG): Sales Operating costs: (in millions) $248,260 Cost of products sold $(119,160) Marketing,...
-
Find a parametric representation for the surface. the part of the sphere x + y+z = 64 that lies between the planes z = 0 and z = 43. (Enter your answer as a comma-separated list of equations. Let x,...
-
The following transactions occurred for the Microchip Company. 1. On October 1, 2024, Microchip lent $81,000 to another company. A note was signed with principal and 8% interest to be paid on...
-
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...
-
The value of a building depreciates at a rate of 6% per year. When new, the building is worth $36,500. a. How much is the building worth after 5 years 3 months? b. To the nearest month, when will the...
-
The data at right show the pulse rates of 50 people. a. Find the mean and standard deviation of the data and sketch a histogram. b. Sketch a distribution that approximates the histogram. c. Find the...
-
Write a single equation (using only x and y) that is equivalent to each pair of parametric equations. a. x = 2t - 3 y = t + 2 b. x = t2 y = t + 1 c. x = 1/2t + 1 y = t - 2 / 3 d. x = t - 3 y = 2(t -...
-
Which type of business organization is owned by its stockholders? a. Proprietorship b. Partnership C. Corporation d. All the above are owned by stockholders.
-
Consider the overall effects of transactions in questions 5, 6, and 7 on Boardmaster. What is Boardmasters net income or net loss? a. Net income of \($57,000 b. \) Net loss of \($3,000\) C. Net...
-
The income statement reports a. financial position on a specific date. b. results of operations on a specific date. C. financial position for a specific period. d. results of operations for a...
Study smarter with the SolutionInn App