...Databases and Data Communications Scenarios Devin Winston BIS/320 Cornell Perry University of Phoenix November 24, 2014 In the two scenarios provided there are important questions that need to be answered. It is important to think of all the options and come up with the best solution. This essay will try to give insight to a solution that is the best fit for each scenario. Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before a show, you meet with the marketing managers and determine what displays and equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise trade show personnel as they set up the booths and equipment. After the show, you supervise packing the booth and all the equipment as well as schedule its shipment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all the equipment are returned. If there are any problems due to shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a quarter-million dollars of equipment. In order to keep up with the booth components, equipment and shippers, there is information that must be kept up with. The first thing that needs...
Words: 1097 - Pages: 5
...,Determining Databases and Data Communications Determining Databases and Data Communications BIS-320 Business Information Systems December 12, 2011 Determining Databases and Data Communications Scenario 1 Typical fields that you may want to include for booth components are: number of components, Names of components, size, how long it takes to set up, how long it takes breakdown, weight of each piece, and tools required for set up of pieces. Fields that could be used for equipment are: number of equipment pieces going, which shipping container has the piece of equipment, where it is to be located at show, and cost of equipment. Keeping track of the shippers and shipments are very important and some things to track for the would be; Name of Shipper, Cost per shipping container, headquarters’ address and phone number, driver name and contact number, travel time to and from show, and emergency contact number. Some typical fields that you may want to include for shipments are number of pieces per shipping container, number of shipping containers, color code of container (if used), date and time container was loaded, date and time container was unloaded, and location of where the shipment is going. Keeping track of the number of components and equipment in each shipping container, and the number of containers per truck would help in quick check in once at final destination. By numbering the containers, you will know if a container is missing...
Words: 1036 - Pages: 5
...Determining databases and Data Communications Bis/320 September 23, 2013 Dr. Julie Ruse Determining databases and Data Communications Electronic Company To determine ways of managing a trade show booth the individual shall keep certain things in mind about the components, equipment, shippers, shipment, and time to assemble the pertinent equipment for display. Not only setting up the pertinent equipment for display but also need to make selection on setup team, and supervised the trade show personnel. After the show, the individual have to accountable for the equipment, and reconcile to transport back to the main office for the organization to check the components or equipment back into the warehouse. The individual need to make sure there will be no losses or damages on the equipment before check it back into the warehouse. The individual or supervisor are in charge of setting up a consumer electronics trade shown, which mainly consists of products like laptops, cell phones, LCDs monitors, batteries as well as computer and phone accessories. The supervisor needs to make sure that these products are safely return to the organization after the completion of the trade show. There several ways in which the supervisor can categorize these equipment or products into their respective fields. Therefore, the supervisor can keep a track of the merchandise during the shipment to the main office, and the supervisor will become liable to the security of the merchandise...
Words: 1437 - Pages: 6
...BIS 320 Week 3 Individual Assignment Determining Databases and Data Communications (Two Scenarios) (1000 Words, References, APA Format) Determining Databases and Data Communications Scenario 1: The methodology of managing a trade show booth is to keep certain things in mind about the components, equipment and each and every item that is to be transported back to the head office, when you are closing the booth. We are in charge of setting up a consumer electronics trade shown which mainly consists of products like dry batteries, cell phones, laptops, computer accessories, phone accessories and monitor LCDs. We need to make sure that these products are safely returned when the trade show is over. There can be a number of ways in which we to categorize these products into their respective fields so we can keep track of them when shipping them to the main office, because we are liable to the security of these materials. By classifying smaller goods, like dry batteries, we can categorize them into one shipment package that can be transported safely back. Other products like cell phones and their accessories, we can pack them together so we have a safety for the products to remain in one carton. Likewise, keeping computer accessories with laptops and keeping LCDs separate, we can ensure that the products do not get damaged during transportation. Data base system is not that compulsory for managing this equipment, although it is a good thing to have it but...
Words: 1127 - Pages: 5
...Determining Databases and Data Communications N/A BIS/320 August 5, 2014 N/A Scenario One The position of a marketing assistant for a consumer electronics company in charge of trade show booth setup can certainly be a challenge. The marketing assistant is responsible for establishing booth setup and tear-down. This position also requires the management and oversight of equipment worth well over a quarter-million dollars. As a marketing assistant, there will have to be steps taken to alleviate or mitigate any issues that may play a role in hindering the success of the goals put in place. Use of a Database or Excel Spreadsheet An Access database or Excel spreadsheet will have to be created featuring fields that can easily be accessed in order to verify information at all times and in detail. The more fields listed, the easier it will be to find a particular part or location and will enable this information to be easily obtained. The list of relevant fields needed to track important data is contained below. . Equipment Company: Name, telephone number, address, and a point of contact Equipment: Name, model, serial number, location, and weight Shipper: Name, telephone number, address, and a point of contact Booth Components: Booth number, name, model, location, height, size, and weight Advantages and Disadvantages of Access As with any product, there are advantages and disadvantages. Here are some of the advantages and disadvantages of using Access according...
Words: 1109 - Pages: 5
...Determining Databases and Data Communications BIS 320 August 11, 2014 Determining Databases and Data Communications In the first illustration, a marketing assistant for a consumer electronics company is responsible for the task of maintaining booths for trade shows from beginning to end and must resolve any related issues that may arise. There are many things that need to be kept track of including data related to the equipment received for trade shows. Situations such as these required detailed lists of all things involved. For example, the equipment related to the trade show booth would be kept in its own category where they would be listed individually in relation to their utilization purposes for the trade show. Other data would need to be recorded such as detailed information in relation to the condition of the items during the shipping process. The marketing assistant must ensure the booth and its display contents, are brought to their desired location in a timely fashion and taken back securely in order to assure their future use to the company. By having information such as postal tracking numbers, tabs can be kept on the dispatch and retrieval dates, hence being aware of the items locale at all times. Trade shows typically need certain tools for tracking and maintaining the information needed with relation to the equipment being used. A great initial option would be a program such as Excel, to track the necessary data. However, Excel may not be the most effective...
Words: 1026 - Pages: 5
...Determining Databases and Data Communications Scott Powers BIS/320 April 29, 2013 Dr. Julie Johnston Determining Databases and Data Communications A tracking system can be a complicated process, a Microsoft Excel spreadsheet or a Database system is the focus of this study, and the finding are in the following report. The first research conducted analyses a marketing assistance and the tracking systems used. The second part of the research conducted is to analysis the best options for computer access at a small office and how to determine the best system to use. A spreadsheet is attached to view the cost and abilities of each access for the office assistant. Each study took into account the particulate and the needed of the person and the desired outcomes. The first research looked at is the use of spreadsheets with particulars to include equipment, components, and shippers needed at the trade show. The research includes how to track what shippers were used or how many different shippers to use for multiple pieces of inventory and the ease of use of a spreadsheet. This Research also looked into when a database would be better to track the multiple components, equipment, and the shipper data history used. The research conducted will shows what tracking system is a better fit for the marketing assistant to track their inventory during the planning, setup, duration, and shipping of inventory and ultimately the post analysis of a tradeshow? Booth and trade show tracking:...
Words: 1120 - Pages: 5
...Determining Databases and Data Communications Jeremy Timm BIS 320 August 19, 2013 Sharyn Deeringer Determining Databases and Data Communications In the two scenarios there are many ways that they can be solved or worked out to make them fit to the person working with them. They both deal with databases and communications that companies need to consider. In this paper we are going to discuss some of the options that companies or self employed business owners can use. Scenario One Some of the typical fields that could be used would be of the booth equipment by piece, what equipment you will need by piece, what company is shipping the components and the expected arrival date and time. By having all of this information you will be able to use it as a checklist to ensure that you have all the required pieces and components for the trade shows. Being able to track what company the equipment is being shipped through will decrease the probably of the equipment being misplaced at the location of drop off. Along with tracking what company is shipping the equipment you would want to track how much everything costs to be able to charge that company for any losses that might occur. A database system could work the best for some people in this situation but others might be more comfortable with a spreadsheet. We all know that a database is a “self-describing collection of integrated records” (Kroenke, 2012, p. 101). One way a database would be good is that you can print different...
Words: 1027 - Pages: 5
...Determining Databases and Data Communications Lucinda Degarmo BIS/320 November 02, 2015 Karl Jaufmann | Scenario 1 As the marketing assistant, I would definitely have to use a program that would track ordering, delivery and losses of any equipment used. The typical fields that would be needed for such database would be the following: Event Name, Event Date, Name of equipment/display, Serial Number, Date ordered, Date shipped, Date delivered, Date packed, Date shipped, Date received, Loss remarks. The first tracking relationships would be of course the Event Name, Event date and Name of equipment, Date ordered. By tracking these fields, I would be able to figure out what types of equipment or displays to order for the event and ensure timely delivery for the event. The second tracking relationships would be the return of the equipment which would include packing date, shipping date and date received and any losses incurred. By tracking the return of the equipment, I would be sure that the equipment has been accounted for and safely returned back to the warehouse. By using a tracking program for each event, the accountability for the equipment is monitored from the day it leaves the warehouse and is returned safely back to the warehouse. A database would definitely be needed to track the inventory. Excel could handle the tracking input and output; however, since the shipping and receipt of the equipment would not be readily available another database would...
Words: 628 - Pages: 3
...Determining Databases and Data Communications Determining Databases and Data Communications Having a clear understanding of the technologies to implement is an incredible tool for managing companies with computer technology as their primary means of sustainability. This knowledge helps their personnel responsible for information management to make informed decisions about which technology to actually implement. These strategic decisions permit the manager to effectively utilize time and resources in seemingly intimidating tasks. This is shown in both scenarios. In the first scenario a marketing assistant working at a consumer electronics company is tasked with maintaining booths for trade shows from start to finish. In addition that individual is also tasked to resolve any issues related to product shipment that may arise. Knowing what information is to be retained is important in ensuring best tools are used in trade fairs. Situations like these calls for detailed list of displays, equipment, and booths that are necessary and how they are being shipped and retrieved. Let’s say a trade show is to be organized in San Antonio, Texas with a requirement of one booth and display. The marketing assistant must make sure the booth with display is brought to the location in time and taken back for future use to the company. With knowing the delivering postal tracking number, a tab can be kept on the dispatch and retrieval date. Every trade show typically needs certain...
Words: 1031 - Pages: 5
...improve upon their services. With all their success, they can definitely use the help of an information system and information technology to improve their organization. Market research has shown that while Dirt Bikes’ management has allowed it to run successfully up until now, they need to update their management information systems if they want to continue their smooth sailing for the remainder of their time. The information world is constantly changing, and Dirt Bikes needs to change with it. While they have many knowledge assets available to them, they need some knowledge assets that are not currently available to them which would provide more business opportunities in the future. PROBLEMS One issue facing the company is the line of communication between employees. The company has a lot of knowledge assets in the fact that their various teams work with each other to design and manufacture the best dirt bikes. They have been doing this successfully for many years. However, the company currently employs 120 plus employees, and they are still a privately run company. The company can run into many problem with this many employees and no practical way to be on top of them. Further, there is no practical way for an employee in one team or area to quickly contact an employee in another. What happens when an employee in production...
Words: 1695 - Pages: 7
...company in the economic environment we are currently in at the moment. Verbal information - Is the sharing of information between individuals by using speech. Individuals working within a business need to effectively use verbal communication that employs readily understood spoken words, as well as ensuring that the enunciation, stress and tone of voice with which the words are expressed is appropriate. Verbal information ensures that you have a strong relationship and you build a trust between the individual that you are trading with, when making important decisions that affect the whole business you need to make sure that you know the individual of company and their history when you are dealing with them a background check is also important because then you have a reassurance that you will not be ripped off. Business professionals demonstrating effective verbal communication skills use spoken words to convey a message clearly and concisely. To get a message across, the sender needs to ensure the receiver correctly interprets the words. If not, confusion and conflict typically results. By successfully delivering a message, business professionals describe ideas, thoughts and directives that allow colleagues to work better together. Effective verbal communication begins by acknowledging what the audience needs. By planning what he wants to say, how he wants to say it and...
Words: 1508 - Pages: 7
...inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Have no database to keep track of clients. Only way of customer feedback is through cards and they do not reply. Database could do all that for them. They schedule staff by previous seasons. Database could give accurate occupancy. Database could advertise and rent rooms. Front Desk What are the current problems that the Front Desk is having? (multiple choice, multi-select) ☑ System is disconnected from other departments. ☑ Too much manual intervention in the business process. ☑ Required information is not always available. ☑ Information retention is inefficient or non-existent. ☑ Poor use of available information technology resources. ☑ Insufficient use of database technology or tools. ☐ Poor communication. How could a proper database system and subsequent tools serve to improve the issues this department is having? (short answer) Recepts should be logged into computer at once for all departments to view. Reports are printed montyhly and passed around. Information should be in database to be viewed all the time. Information should be monitored by a database for accurancy. Accounting What are the current problems that Accounting is having? (multiple choice, multi-select) ...
Words: 619 - Pages: 3
...Mobile database A mobile database is either a stationary database that can be connected to by a mobile computing device ( eg smartphone and PDA) over a mobile network OR A database, which is actually stored by the mobile device this could be list of contacts, price information distance travelled or any other information Many applications require the ability to download information from an information repository and operate on this information even when out of range or disconnected. An EXAMPLE of this is your contacts and calendar on the phone. In this scenario a user would require access to update information from files in the home directories on a server or customer records from a database. This type of access and work load generated by such users is different from the traditional workloads seen in client-server system of today CONSIDERATION • Mobile users must be able to work without a network connection due to poor or non existent connections. A cache could be maintained to hold recently accessed data and transactions so that they are not lost due to connection failure. Users might not require access to truly live data, only recently modified data, and uploading of changing might be deferred until reconnected • Bandwidth must be conserved (a common requirement on wireless networks that charge per megabyte or data transferred) • Mobile computing devices tend to have slower CPU and limited battery life • Users with multiple device (eg. Smartphone and tablet) need...
Words: 2537 - Pages: 11
...Distributed database is one in which multiple database sites are linked by a communications system in such a way that the data at any site is available to users at other sites. Depending on the needs of an organization the following reasons would be why they would have the needs of distributed databases: * Improved reliability. A distributed system is more reliable than a centralized one, because processing is done at several sites, so failure of a single node does not halt the entire system. Distributed systems can be designed to continue to function despite failure of a node or of a communications link. * Better Data availability. Distributed database systems often provide for replication of data. If a node fails, or the only link to a node is down, its data is still available, provided a copy is kept somewhere else in the system. * Lower communication cost. If data used locally is stored locally, communications cost will be lower, since the network will not be used for most request. In centralized system, the communications network is needed for all remote requests. However, we must consider the additional cost for the database software, additional storage costs for multiple copies of data items and software, higher hardware costs, and higher operating costs the distribution can entail. Distributed database has different types of distributed systems. These systems ate homogeneous and heterogeneous. With homogeneous all modes use the same hardware and software...
Words: 866 - Pages: 4
