/books/9781119373544/cf/6/441/4/2/24/6/4/10/200212 123 Maple Drive, New City. Virginia 02 345 home phone: (435) u5-4454 work: ? cell: 4599 a/o23523 2018 (232) 122-9843 Visa card1234-445h-5433-097 espires (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 Jake is a student at the local university He is taking an AIS course that includes a segment on Microsoft Access He is stil learning about database theory, but thinks that converting the shop's current "accounting systems to a DBMS idea He thinks, for example, that BS N needs a customer table and a vendor (supplier) table. He also thinks that BSN will need an might be a good nventory table to keep track of inventory, but that even more tables might be required. Can you help them? Requrements 1 Identity 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 tdentify the tables that you would need to create a working database for the company's recevables, payables 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 Eigure 15-19 for data felds for the Vendors table should include the vendor ID vendor name and addres number and contact person (3) The data fields for the dozen, each etc) unt cost und retail sales price and quantity on hand the customer record structure (2) The s information phone number fax Inventory table should include item number, item descnpton, units (e g 4 Create relationships for your various tables 5 Document your work by printing the relatonshps window /books/9781119373544/cf/6/441/4/2/24/6/4/10/200212 123 Maple Drive, New City. Virginia 02 345 home phone: (435) u5-4454 work: ? cell: 4599 a/o23523 2018 (232) 122-9843 Visa card1234-445h-5433-097 espires (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 Jake is a student at the local university He is taking an AIS course that includes a segment on Microsoft Access He is stil learning about database theory, but thinks that converting the shop's current "accounting systems to a DBMS idea He thinks, for example, that BS N needs a customer table and a vendor (supplier) table. He also thinks that BSN will need an might be a good nventory table to keep track of inventory, but that even more tables might be required. Can you help them? Requrements 1 Identity 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 tdentify the tables that you would need to create a working database for the company's recevables, payables 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 Eigure 15-19 for data felds for the Vendors table should include the vendor ID vendor name and addres number and contact person (3) The data fields for the dozen, each etc) unt cost und retail sales price and quantity on hand the customer record structure (2) The s information phone number fax Inventory table should include item number, item descnpton, units (e g 4 Create relationships for your various tables 5 Document your work by printing the relatonshps window
