Premium Essay

Database Analysis

In: Computers and Technology

Submitted By clnorris
Words 706
Pages 3
Databases are powerful tools that can provide businesses with an edge over the competition. Databases can help keep track of, inventory, billing, payroll, phone numbers, and much more. Databases are essential for almost every company in today's business world. The company that I used to work for custom built their database in-house to suit their business needs. The company uses Oracle, SQL, and Microsoft Access. The company asked me to develop a helpdesk database using SQL and Microsoft Access. The server-based database that the company uses is the Structured Query Language (SQL) Server to run security. One of the draw backs of the server is that it has many security problems that constantly need to be patched. These patches are important to keep integrity of the data and security and should be scheduled to be applied on regular bases. Microsoft Access is a relational database management system which, allows users to create, edit, and maintain sophisticated databases. When developing the helpdesk database I found the wizard to be easy to use and helpful when creating the tables, data entry screens, display screens, and generating reports. The visual capabilities are user friendly and the user does not need to have programming experience. The wizard is an excellent internal tool to help the user with creating data entry forms and display screens. Microsoft Access also has its security problems. Microsoft Access is restricted to how much data can be stored before needing to be purged which, caused problems with the helpdesk database. When the data reached about two gigabytes, it started to function intermittently and used up many of the workstation's resources. They wanted to keep a history of the problems so that when they in countered the same problem it was easily accessed and displayed on the screen. They wanted to generate reports of hardware problems versus…...

Similar Documents

Premium Essay

Database Analysis

...Running Head: Database Analysis Database Analysis Derek Smith University Of Phoenix CIS/205 Steven Schulman October 11, 2010 Database Analysis I have a friend who works for a company that has four international offices in the USA, Europe, and Japan, and two factories in China. They specialize in providing customized products for any organization, targeting school spirit teams. Their products consist of spirit items such as their cheer sticks, hats, duffel bags, bears, flip-flops, and cheerleading accessories. A Database is used to store, manage, and retrieve data, which is throughout a company, which can be created and collected by a number of individuals using different methods and devices (Rainer & Cegielski, 2007). Each section of the database has its specific function. If databases did not exist, their company would have to revert to paperwork that would slow down productivity. Employees would then have to hand write and draft everything on paper. As a result, they also will have to make several phone calls and rely on faxes to accomplish a simple task. Because they do use a database, their employees can have access to information instantly. This paper highlights the three databases that their company uses: GoldMine, Macromedia Dreamweaver, and Microsoft Excel. They require the use of GoldMine for maintaining customer contact information. This information includes customer name, phone number, delivery address, e-mail, type of organization, and a......

Words: 767 - Pages: 4

Premium Essay

Database Analysis

...Database Analysis Paper Angel Vega CIS/205 7/14/2011 Prof. Allen Database Analysis Paper The Countertop Guys is an organization located in Fort Lauderdale, Florida that provides service to The Home Depot and Lowes stores as a countertop and cabinet manufacturer. This small business currently covers all South Florida and part of the Treasure Coast. The Countertop Guys uses a SQL Database to keep up with the manufacturing, customer service and work order processing. The database application used is Filemaker Pro and this application enables the users to keep track of work orders status, material daily production reports among others. Microsoft SQL Server also allows user-defined composite types (UDTs) to be defined and used. It also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). In addition to tables, a database can also contain other objects including views, stored procedures, indexes and constraints, along with a transaction log. A SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB. The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with an .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension. Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. A page is the......

Words: 930 - Pages: 4

Premium Essay

Database Analysis

...Database Analysis Paper Daltrin L Wardell University of Phoenix CIS 319 8/30/2010 ABSTRACT Good Sportsman Marketing utilizes several software programs and a database system which is named Navision to operate its daily business. In the following paper I will outline and describe some of the Navision’s strengths as well as some of its weaknesses. Navision is the database management system that Good Sportsman Marketing’s IT personnel chose because of its ability to grow along with the company. There are several options on the market when it comes to deciding on a DBMS, the key is to make sure that the system you choose meets the business needs. The Navision Database system is the first line of contact for most of the customers that engage in business with Good Sportsman Marketing. The Navision database has a field in which all a customer’s basic contact information is entered. A customer service representative can begin a call by asking a customer that has called in to provide a phone number, their name, or their zip code so that the representative can check the database and see if that particular customer has called in before. The system will detail exactly what transactions may have occurred with that particular customer and can also help a representative lead into a sale of accessories or components. This feature is one of Navision’s strengths. This feature will assist the representative in making sure that the customer’s current information is accurate. A......

Words: 858 - Pages: 4

Premium Essay

Database Analysis and Modeling

