Premium Essay

Determining Databases

In:

Submitted By cherellypooh
Words 619
Pages 3
Determining Databases and Data Communications
University of Phoenix
BIS 320

Determining Databases and Data Communications
Databases are a “self-describing collection of integrated records” (Kroenke 2014 p 108). The purpose of a database is to “help people keep track of things” (Kroenke 2014 p 107). A few terms that are used in reference to databases are: bytes, columns, fields, rows, records and tables (Kroenke p 108). Bytes are grouped into columns; which are also known as fields and columns or fields in turn are grouped into rows; which are called records (Kroenke p 108). Lastly, a group of similar rows or records are called a table or a file (Kroenke p 108). In scenario one, the information that would be tracked would be the data about booth components, equipment, shippers, and shipment. There are three different relationships: one to one, one to many and many to many. A one to one relationship is not common because most information related in this way would be in one table (Microsoft SQL server). The one to many relationship is the most common type of relationship. “Make a one to many relationship if only one of the related columns is a primary key or has a unique constraint” (Microsoft SQL server). The many to many relationships can have many matching rows. The two relationships that would be used would be the many to many relationships and the one to many relationships. Since we are tracking shipments and shippers, this might overlap because one shipper might ship many shipments or multiple shippers may ship one package each. The reason a many to many relationship would work is because each group has the possibility to overlap. There are many different database systems; however, for this particular one, excel would work find. One of the advantages of using excel is one of the more familiar systems. There are many online tutorials to help users

Similar Documents

Premium Essay

Determining Databases

...Determining Databases and Data Communications Laura Dowell BIS/320 March 18, 2013 Martin Mueller Determining Databases and Data Communications A manager in today’s business environment must have the skills and knowledge to play a role in a variety of departments. Even if he or she is not an expert in the information technology field, a basic understanding of the tools and terminology is a must-have. This understanding can be useful in clearing out some of the options which are obviously untenable and narrow decisions to a limited number of viable options. The scenarios below demonstrate how a basic knowledge of software application and network design can simplify decisions that would perplex many individuals. SCENARIO 1 In the first scenario a marketing assistant for a consumer electronics company is responsible for managing the displays used at industry trade shows. This person must identify the necessary components and equipment and make sure they get shipped to the trade show in a timely manner. Once the shipment arrives at the trade show, the assistant is responsible for verifying the condition of each item and overseeing the set-up and functionality of the display. At the conclusion of the trade show, the assistant makes sure that each piece ships back to the company and is put back into stock at the warehouse in the same condition as when it originally left. This assistant is also in charge of following up on any problems resulting from shipping damage. There...

Words: 1197 - Pages: 5

Premium Essay

Determining Databases and Data Communication

...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

Free Essay

Determining Databases and Data Communications

...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...

Words: 628 - Pages: 3

Premium Essay

Determining Databases and Data Communications

...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

Premium Essay

Determining Databases and Data Communications

...,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

Premium Essay

Determining Databases and Data Communications

...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

Free Essay

Determining Databases

...Determining Databases and Data Communications Scenario 1 What are the typical fields needed to track data for booth components, equipment, and shipments? Booth Components – Names of components, Serial numbers of equipment and manufacture information, Approximately how long does it take to set up, Where it is being shipped from and where it is being shipped to and what type of shipment is being used and price of equipment. Also what is the weight and size of components being delivered and scheduled time of delivery. Equipment – Equipment would have the same fields as booth components except need tracking system to now where is equipment is located and in what order each piece of equipment will be showcased. Shipments – Shippers name, address, and contact information, shipment warranty information, scheduled delivery and pickup times. Something that is contained on our shipment boxes is how many pieces are being shipped and how to handle equipment because some electronic equipment needs to be handled with care. Example of two relationships that need to be tracked. The first relationship that needs to be tracked is between the shippers and equipment being shipped. Marketing assistant needs to keep track of shipping information to determine when shipment will arrive and to coordinate movement of equipment. The second relationship that needs to be tracked is between personnel that supervised the set up and breakdown and booth components. In order to account for booth components...

Words: 328 - Pages: 2

Free Essay

Determining Databases

...Determining Databases and Data Communication Alfredo Rios BIS/320 May 18, 2015 Eileen Buckholtz Determining Databases and Data Communication Tracking equipment and schedules is crucial when overseeing a project such as scenario 1 describes. Hardware like computers, tablets, and Software like Excel, make the job easier to perform. In scenario 2, a company with employees and various forms of needed equipment; an owner or manager has the needed to view options and cost effectiveness to make the right decisions and progress the company in a positive manner. Scenario 1 Excel may be used to track the in the following manner: |Booth Tracking 2015 | | | | | | | | | | | | |Equipment |Arrival-In |Shipper |Cost |Departure-out |Cost | |Booth Tent |Yes |Fed-ex |$50.00 |yes |$50.00 | |Screen |yes |Fed-ex |$20.00 |yes |$20.00 | |Modems |Yes |Fed-ex |$15.00 |yes |$15.00 | |Monitors |Yes |Fed-ex |$30.00 |yes |$30.00 | |Cables |Yes |Fed-ex |$30...

Words: 906 - Pages: 4

Free Essay

Determining Databases and Data Communication

...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

Free Essay

Determining Databases and Data Communications

...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

Premium Essay

Determining Databases and Data Communications

...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

Free Essay

Determining Databases and Data Communications

...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

Premium Essay

Week 3 Determining Databases Scenario 1 and 2

...Determining Databases and Data Communications Tasha Carson BIS/320 3/14/2016 Professor Rita Solomon-Moore 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 it gets costly, when we can easily keep...

Words: 1125 - Pages: 5

Premium Essay

Database Encryptin Solution

...Database Encryption Solution Introduction Critical data in a database needs to be protected against internal and external threats. A database encryption solution can be used to achieve this protection in addition to providing the regulatory requirements. In the past, access control was used as a means of protecting information against access by unauthorized users. Access control did not prove very effective and this has led to the adoption of encryption where information is transformed into some form that cannot be understood by unauthorized users. Decryption is the process by which the transformed text is retransformed into a form that can be understood. This paper will seek to analyze a database encryption solution that will protect critical data against internal and external threats and at the same time meet regulatory requirements. 2. Choosing the Point of Encryption Encryption can be done at different places within an enterprise. Encryption is used to minimize the number of people who access the encryption keys. Before encryption, implementation decisions needs to be made (Mattsson, (2005, p.2). The most important thing is choosing the point of implementation. This helps in determining the work that needs to be done so that integration is effective and also determining the security model. Data needs to be protected both when at rest and during movement between applications and the database. 2. 1. Database-Layer Encryption In this case, an enterprise...

Words: 1274 - Pages: 6

Premium Essay

Docx

...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 sheets for the booth components and equipment that you are using at the trade shows. This would allow you...

Words: 341 - Pages: 2