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 individuals. Databases are essential for almost every company in today's business world. Database can help us keep track of, inventory, billing, pay role, phone numbers and much more. Lacking the use of databases, work will take longer to accomplish. Another wonderful feature about having a database in place is that a record of all transitions can be kept for analyzing purposes.In this paper I am going to discuss about the database and software used in my construction company. Oracle database is a multi platform database, meaning it can run efficiently on any operating system and this makes Oracle flexible and more secure when compared to its competitors. Our Oracle database is running on a Sun server, using the Sun Solaris enterprise operating system. Oracle databases are an enterprise database system, only medium and large companies would need an enterprise database. Oracle Corporation uses RDBMS rational database management systems to maintain all data within the organization. Various data items can be organized according to their relationships with each other, such as the relationship of Employee name and Employee ID, rational databases give Oracle a great deal of flexibility when describing the relationship between data elements. Oracle follows Dr.Cobbs 12 rules on how a true RDBMS should be evaluated. The following are Cobb's 12 rules.1. Information is represented logically in tables.2. Data must be logically accessible by table, primary key, and column.3. Null values must be uniformly treated as "missing information," not as empty strings, blanks, or zeros.4. Metadata (data about the database) must be stored in the database just as regular data is.5. A single language must be able to define data, views, integrity constraints, authorization, transactions, and data manipulation. [Typically this is SQL.]6. Views must show the updates of their base tables and vice versa.7. A single operation must be able to retrieve, insert, update, or delete data.8. Batch and end-user operations are logically separate from physical storage and access methods.9. Batch and end-user operations can change the database schema without having to recreate it or the applications built upon it.10. Integrity constraints must be available and stored in...

Find Another Essay On Analyzing the use of databases in the workplace

CIS 319 Computers and Information Processing Analyzing the Use of Databases in the Workplace

904 words - 4 pages 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

Analyzing the use of Databases in an Organization

1084 words - 4 pages more. Without the use of databases, work will take infinity longer to accomplish. Many advancements and improvements have been made in databases. They have improved them to the point that they are in use in almost every business. Databases have become a common place from the costly server based applications to the common place client based software like Microsoft Access.References:database. (n.d.). The American Heritage® New Dictionary of Cultural Literacy, Third Edition. Retrieved April 16, 2007, from Dictionary.com website: http://dictionary.reference.com/browse/database

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

850 words - 3 pages , but also keeps track of new leads for solicitation. One of the secondary databases used is the "C-II" database, which is the old program used for everything but is now retired to the newer Vision database. The final database management system used is the new "Mortgage Serve" system, which is still being worked on and does not currently have all of the old accounts, only the new ones that have been opened since its release.Current Use of database

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

The Benefits of Using Customer Databases

1156 words - 5 pages customers’ data because it required a lot of time and great effort. Nowadays, customer databases are used by most organizations to help collecting and analyzing consumers’ information in an easier and flexible way. Identifying target clients, reinforcing competitive advantage, and improving product development are three benefits of using a customer database. The first benefit of using customer databases is recognizing target customers. When an

An essay analyzing the use of a variety of film techniques in the documentary, "Life And Debt" by Stephanie Black to convey her arguments to the viewer

759 words - 3 pages interview environments that accurately convey the feeling behind the interview, and an appropriately expressive soundtrack that is relevant to the message of the film.In Life And Debt, Black makes extensive use of adjacently displayed contrasting images to reveal the unjust and unequal conditions that Jamaica and its inhabitants are subjected to. For example, in one scene, American tourists are shown dancing and doing other recreational physical

The Effects of Technology in the Workplace

3061 words - 12 pages environment in and around any organization. Foster (2002) suggests a few examples for promoting positive culture in the workplace, which helps to deter the misuse of technology such as, the internet:1. Reward ProductivityAll employees want to feel as if their work truly matters in the big picture. They want a sense of purpose for their job and to know that they are making a difference to the company's bottom line. When employees do not feel this

The Effects of Stress in the Workplace

934 words - 4 pages Today the world is at fast pace and people are having a lot of pressures and demands at workplace. A person who suffers from pressures or stresses in other words, their normal psychological and physiological well-being also gets affected. Stress is a body’s process of responding to a task [1]. Stress typically defines a negative condition or a positive condition that can have an influence on a person’s mental and physical well-being [1]. Stress

The Value of Diversity in the Workplace

788 words - 3 pages beliefs (Neale, 2000). Margaret Neale (2000), the John G. McCoy?Banc One Corporation Professor of Organizations and Dispute Resolution at Stanford Business School, studied the effects of different types of diversity in the workplace. ?What you don?t see is diversity having a direct performance effect,? says Neale. Neale (2000) studied informational diversity, demographic diversity, and goals and values diversity. Neale (2000) went on to find

The Importance of Diversity in the Workplace

796 words - 3 pages Companies such as Buzztronics are leading the way in the global economy because of their dedication to diversity in the workplace. In order to build a diverse and successful workforce, a business needs to recruit, train, and retain capable and talented minorities. Deloitte, a prestigious financial firm that deals mostly with accounting, traditionally recruited from top tier colleges and universities, as a result most of their new hires were

The Inequality of Women in the Workplace

2399 words - 10 pages harassment occurs in the workforce. In this most cases, "Male victims are less likely then female victims to receive a sympathetic ear, for people tend to find their situations humorous." (Duffy, A., Glenday, D., Henslin, M.J., Pupo, N. 2002. Pg182.) Somewhat conversely here, women's voices are heard and taken more seriously than men in the same situation. It has been proven that "the main victims of sexual harassment in the workplace are black women

Similar Essays

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.

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 Essay

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