Determine Databases And Data Communications Essay

2529 words - 11 pages

Scenario 1:
I am a marketing assistant that is in charge for setting up a trade show. Before setting up a booth, I should keep certain things in mind. I should keep in mind that I am responsible for all the equipment and components that are needed to be transported to the event. I cannot forget about all the components and equipment that were identified to be shipped to the trade show site have to be transported back to the home office after the show is over. The set up team, and I should remember at a typical show, we are responsible for more than a quarter million dollars of equipment. It is very important that we can handle any problems due to shipping damages or loss.
As a marketing ...view middle of the document...

Each item that is categorized can be easily recorded in Excel spreadsheet. Using excel offers many advantages and also disadvantages for the storage of information and retrieving important data. The advantages of using excel are, it is inexpensive and easy to use, portable, can be sent by e-mail, can be locked with password, easier to setup from scratch, and can be synchronized with PDA (personal digital assistant, cable of combining computing, telephoning, faxing, networking) features on cell phones. With such advantages, I can easily communicate with home office on important issues pertaining to product information. The disadvantage of excel is that the virus can be attached to excel file through macros. Micros are mini program that are written into excel spreadsheet. Most applications today allow you to attach macros or scripts to your files. When you share a file with another user, the attached macro or script goes with the file. Research has shown that most macro viruses are designed to run, or attack, when you first open the file ( "Http://msdn.microsoft.com/en-Us/library/cc750846.aspx",). Other disadvantages are; data can be lost or corrupted when user creates subset directory for data; cannot create report like database; restricted to limited number of record; and are not very scalable for accessing and manipulating large volume of data.
I would use the enterprise database instead of a personal database because of the scalability and security options it offers over a personal database. Enterprise database is capable of handling thousand of transactions or more happening at the same time per hour than a personal database. According Kroenke, 2014 p 118, enterprise DBMS products process large organizational and workgroup databases. These products support many, possibly thousands, of users
And many different database applications. Such DBMS products support 24/7 operations and

can manage databases that span dozens of different magnetic disks with hundreds of gigabytes

Or more of data. IBM’s DB2, Microsoft’s SQL Server, and Oracle’s Oracle Database are examples

Of enterprise DBMS products. In comparison personal DBMS products are designed for smaller,

Simpler database applications. Such products are used for personal or small workgroup

applications that involve fewer than 100 users, and normally fewer than 15. In fact, the great

bulk of databases in this category Have only a single user. The professor’s Student database is an

example of a database that is processed by a Personal DBMS product (Kroenke 2014 p118).

Enterprise database is more ideal for business operation while personal database is acceptable for

personal use such as at home. Enterprise database offers the best way to communicate with home

office and to let the company know the status of equipment and components for shipment.

A decision support system...

Other Essays Like Determine Databases and Data Communications

It Midterm Exam Study Guide Essay

3334 words - 14 pages example|c.|DML| b.|Access|d.|SQL| __D__ 73. Someone responsible for planning, designing, creating, operating, securing, monitoring, and maintaining databases is called a ____. a.|data administrator|c.|data owner| b.|data analyst|d.|database administrator| __B__ 74. The ____ position is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply

marketing research Essay

1572 words - 7 pages ) Marketing Research Marketing Research Lecture 9 Business Research Methods. Your Dissertation is actually very similar a marketing research project. Unit 9 1/17 Unit 9 2/17 Customer databases 1 Definitions: Questionnaire Design, Sampling Methods, Sample Size, Data Collection Methods - Graphical / Table Presentation/ Statistical Summaries - Hypothesis Testing - Correlation and regression analysis - Reliability Test, Factor

Review Questions: Chapter 1

2512 words - 11 pages contain virtual data the is derived from the database files but is not explicitly stored. • DBA – a database administrator (short form DBA) is a person responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in an organization. • End User – people whose jobs require access to the database for querying, updating and generating reports; the database primarily exists for their use

Data Management

