Cis 319 Computers And Information Processing Analyzing The Use Of Databases In The Workplace

904 words - 4 pages

AbstractDatabases are powerful tools that when used correctly will provide businesses with an edge over the competition. Databases utilize the Structured Query Language SQL Server to run security and transactions. The SQL server provides client computers with highly efficient access to database files. The use of database programs has become a necessity to almost every business big or small.Analyzing the Use of DatabasesIn the IT field, the need for databases is the heart of running the business. The databases we use hold all information about the daily transactions and important customer information. I will discuss some of the major databases we use. Databases are designed to offer an organized mechanism for storing, managing, and retrieving information (www.About.com). In the IT department, we use several types of databases from Microsoft Access to the server based SQL server. Microsoft Access is a database management system from Microsoft, packaged with Office, which combines the Jet relational database engine with a graphical interface intended to make it possible for relatively unskilled programmers and non-programmer "power users" to build sophisticated "front-ends" to complex databases (http://www.technolopedia.com, 2004). Our Microsoft Access databases are custom built to suit the business needs. Access is a powerful database program that will also query SQL databases if set up correctly.There are many server based database programs that are available some of these include, IBM, Informix, Microsoft, Oracle, and Sybase (Information Week). These manufactures make some of the most popular server bases databases. Unlike their desktop cousins, server-based databases can handle just about any data management problem you can throw at them. Developers love these systems because they have programmer-friendly application programmer interfaces (APIs) that provide for the rapid development of database oriented custom applications. If you are willing to provide the necessary hardware resources, server databases are able to handle a rapidly expanding amount of users and/or data. Server based relational databases are the all-important data repositories that manage employee and customer records, financial transactions, inventory, and a wide array of other business information in companies of all sizes.The server-based databases that we use utilize the Structured Query Language (SQL) Server to run security and transactions. The SQL server provides client computers with highly efficient access to database files. SQL is a relational database management system for building business applications with increased data protection. The SQL server acts like an engine providing enhanced performance for data access and delivery of data from your server to the workstation (www.microsoft.com, 2004). SQL server has many security holes that constantly need patching. As we have discussed many times in this class security is always a big issue. If a systems administrator...

Find Another Essay On CIS 319 Computers and Information Processing Analyzing the Use of Databases in the Workplace

Riordan Manufacturing Overview: Computer and Information Processing - CIS/319

1274 words - 5 pages life-cycle of the product. The barcode system will also be used to store products within Riordan Manufacturing warehouses. Ultimately, it is Learning Team A's hopes that this system will alleviate manually entering data and vastly improve product inventory.The Tiger Team of Learning Team A recommends a barcode system. This system will require the use of a hand-held scanner, which will scan the barcode and automatically register it in inventory

Analyzing The Use Of Databases Essay

890 words - 4 pages result, they also will have to make several phone calls and rely on faxes to accomplish a simple task. Since they do use a database, their employees are able to 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

Analyzing the Use of Databases

702 words - 3 pages retrieve information from. One can imagine what life would be without a database. Without the database the company would have to revert to the manual way of tracking, which would be paper. The use of database at ZaidCorp Tech aids in the productivity and growth of the organization. The SQL and the oracle database were customized to suit the specific needs of the organization. The database is the quickest and most convenient way to share information.The

Analyzing the use of Databases in an Organization

1084 words - 4 pages According to the American Heritage New Dictionary of Cultural Literacy Third Edition, (n.d.) a "database consists of a set of data grouped together in one location in (or accessible by) a computer". A database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary from a small database used by an individual to personal information, to an extremely large enterprise database that stores several

Computer Information - CIS/319 UOP

1111 words - 4 pages character recognition sensor. This is software that translates text into digital form in order to put it into the computer (Rainer & Cegielski, 2011).Methods of OutputJust as there are many ways to input information, there are also many ways to output information. Some situations where methods of output are used are hand-held computers, color photographs, resumes, memorandums, statistical reports, and company annual reports.Hand-held computers

Database paper- Memorandum analyzing the use of databases in your organization - Conclude by proposing improvements

850 words - 3 pages management systemThe "Vision" database is the often used database, as it houses a lot more information than the other two. The "Vision" database has two different databases within itself, one being the Lead Management System (LMS) and the other being the Customer Information System (CIS). The LMS is the only system currently used to track solicitations. The sales staff of our division is able to access information such as addresses, phone numbers

Information Systems & Hardware Concepts - UOP CIS/319

774 words - 3 pages questionnaire, and type up the documents. The keyboard would not only be the best choice, but the most logical choice as well. In today's day and age, we do not type many documents on a typewriter anymore. We use our computers and word processing programs to type documents. A computer is useless without some form of a keyboard; therefore, it is the most logical choice for an input device. With this in mind, the best output device would be any

Database Use Paper - UOP CIS/319

805 words - 3 pages Database Use PaperRelational databases can be tracked back to the IBM era in the 1960's and 70's. Thanks to a man named Ted Codd who was a researcher for IBM in 1970, we can now store data in a relational database. The days of storing and indexing files manually are virtually over in the database world. Oracle Corporation uses relational database management systems (RDBMS) to maintain all the data within the support organization.Various data

Hardware Systems: Computers and Information Processing

1538 words - 6 pages is getting the accurate data on the bottom of the documents for the computers to read. A check processor typically keys the MICR ink on to the documents so there is room for error in this process. However, once the MICR information is on the documents the readers are able to process large volumes of checks quickly and accurately. A more accurate way to capture the data would be to use an optical scanner to capture the image of the actual check

CIS319: Computers and Information Processing Outsourcing and On-demand Paper

752 words - 3 pages Foreign outsourcing and information technology plays an important role in increasing the demand for skills, whether the demand for skills is measured as shared employment or the number of relative skilled labor. Outsourcing and on-demand computing have been a familiar exercise among both public and private organizations. These processes are a key component in business strategies. Successful outsourcing for many organizations benefits each

Riodan Manufacturing- Inventory Improvement Proposition Computers and Information Processing

1935 words - 8 pages and shipping, and the delay in entering shipping information into the inventory system.Summary of problems- The common problem throughout the described processes is the use of manual forms and the end of day data entry into the inventory system. The second problem is the lack of integration between customer order and inventory systems.Suggested improvements- To improve efficiencies and time to deliver the inventory and shipping processes need to

Similar Essays

Database: Cis/319 Prepare A 2 3 Page Paper Analyzing The Use Of Databases In Your Organization

793 words - 3 pages faxes to accomplish a simple task. Since we use a database, our employees are able to have access to information instantly. This paper highlights the three databases that my company uses: GoldMine, Macromedia Dreamweaver, and Microsoft Excel.We require the use of GoldMine for maintaining customer contact information. This information includes customer name, phone number, delivery address, email, type of organization, and a designated order

Analyzing The Use Of Databases In The Workplace

810 words - 3 pages Analyzing the use of databases in the workplaceUniversity of PhoenixCIS/319May 1, 2007Analyzing the use of databases in the workplaceA database stores keyed information in an organized and accessible manner. The size and capacity of databases can vary widely, from a small database used by an individual to file phone numbers, to an extremely large enterprise database that stores several gigabytes of information accessed by thousands of

Analyzing The Use Of Databases Essay

886 words - 4 pages field - server-based databases. These systems have become household names due to the great opportunities they offer organizations to manage large amounts of data quickly, efficiently and in a manner that enables many users to access and update the data simultaneously. If you're able to meet the hefty price tag, a server-based database can provide you with a comprehensive data management solution.The benefits achieved through the use of a server

Analyzing The Use Of Databases Essay

605 words - 2 pages . You do not need to re-key any of the student's information.As businesses continue to evolve around technology there becomes a need for continued enhancement and upgrading. Some of the needed improvements for my workplace include:Looking up a student at more than one workstation simultaneously.Java Base Application SystemWeb browser interfaceAccessible from the internetDrop down menusPop up windowsRadio ButtonsFill in boxesAs I complete this paper I have come to realize how complex databases are and how essential they are to the business world. Without the use of a database, we would go back to a very wasteful paper world.