...,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 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 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 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 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 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 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
...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
...business environment has an increasing need for distributed database and client/server applications as the desire for reliable, scalable and accessible information is steadily rising. Distributed database systems provide an improvement on communication and data processing due to its data distribution throughout different network sites. Not only is data access faster, but a single-point of failure is less likely to occur, and it provides local control of data for users. However, there is some complexity when attempting to manage and control distributed database systems. The DDBMS synchronizes all the data periodically, and in cases where multiple users must access the same data, ensures that updates and deletes performed on the data at one location will be automatically reflected in the data stored elsewhere. A distributed database can also be defined as a collection of multiple, logically interrelated databases distributed over a computer network. A distributed database management system is then defined as the software system that permits the management of the distributed databases and makes this distribution transparent to the users. Distributed database system is to referred as a combination of the distributed databases and the distributed DBMS Current trends in multi-tier client/server networks make DDBS an appropriated solution to provide access to and control over localized databases. Oracle, as a leading Database Management System (DBMS) vendor employs the two-phase commit...
Words: 3658 - Pages: 15
...Technology and Communication Paper University of Phoenix CJA/304 Mrs. Palmer August 10, 2011 Technology and Communication Paper Technology has helped enhance communication between others and has especially helped with communication in the criminal justice system. Technology has affected the communication capabilities of specialized databases in the criminal justice system in many different ways. Many forms of technology are used to help with communication such as mobile data terminals and iris scans in the criminal justice system. In this paper, this student will compare different types of specialized databases and will also discuss over positive and negative effects due to new technologies. Mobile data terminals are used in the criminal justice system as a form of specialized database to help with communication. “A mobile data terminal (MDT) is a computerized device used in public transit vehicles and emergency vehicles to communicate with a central dispatch office” (Versaterm, 2011). There are many large police agencies that require all law enforcement officers to have a wireless mobile terminal system installed in their vehicles. This database can help law enforcement officers with workload management in the communication center and they can also help better time management of officers and help greater efficiency. Mobile data terminals can also help with communication between officers and dispatch by letting the officers have access to dispatch receipts...
Words: 1044 - Pages: 5
...Illuminated Communications IST210 SEC002 Table of Contents Executive Summary 3 Scope of Work 4 Project Management 5 Project Resources and Budget 8 User Analysis 10 Organization of Data 14 Database Administration 17 Database Backup and Recovery 19 Legal Issues 22 Works Cited 25 Appendix A – DDL Script 26 Appendix B – Sample Reporting 37 Executive Summary Illuminated Communications offers this solution to meet the growing demands of Flix2You. We understand the limitations of the existing database design and have proposed a new design that will provide Flix2You a more robust database environment intended to capture more customer data. This will address the primary concerns of Flix2You and allow for the understanding of its customer’s habits that it seeks to gain. Included in this document you will find our scope of work, as it has been determined based on the requirements that have been provided. With that we developed a project plan highlight the major milestones from project start to final sign off. Please note that Illuminated Communications will provide comprehensive testing, training, and support past go live to ensure our solution meet the demands of Flix2You. Understanding Flix2You users is important to our design process. We have included an in-depth user analysis to help us build our system to support the needs of all Flix2You user from upper management personnel to database administrators. Illuminated Communications has several...
Words: 5807 - Pages: 24
...Human Resources Data Migration Project Implementation Plan Human Resources Data Migration Project Implementation Plan Project Group 1: Information Technology Group March 4, 2013 Project Group 1: Information Technology Group March 4, 2013 VERSION HISTORY Version # | ImplementedBy | RevisionDate | RequestedBy | ApprovedBy | Description of Change | 1.0 | student | 03-04-2013 | | | Preliminary draft | | | | | | | | | | | | | | | | | | | Table of Contents 1.1 Purpose 4 1.2 System Overview 4 1.2.1 System Description 4 1.2.2 Assumptions and Constraints 4 1.2.3 System Organization 5 2 Management Overview 5 2.1 Problem Statement 5 2.2 Description of Implementation 6 2.3 Points-of-Contact 6 2.4 Major Tasks 7 2.4.1 Project Tasks 7 2.4.2 MS Access to Oracle Tasks 7 2.4.3 Oracle to Mongo Tasks 7 2.5 Implementation Schedule 8 2.6 Security and Privacy 8 2.6.1 System Security Features 8 2.6.2 Security Set Up During Implementation 8 3 Implementation Support 8 3.1 Hardware, Software, Facilities, and Materials 9 3.1.1 Hardware 9 3.1.2 Software 9 3.1.3 Facility 9 3.1.4 Materials 9 3.2 Documentation 9 3.3 Personnel 9 3.3.1 Staffing Requirements 9 3.3.2 Training of Implementation staff 9 3.4 Outstanding Issues 10 3.5 Implementation Impact 10 3.6 Communications Plan 10 3.7 Change Management 12 4 Implementation Risks and Contingencies 13 4.1 Technical Risks and Contingencies 13 5 Acceptance Criteria 14 ...
Words: 4932 - Pages: 20