1592 words - 7 pages through the use of vertical and horizontal partitioning. The use of automatic partitioning is a method the increases speed through customization. Arden (2012) explains, “One technique for automatically restructuring database workloads is to issue queries asynchronously, using program analysis to determine when concurrent queries do not depend on each other, or using data dependency information to batch queries together. Automatic partitioning has

Data Mining

2361 words - 10 pages discovery or knowledge discovery is the procedure that gathers, analyzes and places into perspective useful information. This facilitates the analysis of data from many different perspectives. Bill Palace a graduate student at UCLA offered this definition in his report in 1996 “Technically, data mining is the process of finding correlations or patterns among dozens of fields in large relational databases. (Palace, 2006)” For our purposes we offer this

Walmart Data Warehousse

921 words - 4 pages DATA WAREHOUSE A data warehouse is a logical collection of information gathered from different operational databases and used to create business intelligence that supports decision making tasks and business analysis activities. Walmart is known for having the biggest data warehouse used, which is larger then 4 Petabytes. Wal-Mart is very secretive about their data warehouse. After achieving a major milestone Teradata, Wal-Mart’s data warehouse

Data Management

843 words - 4 pages (including raw data), drafts of scientific papers, plans for future research, peer reviews, or communications with colleagues. Furthermore, data to enable peer review and publication/dissemination and/or to protect intellectual property may be temporarily withheld from distribution and other proposed data management. This plan will make certain that the data produced during the period of this project is appropriately managed to ensure its usability

Databases And A Personal Wallet

1018 words - 5 pages Databases and a Personal Wallet As the world becomes more connected through technology, individuals are quickly losing their privacy. Personal and private information about individuals is contained all over the place. The everyday contents of a personal wallet such as credit cards, driver’s license, membership cards, vehicle registration, and other cards are all associated with various different databases. Many databases exist in today’s

Advantages of a Relational Database

672 words - 3 pages very easy to understand and unlike traditional programming languages does not rely on arcane syntax, rather structured query language uses English like meaningful syntax in its operations. As opposed to flat file databases this logical organization of data across tables in the form of columns greatly simplifies the organization and retrieval of highly complex data. As the business needs of the client rises so will the size and complexity of data

Database Design

653 words - 3 pages information” (Grauer, Mast, & Poatsy, 2011, p. 69). The use of databases vary among business users, but can, and are, used by most computer users on a daily basis. Many computer users have an extensive music, and or, photo collections. These collections are stored in what amounts to extensive databases that manage the location and specifics about each piece of data. Each of these files also include data that is not necessary for individuals to view

Web Database Development

4672 words - 19 pages . The way in which data is input, organised, stored, retrieved and used can be a costly and time consuming process. To avoid wastage of time and costs, a database is used to carry out the process. Databases are an essential aspect of modern life. A database is a collection of information related to a particular subject which is processed. According to Li, Moselhi, and Alkass (2006), a database provides a platform to organise, store and retrieve

Related Papers

Determining Databases And Data Communication Essay

1137 words - 5 pages 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

Communication And Technology Essay

1008 words - 5 pages , and law enforcement personnel depend on receiving accurate and prompt information to perform their duties. Radio communications are limited to only convey information verbally, and dispatchers can only transmit information to one officer at the time. Today, technological advances have made it easier for police departments to identify people through a series of databases that contain people’s personal and criminal history as well as

Relational Databases Introduction To Information Technology

1207 words - 5 pages important, unwanted data that do not serve a purpose must be removed. Normalizing will save space and keep the data organized properly. To normalize a database there are a series of guidelines to follow. These guidelines or stages are called normal forms. There is another refinement form that is used when normalizing databases called the Boyce-Codd normal form (BCNF) or 3.5NF (Mike Chapple, 2013). The normal forms are numbered from one to five

Modular Project Essay

4042 words - 17 pages python. I think the main focus of many NoSQL databases is on horizontal scability various mechanisms and data models,rather than including extra code within the databases. Analysis : NoSQL – SWOT Analysis Strengths Uninterrupted access/high availability Scalability Security and flexibility Freedom to choose Weakness Porting the applications No Normalization, unions or joins Lost updates Opportunities Huge