Relational database solution Essay Example | Topics and Well Written Essays - 500 words

Relational database solution - Essay Example Therefore this need has led to introduction of various data storage solutions. One very well known model for database management is the rational database solution. A relational data base can be explained or defined as a collection of data or information. The data is then stored in tables where it can be accessed or rearranged in different ways without changing the arrangement of the tables. Relational data base was invented in the 1970 by Edgar Codd at IBM Harrington (2004). The relational database management system is based on the relational model theory. A relational database model has a set of tables which are designed to hold data after collection. The data is arranged and put in categories which have a set order. Each of the tables which are also known as a relation has either one or more data groups in columns. Every row has a set of data for each of the categories and is defined by the columns Harrington (2004). A good example is when an entry in a normal business order database has a table that gives a description of a customer which includes columns for the name, an address and a phone number. In addition there can be another table describing an order with columns for; the product name, date, customer name, the sales price. Therefore any person assigned to use the database can get access the database depending on what information they want to gather. For example a branch office manager might want to view a report on company clients that have bought either a product or a service in a particular date. Many of today’s businesses rely on their database systems for accurate and up to date information Suad (2005). Without this much needed information business organizations find themselves in tough situations such as strategic planning as well as corporate decision making. On the other hand for it to be useful to a business organization or a firm, it must be accurate, complete and organized in such a way that data can be retrieved when needed and in

Organisational Effectiveness Essay Example | Topics and Well Written Essays - 1000 words

Organisational Effectiveness - Essay Example It can be said that effectiveness translates into productivity where its absence can be projected in failure like, employee absenteeism and turnover, conflicts, performance instability and communication breakdown (Kaplan & Norton, 1996). Organizations that enjoy the benefits of effective organization for instance display features such as maximized output, lowered costs and advancement and excellence in technology. There are several methods of assessment techniques that can be adopted to determine the level of effectiveness that an organization is operating at. The varied methods can be as many as there are researchers in this field. Used at different times of necessity, the approaches target a different point of view on the organization (Cameron & Whetten, 1983). A few of these approaches are discussed in the paragraph below. When goal approach is adopted, the management attaches critical importance to the output or results that are achieved at the end of operational timeline (NCCI, 2007). The achieved output level is a measure of effectiveness in a proportionate relationship. Assessment could also be done using internal process approach where favourable results are deemed to emanate from the vital processes that are used to make transformations on input to achieve goals. Features of management such as coordination as well as employee welfare are given the centre stage in this approach. Ideally, output is the result of management and organization that is used to transform input towards achievement of goals. Alternatively, the system resource approach puts much emphasis on the acquisition capability of raw materials and other important resources from the environment that the organization has (NCCI, 2007). Effectiveness is attached to the efficiency of the first stage of operation which involves input. Con stituency approach is the other