Determining Databases and Data Communications
April Page
BIS 320
August 3, 2015

Determining Databases and Data Communications
Scenario One
Marketing assistant of Apple, April Page has been asked to take charge of setting up a booth at the local trade show being held in Charlottesville, Virginia. Organization is one of her strengths along with strategic planning through the use of Microsoft Access. Being she is the only one that needs this data the personal access database is all that is required. If there is anyone requesting information regarding a specific shipment or a piece of equipment can contact her to obtain a report. Referencing data in a remote table can be linked in multiple places. “The table designs also impose structure that lends itself to data types, validation and consistency for higher quality than what normally exists in spreadsheets.”(Chung, 2015) She will be creating a table that list all equipment being displayed at the component booth the day of the trade show, along with transportation specialist and tracking shipments. She will also be recording the condition each piece of equipment is in before packaging up for shipment to the show. The same scenario will be repeated before packing up the booth to be shipped back to the home office. She has several personnel scheduled to attend and help her manage the booth at the trade show. The equipment being packaged such as: Macs, IPads, iPhones, and Watches, will be placed in to categories. Per each category she has set up a set of questions that will be answered and documented before the packages are picked up for shipment. These questions consist of:
(a) How many of each items are being shipped from the office to the event? (Macs 3, IPads 3, iPhones 4 and Watches 6)
(b) How many of each item are being shipped from the event back the office? (Macs 3, IPads 3, iPhones 4 and Watches 6)
(c) Condition of each item at time of packaging?
(i) From the office to the show
(ii) From the show to the office
(d) How the item is being packaged/secured for shipment?
(i) From office to the show
(ii) From the show to the office
• Shipper: Logistic Company chosen
(a) FedEx
(i) Shipments estimated time for pickup from the office to the event: (5 am on August 1, 205)
(ii) Shipments estimated arrival time to the event: (6:30 am August 1, 2015)
(iii) Shipments estimated time for pickup from the event back to the office: (7 pm August 1, 2015)
(iv) Shipments estimated arrival time to the office: (8:30 pm August 1, 2015)
1. Reported damage claims
2. On time delivery statistics
Questions that require just numbers entered she chose to use text box choice. Drop down box options for those questions that require more description such as condition of an item at the time of packaging. Choices would be: Fair, Poor, Good, and Excellent.
Two relationships that can be tracked are shippers to reported damage claims and shippers to on time delivery statistics. Excel could be used in this sense but she finds there are more disadvantages to excel then advantages. The advantage of “Excel makes it easy to store data, perform numerical calculations, format cells, and adjust layouts to generate the output and reports to share with others. Advanced features such as subtotals, power pivot tables and pivot charts, analysis toolkit, and many templates make it easy to accomplish a wide range of tasks. It can even integrate with the Analytic Services (Business Intelligence) from SQL Server. Tweaking the results is also very easy to get the exact layout, fonts, colors, etc.”(Chung, 2015) Disadvantages is it also does not provide the reports that Access does either. It is not a great tool to use when collecting data over a long period of time and needing to produce statistical reports. A decision support system would not be helpful for this type of planning because no graphical information is required. This is a simple event that only requires simple data usage and results.
Thanks to the excellent staff she had working with her at the event all the items were unpacked and found to be in excellent condition. During the event all staff handled all items with care while making demo presentations to the customers that visited their booth all throughout the day. At the end of the day when it was time to pack up the check list was then repeated again before FedEx arrived for