1. The five characteristics of high quality information include:
Accuracy of the information - ensures that all data values are correct
Completeness of the information - ensures that there is no relevant data missing e.g. unit number of a customers address
Consistency of the information - ensures that all data fields are the same e.g. a key set to 10 within a mobile phone field to ensure that a mobile number is correctly entered. A key field will not accept any number above or below 10.
Uniqueness of every entry - ensures no duplicate entries are made e.g. the same student number is not given out to two students.
Timelines - ensures the information is kept relevant and up to date e.g. customers emails are updated yearly.
Accuracy of the information - ensures that all data values are correct
Completeness of the information - ensures that there is no relevant data missing e.g. unit number of a customers address
Consistency of the information - ensures that all data fields are the same e.g. a key set to 10 within a mobile phone field to ensure that a mobile number is correctly entered. A key field will not accept any number above or below 10.
Uniqueness of every entry - ensures no duplicate entries are made e.g. the same student number is not given out to two students.
Timelines - ensures the information is kept relevant and up to date e.g. customers emails are updated yearly.
2. A database contains structured, key business information about various types of objects (stocktake), events (transactions), people (students) and places (warehouses) for a business.
A database management system is the software which manipulates the raw data into useful information and decision making tools for the business.
A database management system is the software which manipulates the raw data into useful information and decision making tools for the business.
3. Some advantages an organisation can gain by using a database include:
- Helps to organise, store and keep vital information safe and easily accessible.
- Helps to reduce un-necessary information.
- Provides analytical information to help support accurate decision making.
- Makes overall business processes more efficient and effective.
- Helps to organise, store and keep vital information safe and easily accessible.
- Helps to reduce un-necessary information.
- Provides analytical information to help support accurate decision making.
- Makes overall business processes more efficient and effective.
4. The relational database model is a type of database that stores information in the form of logically related two-dimensional tables each consisting of rows and columns.
Below is a sample of a relational database model...
Below is a sample of a relational database model...
5. A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database. The advantages of a data-driven website is that it helps customers to run a query in order to filter through the vast amounts of information to find what they need.
It is also more efficient and provides real time information (stock levels & rice change) to customers. It also minimises human error and cuts production as well as update costs.
It is also more efficient and provides real time information (stock levels & rice change) to customers. It also minimises human error and cuts production as well as update costs.
6. A data warehouse is a logical collection of information gathered from many different operational databases that support decision analysis activities and decision making tasks. It's purpose is to amalgamate all business information into one storage location to help support employees decision making processes.
Data marts contain a subset of data warehouse information. They contain a collection of information on a focused unit of an organisation (e.g. Marketing) rather than the business as a whole.
Follow this link to a short tutorial on Data Warehouses
Data marts contain a subset of data warehouse information. They contain a collection of information on a focused unit of an organisation (e.g. Marketing) rather than the business as a whole.
Follow this link to a short tutorial on Data Warehouses
No comments:
Post a Comment