Exam questions on Data Management
An intranet is an internal privately accessible organizational network that can provide access to data across the enterprise, constructed using Internet technology and tools, and connected to the internet through a firewall. Intranet is a corporate LAN (local area network) or WAN (wide area network) and it can rely on one of them or both. It is built on public domain operating systems, users, interfaces, application standards and networking standards. An open systems model for communications is required such as TCP/IP (the transmission control protocol/ internet protocol).
Intranets arose because companies realized that intranets offered several benefits over traditional information systems. A principal use of intranets has been to create on-line repositories of information that can be updated easily as often as required. Product catalogues, employee handbooks, telephone directories or benefits information can be revised immediately as changes occur. This “event driven” publishing allows organizations to respond more rapidly to changing conditions than traditional paper-based publishing which requires a rigid production schedule. Made available via intranet, documents always can be up-to-date, eliminating paper, printing and distribution costs.
Intranet is easy to implement and to use. Establishing an intranet is relatively straightforward technologically speaking. Most people are relatively familiar with using the concept of
Need essay sample on "Exam questions on Data Management"? We will write a custom essay sample specifically for you for only $ 13.90/page
(b) Evaluate the potential for the use of internet technology within the Jeff Lloyd Leisure Centre described below: (10 marks) With respects to our case, different types of intranet such as communications, integrating and catalogue ones could manage more business process electronically and enhance the organizational practice. The communications one will enable the leisure centre to link its site with other organizations’ sites for information sharing; for example, instead of displaying the promotional materials around the center or mailing them to their members, sales and marketing staff might use the intranet to track-manage-oversee and coordinate the activities of their sales force within the same organization or in collaboration with different ones.
Latest promotions, updates in pricing, rebates, and information about customers or competitors can also be made available with the utilization of the intranet. Additionally, principal responsibilities of human resources department include keeping employees informed of company issues and providing information about employees’ records and benefits. Human resource can use intranets for online publishing of corporate manuals, job postings and internal job transfers, company telephone directories and training classes.
The integrating intranet will provide the chance to the leisure centre to shift from the status of having a large number of information systems/ communication systems with different interfaces to a common (browser) interface. The firm will have for example booking system, staffing system, finance and accounting system, sales and marketing system, and human resource system through the integrating intranet. This will result in increasing the access. Additionally, the catalogue intranet is useful for the company if wishing to provide access to large catalogue of service information. In this case, database required to efficiently handle large volumes of data. Besides to that, the company needs a web page in which they can use a dynamic system for booking online (database in the web page) by utilizing new technologies. The underlying data model is very important as it needs to accommodate all of the various services types to be included.
Finally, the extranet would be beneficial for the company too. Extranet is an intranet that is also accessible in part to authorised people from outside the organisation. Various levels of accessibility provided via username/password mechanisms. The particular organisational network would be beneficial for good partnerships between businesses. For instance, if the leisure centre comprise a bar, then they could use the extranet for their suppliers for the proper equipment and for financial transactions too.
The catalogue intranet would enable the leisure center to present their services to their members. These different types of Intranet could provide rich set of tools for creating collaborative environments in which the members of the organization can communicate-coordinate and enhance group decision-making better by exchanging ideas, sharing information and working together on common projects and assignments regardless of their physical location. These tools include email, fax, voice mail, teleconferencing, videoconferencing, data conferencing, groupware, chat systems, newsgroups and team ware. Managers can view employee resumes, business plans, and corporate regulations and procedures; they can retrieve sales data, review any desired document and call a meeting.
(c) Discuss the differences between static and dynamic web pages. (8 marks) The main difference between static and dynamic web pages is that the content in the static web pages doesn’t change unless the HTML file which defines the page it is changed. Whereas, in the dynamic web pages the content is generated each time the page is accessed. Responds to user input from the browser for example by returning data from a database query. Additionally, dynamic pages can be customised.
Finally, there are numerous ways of integrating web pages with databases. These are the following: Active Server Pages/ActiveX Data Access Objects ASP allows dynamic, interactive web pages to be created on a web server running IIS (or PWS ) In this section we briefly mention some of the facilities available to integrate databases into the web environment. Microsoft Access provides 3 wizards for automatically generating HTML pages based on tables, queries, forms, or reports in the database:
Static pages: With this method, the user can export data to HTML format. This is the a basic facility with the obvious drawback that the HTML page can quickly become out of date and needs to be regenerated every time the base table change to remain current. The page uses standard HTML and can be used to with any browser. The user has some control over the appearance of the web page through the use of the HTML templates, files that consist of HTML commands describing the page’s layout. The templates can be used to insert company logos, graphics, and other elements.
Dynamic pages using Active Server Pages. With this approach the user can export data to an “asp” file on the Web server that will store the ASP file. * Dynamic pages, using data access pages. Data access pages are web pages bound directly to the data in the database. Data access pages can be used like Access forms, except that these pages are stored as external files, rather than within the database or database project. Although the pages can be used within Access, they are primarily designed to be viewed by a web browser. Data access pages are written in dynamic HTML, an extension of HTML that allows dynamic objects as part of the web page. Unlike ASP files, a data access page is created within Access using a wizard or in Design view employing many of the same tools that are used to create Access forms.
(a) Give a brief description of your understanding of the term On-Line Analytic Processing. On-Line Analytic Processing is the dynamic synthesis, analysis, and consolidation of large volumes of multi-dimensional data, Codd (1993). OLAP is a term that describes a technology that uses a multi-dimensional view of aggregate data to provide quick access to strategic information for purposes of advanced analysis. (Codd et al, 1995)
Furthermore, it enables users to gain a deeper understanding and knowledge about various aspects of their corporate data through fast, consistent, interactive access to a wide variety of possible views of the data. OLAP allows the user to view corporate data in such a way that it is a better model of the true dimensionality of the enterprise. While OLAP systems can easily answer “who?”and”what?” questions, it is their ability to answer “what if?” and “why?” type questions that distinguishes them from general-purpose querry tools. OLAP enables decision-making about future actions. A typical OLAP calculation can be more complex than simply aggregating data. Hence, the types of analysis available from OLAP range from basic navigation and browsing (slicing and dicing) to calculations, to more complex analyses such as time series and complex modeling.
OLAP is a method of representing multi dimensional data. In a relational database the data is held in a flat file, an OLAP cube can represent this data in a multi dimensional format (b) The following table gives a list of the revenue for 2001 for a property management company which has offices in different parts of the UK. The data is the result of a 3 field query in a relational database. How could this data be represented in a multidimensional database?
The ability to represent multi-dimensional views of corporate data is core requirement of building a “realistic” business model. A multi dimensional view of data provides the basis for analytical processing through flexible access to corporate data. Furthermore, the underlying database design that provides the multi-dimensional view of data should treat all dimensions equally. In other words, the database design should: 1. not influence the types of operations that are allowable on a given dimension or the rate at which these operations are performed;
2. Enables users to analyse data across any dimension at any level of aggregation with equal functionality and ease. 3. Support all multi-dimensional views of data in the most intuitive way possible. OLAP systems should as much as possible hide users from the syntax of complex queries and provide consistent response times for all queries no matter how complex. In our case the revenue data can fit into a three-field relational table, however, this data fits much more naturally into a two-dimensional matrix, with the dimensions being city and time (quarters). What differentiates the requirements for these representations are the queries that the end-user may ask. If the user simply poses queries like “what is the total annual revenue for each city?” then this involves retrieving multiple values and aggregating them.