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

Database

...The parts of the system analysis and design are preliminary investigation, system analysis, system design, system developments, system implantations, and system maintenance. The preliminary system is the one of the most tedious task is to recognize the real problem of the pre-installed system. In this stage the analyst makes a survey by gathering all the available information needed for the system elements and allocation of the requirements to the software. The system analysis understands the nature of the information and the functions of the software which is required for the system. The analyst makes a brief survey of the requirements and tries to analyze the performance of the system which is to be developed. The system of design The analyst actually makes number of designs of the system on paper or on the computer and sees to it that the rough image made of the system comprises of all the requirements or not. System coding is the analyst translates the code or the programs in such a way that they become in machine readable form. Once the system is done with the coding stage it tests the systems and sees to it that it is working as per the expectations or not. System implantation is one of the most vital phases as in this phase the analyst actually gives the system to the customer and expects for a positive feedback. Finally, the system maintenance is that the analyst needs to maintain the system and see to it that it working within the standards set. He needs to maintain......

Words: 368 - Pages: 2

Database

...Client/Server is a system. It is not just hardware or software. It is not necessarily a program that comes in a box to be installed onto your computer’s hard drive. Client/Server is a conglomeration of computer equipment, infrastructure, and software programs working together to accomplish computing tasks which enable their users to be more efficient and productive. Client/Server applications can be distinguished by the nature of the service or type of solutions they provide. Client/Server Computing is new technology that yields solutions to many data management problems faced by modern organizations. Client/Server Computing: An Introduction, features objective evaluations and details of Client/Server development tools, used operating system, database management system and its mechanism in respect of Client/Server computing and network components used in order to build effective Client/Server applications. vi Preface Last but not the least, this work is primarily a joint work with a number of fellow teacher who have worked with us. My parents, wife Meera, and our children, Akanksha and Harsh. I am particularly grateful to Dr. A. P. Singh, Principal, Udai Pratap Inter College, Varanasi; Dr. D. S. Yadav, Sr. Lecturer, Department of Computer Science and Engineering, IET, Lucknow; Dr. A. K. Naiyak, Director IIBM, Patna, former President of IT and Computer Science Section of Indian Science Congress Association; Prof. A. K. Agrawal, Professor and Ex-Head of Department,......

Words: 79055 - Pages: 317

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

Database

...IT203 Database Development GRADED ASSIGNMENTS ------------------------------------------------- Graded Assignment Requirements This document includes all of the assignment requirements for the graded assignments in this course. Your instructor will provide the details about when each assignment is due. Unit 1 Assignment 1: Homework Learning Objectives and Outcomes Describe the role of software for computers. Identify the hardware associated with a computer. Describe how computers store data. Explain how programs work. Differentiate among machine language, assembly language, and high-level languages. Differentiate between compilers and interpreters. Identify the different types of software. Assignment Requirements Answer the following true-or-false questions. Required Resources * Textbook Submission Requirements Submit your answers on the answer sheet provided to your instructor at the beginning of Unit 2. Unit 1 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) At its simplest, a database can be seen as a collection of related data. 2) A delimited file is a file where the length of the file is limited. 3) A delimited file is one in which the data is separated by a character such as a comma. 4) All fixed length files are of the same length. 5) In relational databases, logical design is kept separate from physical design. 6) A......

Words: 7907 - Pages: 32

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

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

Database

...CHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?</para></question><question id="ch04ques02" label="4.2"> Databases are possible because of their database management system (DBMS). As shown in Figure 4.2, the DBMS is a software program that sits between the actual data stored in the system and the application programs that use the data. As shown in Figure 4.4, this allows users to separate the way they view the data (called the logical view) from the way the data is actually stored (the physical view). The DBMS interprets the users' requests and retrieves, manipulates, or stores the data as needed. The two distinct views separate the applications from the physical information, providing increased flexibility in applications, improved data security, and ease of use. In a database system, the manager will rarely need to understand or be familiar with the physical view of the data. Nor, in most instances, will the internal auditor and the programmer as most everything they do involves the......

Words: 4830 - Pages: 20

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

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

It205 Smart Scenario – Clarifying Business Strategy Through Database Analysis

...IT205 Smart Scenario – Clarifying Business Strategy Through Database Analysis Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/205-week-3-smart-scenario-clarifying-business-strategy-database-analysis/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) TO DOWNLOAD COMPLETE TUTORIAL HIT PURCHASE BUTTON IT205 Smart Scenario – Clarifying Business Strategy Through Database Analysis Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/205-week-3-smart-scenario-clarifying-business-strategy-database-analysis/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search Bar (http://hwguiders.com/ ) TO DOWNLOAD COMPLETE TUTORIAL HIT PURCHASE BUTTON IT205 Smart Scenario – Clarifying Business Strategy Through Database Analysis Get Tutorial by Clicking on the link below or Copy Paste Link in Your Browser http://hwguiders.com/downloads/205-week-3-smart-scenario-clarifying-business-strategy-database-analysis/ For More Courses and Exams use this form ( http://hwguiders.com/contact-us/ ) Feel Free to Search your Class through Our Product Categories or From Our Search......

Words: 1596 - Pages: 7

Database

...may create and / or assume all necessary assumptions needed for the completion of this assignment. You are currently the Chief Information Officer (CIO) for an innovative Internet-based company with gross revenues of more than $35 million dollars per year. During an executive leadership meeting, you were told that your company will be merging with a multinational company of equal size and you will be responsible for developing a project plan to strategically integrate all systems, including databases and infrastructure. The Chief Executive Officer has given you sixty (60) days to deliver an information technology project plan in anticipation of the company merger. Your company will be expanding from one (1) floor to three (3) floors within six (6) months. Since this merger will be bringing two (2) fairly equal-sized companies together under one roof, the infrastructure must be redesigned to accommodate the increased needs. Your company currently uses operational systems and relational databases but desires to expand into data warehousing. All information technology (hardware and software) must be redesigned to meet organizational needs. The solution should be implemented in either a hosted solution, on-site solution, or a hybrid model. The CEO is expecting you to integrate different technologies from different solution providers and incorporate industry best practices in connection with the development of technological systems. In addition, the CEO is extremely interested in......

Words: 695 - Pages: 3

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

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

Database

...Case Study: Database Development ALEXANDRA DESINORD PROFESSOR OSAMA MORAD CIS 515- STRAT PLAN FOR DBASE SYSTEMS Week 7 Assignment February 29, 2016 The more companies base their large elements of their business strategy around data, the need for IT team and executives with deep understanding of data and analytics is growing rapidly. Data changes all of the time. That is why it is essential that companies should try to stay up to par with the ever changing technology so that they can ensure that the system can withstand anything that comes about. Down below I will discuss briefly the various aspects of the SLDC and the tasks that can be completed to help solve certain common problems that exist from within. Customer data management is not high on many organizations' lists of priorities until it has to be. The term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system is called Systems development life cycle (SDLC). This term is also referred to as the application development life-cycle, which is a term used in systems engineering, information systems and software engineering to describe a process for planning, creating, testing, and deploying an information system. The task of optimizing the software development process has faced many obstacles. The main obstacle is a lack of accurate and complete data on the development process. The use of the......

Words: 2352 - Pages: 10

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

Taxi Driver | Mormon Tabernacle Choir | Table Decoration