Week 7 Questions

List, describe, and provide an example of each of the five characteristics of high quality information.

The five characteristics of high quality information are:

• Accuracy: Are all the values correct? For example, is the name spelled correctly? Is the dollar amount recorded properly?
• Completeness: Are any of the values missing? For example, is the address complete including street, city, state and postcode?
• Consistency: Is aggregate or summary information in agreement with detailed information? For example, do all total fields equal he true total of the individual fields?
• Uniqueness: Is each transaction, entity and event represented only only once in the information? for example, are there any duplicate customers?
• Timeliness: Is the information current with respect to the business requirements? For example, is information updated weekly, daily or hourly?

Define the relationship between a database and a database management system.

A database management system is the computer program used to manage and query a database. A data base maintains information about various types of objects, events, people and places. Typically a given database has a structural description of he type of facts held in that database, this description is known as a schema

Describe the advantages an organisation can gain by using a database.

The advantages an organisation can gain by using a database are:

• Increased flexibility: a good database can handle changes quickly and easily Databases provide flexibility in allowing each user to access the information in whatever way best sits his or her needs.
• Increased scalability and performance: Only a database could scale to handle the massive volumes of information and the large numbers of users required. It refers to how well a system can adapt to increased demands and measures how quickly a system performs a certain process or transaction
• Reduced information redundancy: redundancy is the duplication of information, or storing the same information in multiple places. Redundant information occurs because organisations frequently capture an store the information in multiple locations
• Increased information integrity: Information integrity is a measure of the quality of information. Within a database environment, integrity constraints are rules that help ensure the quality of information
• Increased information security: The organisation must protect its information from unauthorised users or misuse

Define the fundamental concepts of the relational database model.

A relational database is a collection of tables from which data can be accessed in many different ways without having to reorganise the database tables. Data is able to be linked so that information is more easily accessed such as finding out what doctor is seeing what patient and which students are in which classes

Describe the benefits of a data-driven website.

Advantages of a data driven website are:

• development: allows the website owner to make changes at any time
• content management: a static website requires a programmer to make updates
• future expandability: having a data driven website enables the site to grow daster than would be possible with a static site
• minimising human error: bugs and inconsistencies that can be time consuming and expensive to track down and fix
• cutting production and update costs: a data driven website can be updated and published by any competent data entry or administrative person
• more efficient: computers are excellent at keeping volumes of information in tact
• improved stability: any programmer who has o update a website from static templates must be very organised to keep track of all the source files

Describe the roles and purposes of data warehouses and data marts in an organisation

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision making tasks. A data warehouse holds information such as marketing, inventory, sales, billing, competitor, industry, mailing list and stock market analysis

All answers came from Business Driven Information Systems (Baltzan, Phillips, Lynch, Blakey)