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

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

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

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

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

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

Free Essay

Distributed Systems

...Server Training (16 Courses) Training on how to build and manage SQL Server databases. Our SQL Server Training Courses provide the skills needed to build a solid foundation for SQL Server development. Introduction An overview of DBMS technology * How data is accessed, organized and stored * The database development process * Query and application development tools * CASE tools for database analysis and design * Tables, attributes and relationships * Primary and foreign keys * Relational integrity constraints * Manipulating data: selection, projection, join, union, intersection, difference * An integrated, active data dictionary * The query optimizer * Developing the logical data model * Mapping the data model to the relational model * Specifying integrity constraints * Defining the data in the data dictionary * Capturing entities, attributes and identifiers * Describing relationships: one-to-one, one-to-many, many-to-many * Optional and mandatory relationships * Resolving many-to-many relationships for implementation * Generating the SQL to build the database * Reverse engineering to capture the design of an existing database * SQL Programming Language Introduction 1 Days * Write SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures * Update database content with SQL and transaction handling * Retrieve data with filter conditions and......

Words: 1010 - Pages: 5

Premium Essay

Database Paper

...Database Dictionary.com defines database as “a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated”. In today’s business, organizations run on data that have been processed into information and knowledge. That information is used by managers to apply to business problems and opportunities. Furthermore the data is transformed into knowledge and solutions in many different ways after detail analysis. Because data and information are processed in several stages and often in several places, they are frequently subject to problems and difficulties. Managing data in organizations is difficult for many reasons, so organizations in the effort to manage all of the data, developed databases to organize all of the collection. These databases are managed using database management systems, and by utilizing different applications. In our organization, we do have a database that we use for our data collection and analysis and storage of all the data we collect. We also use several applications in the daily operations of our business which I will explain further in this paper. Our organization is currently using several applications to make our processes more precise, effective and efficient. Currently, our organization is using a Sybase SQL database as the main database for all of our business functions. This database delivers extreme transaction processing and access to mission critical......

Words: 732 - Pages: 3

Premium Essay

Cs251 Fundamantals of Database Systems Ip 1 - 5

...CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline   My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks. We will perform counter sales, contractor and walk-in customer kitchen and bath design, templates, fabrication, installation, and follow-up. To run efficiently (or at all) we must have a centralized DBMS with access for all employees in order to keep track of the progress of the workload and get the products delivered and installed on time. Issues with the process must be immediately known and corrected as this is a high value product with a small profit margin at this point in our economy. Any miscommunication can be disastrous. The MasterStoneWorks database will have the following tables: * Customers * Sales * Installs * Product choices * Costs (wholesale and retail) * Sales people * Project Managers * Templates * Follow-up * Customer support Description of the Database Design Life Cycle The seven steps of the SDLC/DBDSL: 1. Concept Planning – This first step is where the need to develop, or improve a system is......

Words: 1691 - Pages: 7

Premium Essay

Huffman Trucking Driver Log System

...Huffman Trucking Driver’s Log Database Jules Mohr University of Phoenix BSA/310 Business Systems Facilitator: Heather Farnsworth January 22, 2010 Huffman Trucking Driver’s Log Database In this document I will describe the information database that Huffman Trucking uses for their Driver’s Log. The uses and significance of this database are varied including a list of drivers and their records of contact information as well as trip statistics and any moving violations. The Driver’s Log Database is necessary to Huffman Trucking business operations because it allows comparative analysis of driver's violations and trips. The Driver’s Log Database was written for Huffman Trucking by Smith System’s Consulting. This log contains the information for the entire contingent of driver’s employed by the company. The information is input by administrative personnel from interviews with and paper logs kept by the drivers. This database is divided into three disparate sections. The driver’s information section has contact, license, emergency contact, physical, and drug test information on each driver. The Driving Log holds the statistics from each trip. This includes driver information, co-driver information, driving times, sleeping berth times, on duty stop times, off duty time, trailer information, and odometer information. The violations log has the driver’s information as well as the date, state, description, status, and disposition of the violation along with...

Words: 1036 - Pages: 5

Premium Essay

Building an Access Control System

...Building an Access Control System Strayer University CIS 210 Systems Analysis and Development 4/28/13 Scope The scope of this project is to install an access control system (ACS) into a college dormitory. This ACS will automatically unlock the dormitory doors via an electronic proximity reader and integrate with an existing security camera system. The cameras are designed to face and rotate to record a person as they use their identification card to unlock the door. To complete this project we will start with the analysis and design stage. The creation of various design documents will be performed during this stage. The next stage will be the development stage. During this stage we will either create a new database or use the school’s existing database. The 3rd stage will be the integration stage. During this stage, the physical installation of the system will occur. The 4th stage will be the testing stage. The final stage will be the maintenance phase. The maintenance phase is on-going. Major Tasks 1. Analysis and Design a) Design Documentation i. With this task, documentation is written up to describe the work that needs to be completed. This documentation is reviewed by all stake holders to ensure that the requirements are have been accurately conveyed and understood. b) Design Models i. With this task, flow charts and/or use case are created to describe the functionality.......

Words: 508 - Pages: 3

Premium Essay

Strategic Hr

...Query and * Implement database systems. Unit abstract An understanding of: * Database tools and * Database technologies * Database * Complex data structures and interface Databases provide the infrastructure to many organisations and they offer support to key business applications and information systems. The most common database model used commercially is the relational one. The aim of this unit is to: * Provide a knowledge and understanding of database systems, including * Design principles * Practical implementation and development skills for both the system designer and software engineer. The importance of structured query languages should be stressed, in terms of how they can be used to manipulate data and how they are used for a variety of tasks including querying and report writing. On completion of this unit the learner should be able to understand, design, query and implement a database(s). Learners will also have a theoretical insight into the requirement for designing a database that meets a given user or system requirement and that is functional, user friendly and robust. Learning outcomes On successful completion of this unit a learner will: 1. Understand data models and database technologies 2. Be able to design and implement relational database systems 3. Be able to use manipulation and querying tools 4. Be able to test and document relational database systems. Unit......

Words: 576 - Pages: 3

Premium Essay

Data Management

...Database Partitioning JOHN OWENS West Florida University Data Management March 18, 2014 Data partitioning is a tool that can help manage the day-to-day needs of an organization. Each organization has unique values that drive business. All organizations have policies and processes that are influenced by their environment and industry. The use of data partitioning can help productivity by recognizing the need to categorize data to tailor unique needs. This approach does require some effort. To transition to a new database approach, organizations need to assess the pros and cons of a database transition. The scale of an organization’s database may be the one factor that drives an adoption of this approach. Data partitioning has been developed to address issues that traditional database queries have created. One main problem that partitioning was created to solve is the performance of database queries. According to Alsultanny (2010), “System performance is one of the problems where a significant amount of query processing time is spent on full scans of large relational tables. Partitioning of the vertical or horizontal partitioning or a combination of both is a reliable way of solving the problem” (p.273). By separating queries into either horizontal or vertical processes, the user can avoid delays and strains on a database. This saves time which can be used to improve the productivity an organization has towards their day-to-day operations. Large-scale......

Words: 1572 - Pages: 7