...USE OF DATA ANALYSIS IN MODELING Use of Data Analysis in Modeling Michael Matthews CIS 331: System Modeling Theory Strayer University Mark O’Connell, PHD March 5, 2013 The term “model” refers to a process of creating a representation of reality and working with this simplified representation in order to understand or control some part of the world (Barker, Powell 2004 pg. 11). A model can be used in varies ways such as business plains, forming a database, or building a structure. It can also be formed mentally, visually, and mathematically especially by data analysis. Data analysis is the process of raw data measured in order to determine the means based on that data. Although, data is relevant in producing a model, it is only used to provide general perspective of information, not to form a solution. By determining this objective, I will demonstrate the use of data analysis to form a model and the advantages and disadvantages that come with it. The techniques of a model are used constantly to understand the world and to predict the outcomes and actions. For example, a mental model come into play when one manager has to decide is hiring an older worker beneficial to the company. Another manager suggests that hiring older workers is a good idea because they bring valuable experience to the job. This mental model is the basis of decision making, one action forming an outcome (Barker, Powell 2004). The decision that is made, the advantage and disadvantage of......

Words: 827 - Pages: 4

Free Essay

Database Environment Analysis

...MEMORANDUM SUBJECT: Library Database Environment DATE: Tuesday, March 1, 2016 Analysis of the Database environment This environment in which this database is based on is a library.it seeks to look into a library setting and all attributes associated with a library. Basically a library contains documentation for reference, research and learning purposes with a variety of fields to look into. Some may also have archived materials that are still being used. Current libraries have a section where you can access materials like newspapers to catch up with news updates. This database will use a MYSQL environment to manage the data related to the library and Delphi in designing the interface Problems and constraints The existing library has a category of sections from which reference materials for research and learning can be obtained. Unfortunately no systematic sorting has been done to categorize books in each section. This makes it some worth difficult and time consuming to find a specific book of interest within the sections Objectives of the database environment The objectives of the database environment are enlisted below * Provide an all-in-one system for accessing reference materials * Develop a system that will store user details and item details * Create an easy to understand and friendly environment * Develop a system that can replace the manual library management system * Provide borrow and return records * Provide user access levels(i.e...

Words: 469 - Pages: 2

Free Essay

An Analysis of Xml Database Solutions for the Management

...An Analysis of XML Database Solutions for the Management Of MPEG-7 Media Descriptions MOHSIN ARSALAN SZABIST KARACHI, PAKISTAN Abstract: MPEG-7 based applications will be set up in the near future due to its promising standard for the description of multimedia contents. Therefore management of large amount of mpeg-7 complaint media description is what is needed. Mpeg documents are XML documents with media description schemes defined in xml schema. In this paper are mentioned some of the solutions that help make a management system for mpeg-7. Furthermore these solutions are compared and analyzed. The result shows how limited today’s databases are, when comes the case of mpeg-7. Keywords: MPEG-7, XML, SCHEMA 1. INTRODUCTION The paper is organized in the following manner that sec1 is the introduction to what mpeg-7 is. Then the solutions for its management are mentioned. Then the solutions are analyzed and finally in the end the conclusion is mentioned. 1.1. MPEG-7: Mpeg (moving picture expert group) is the creator of the well known mpeg1 and mpeg2 and mpeg4. Mpeg-7 is an ISO standard which is developed by mpeg group. The mpeg-7 standard formally named “multimedia content description interface” provides a rich of standardized tools which describes a multimedia content. Humans as well as automatic systems process audiovisual information which is within the mpeg7 scope. Audiovisual description tools (the metadata elements and their structure and......

Words: 1061 - Pages: 5

Premium Essay

Clarifying Business Strategy Through Database Analysis

...|Title |IT205 Smart Scenario - Clarifying Business Strategy Through Database Analysis | |Event Coordinator | |What are the current problems that the Event Coordinator 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. ...

Words: 861 - Pages: 4

Free Essay

Assignment and Essay.... Others)Information Technology (Programming/ Languages (Java, C++, Vb,.Net, & Etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ It & Society/ and.

...ASSIGNMENT and ESSAY. ... others)Information Technology (Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runs as an ... - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runsASSIGNMENT and ESSAY. ... others)Information Technology (Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexiASSIGNMENT and ESSAY. ... others)Information Technology (Programming/ Languages (Java, C++, VB, .NET, & etc)/Database Design/ Computer Networking/ System Analysis/ Project Management/Project Development/ IT & Society/ and. - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged environment. ..... Sorry, I had to laugh at that paper! ... Java on the other hand is cross-platform, and also traditionally runs as an ... - NET programmers continue to struggle with the complexities of a hybrid managed/unmanaged......

Words: 784 - Pages: 4

Premium Essay

It205 Smart Scenario - Clarifying Business Strategy Through Database Analysis

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

Words: 619 - Pages: 3

Premium Essay

Intro

...Business Strategy Through Database Analysis xnx IT205-01 Clarifying Business Strategy Through Database Analysis vvv IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01 Clarifying Business Strategy Through Database Analysis IT205-01......

Words: 650 - Pages: 3

Premium Essay

Trends in Information Analysis & Data Management

...Trends in Information Analysis and Data Management Trends in Information Analysis and Data Management Over the last decade, advancements in digital technology have enabled companies to collect huge amounts of new information. This data is so large in scope, it has traditionally been difficult to process and analyze this information using standard database management systems such as SQL. The commoditization of computer technology has created a new paradigm in which data can be analyzed more efficiently and effectively than ever before. This report analyzes the some of the most important changes that are currently taking place within this new paradigm. The first part of this report covers trends in database analysis by analyzing the field of data mining. The report covers the topic of data mining by providing an explanation of it, and then by providing examples of real-world examples of data mining technology. Benefits and challenges of data mining are then provided. The second part of the report outlines an even more recent trend in data science, which is the increasing usage of noSQL databases to analyze “big data,” also referred to web-scale datasets. The most recent and major technological developments in the industry are then provided and described. Data Mining Background & Definition Data mining involves the process of discovering and extracting new knowledge from the analysis of large data sets. This is most often done through the use of data mining......

Words: 2546 - Pages: 11

Premium Essay

Data Management

...computer processing that enables a Big data analytics Data modeling Ad hoc analysis user to easily and selectively extract and view data from different points of view. For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Data visualization Extract, transform, load (ETL) Florida in the same time period. To facilitate this kind of analysis, OLAP data is stored in a multidimensional database. Whereas a relational database can be thought of as two-dimensional, a multidimensional database considers each data attribute (such as product, geographic sales region, and time Association rules (in data mining) Relational database period) as a separate "dimension." OLAP software can locate the intersection of dimensions (all products sold in the Eastern region above a certain price during a certain time period) and display them. Attributes such as time periods can be broken down into subattributes. Denormalization OLAP can be used for data mining or the discovery of previously Master data management (MDM) undiscerned relationships between data items. An OLAP database does not Predictive modeling needed for trend analysis. Using Open Database Connectivity (ODBC), data need to be as large as a data......

Words: 4616 - Pages: 19

Premium Essay

"Enterprise Level Data Work Flows and Data Warehouse

...whom this project would have been a distant reality. We also extend our heartfelt thanks to our family and well wishers. I would like to take this occasion to specially thank University of Northern Virginia to provide us with excellent faculty and also in supporting us getting quality education remotely. Contents SL No Title Page no 1 Abstract 5 2 Introduction to Databases 6 3 OLTP and OLAP Systems 7 4 Difference between OLTP and OLAP 9 5 Data Modeling 13 6 Workflows in Enterprise level Data warehousing 18 7 Business Intelligence tools used in Data flow and Data Warehousing 21 8 Analysis in Data warehousing 24 9 Conclusion 28 10 Foot Note 30 11 References 31 ABSTRACT These days majority of the applications, may it be web applications or windows applications or mobile applications, are completely database dependent. Most of the application developments are becoming database driven environments, hence rendering databases as one of the most key elements in a software environment. This dependency on databases can attributed to the increasing number of data requirements from the users. A large amount of data has to be stored and it should be stored at a different level of granularity. In order to achieve this, a specific methodology has to be followed in order to store, retrieve and analyze data at different levels. Basic Idea of the Research: The basic idea of the Research is to find out the different......

Words: 6349 - Pages: 26

Premium Essay

Sdlc

...be made? Analysis In this phase is the group that has been placed in charge of the project must decide if the project should initialize with the resources available. This also includes looking at any existing system to see what it is doing for the organization and how well that system is doing its job. Feasibility is also considered in this phase which gives rise to questions such as: Can the system be created with the resources presently available? Will the system significantly improve the organization? Does the old system even need to be replaced? Design This phase involves the actual creation and design of a system. This is where the team puts together the different pieces that will create the system. In a database approach, this would include the server hosting the database, software that will form the database, other needed Database Management System software. Implementation This phase involves the actual construction and installation of a system. Implementation also includes the maintenance of the system and any future updates or expansion of the system. With the database project example, the following activities are examples of what would be common: * Physical installation of the server hosting the database * Installation of the database onto the system * Installation of the Database Management System Maintenance The database administrator must be prepared to perform routine maintenance activities within the database. Some......

Words: 651 - Pages: 3

Premium Essay

Introduction to Data Mining

...New Jersey Institute of Technology / Data Management: Its Evolution  1960s: – File management and network DBMS  1970s: – Relational DBMS  1980s: 980s – Non-first normal form, extended-relational, OO, deductive databases and application-oriented DBMS pp (spatial, scientific, CAD/CAM, etc.)  1990s - present: p – Data mining, digital library, and Web databases – Cloud databases, data science, and Big Data Data Mining © Jason Wang 2 Data Mining: Its Definition  Data mining (knowledge discovery in databases): ) – Extraction of interesting (non-trivial, implicit, previously unknown and potentially useful) information or patterns from data in large databases  Alternative names: – Knowledge discovery (mining) in databases (KDD), knowledge extraction, data/pattern analysis, analysis data archeology, data dredging archeology dredging, information harvesting, etc. Data Mining © Jason Wang 3 Data Mining: A Multidisciplinary Field  Pattern Recognition  Machine Learning  Databases  St ti ti Statistics  Information Visualization Data Mining © Jason Wang 4 Data to be mined  Text databases  Web databases  Scientific and biological databases  Transactional databases Data Mining © Jason Wang 5 Knowledge to be discovered K l d t b di d  Association (correlation) – Multi-dimensional vs. single-dimensional association – age(X “20 29”) ^ income(X “20 29K”)  buys(X “PC”) age(X, 20..29 )......

Words: 687 - Pages: 3