Chapter 6:
1. List, describe, and provide an example of each of the five characteristics of high quality information.
Accuracy: The Information that is held within the database must be correct for it to be useful and or high quality. For example if information is incorrectly spelt or wrongly recorded the standard of the database and its usefulness drops!
Consistency: Any summary information that has been formed from individual fields of the database must make sense and match up with those fields.
Completeness: to make sure that a database is of high quality all data must be imputed. For example if the data base is about students at a school and the information in there is age, gender, phone number, student identification and home address, each student must have each field entered must be complete for the database to be useful and high quality.
Uniqueness: there must only be one customer and there information must be unique to them, the customer must to reoccur with the same data as another.
Timeliness: Data should be up to date or be unchanging information, if addresses or phone numbers are not up to date then the database is unhelpful. (therefore the data needs to be 'timeless' and constantly updated)
1. List, describe, and provide an example of each of the five characteristics of high quality information.
Accuracy: The Information that is held within the database must be correct for it to be useful and or high quality. For example if information is incorrectly spelt or wrongly recorded the standard of the database and its usefulness drops!
Consistency: Any summary information that has been formed from individual fields of the database must make sense and match up with those fields.
Completeness: to make sure that a database is of high quality all data must be imputed. For example if the data base is about students at a school and the information in there is age, gender, phone number, student identification and home address, each student must have each field entered must be complete for the database to be useful and high quality.
Uniqueness: there must only be one customer and there information must be unique to them, the customer must to reoccur with the same data as another.
Timeliness: Data should be up to date or be unchanging information, if addresses or phone numbers are not up to date then the database is unhelpful. (therefore the data needs to be 'timeless' and constantly updated)
2. Define the relationship between a database and a database management system.
A database is where organisational information is stored thought it is extremely useful it would not assist with anything if there was no Database management system (DBMS) this system, in relation to a database is what organises and manages the information that is stored within a database.
A database is where organisational information is stored thought it is extremely useful it would not assist with anything if there was no Database management system (DBMS) this system, in relation to a database is what organises and manages the information that is stored within a database.
3. Describe the advantages an organisation can gain by using a database.
Databases also reduce information redundancy within organisations; this means that information is easily stored in multiple locations. By using databases the risk of information being altered in one location and not another is removed. The final two things, which are advantages to organisations that use databases, is that there is an increase in information integrity and information security. This means that information is more useful and has a higher quality and also that the information is safe and only open to particular people and areas, which are required to view it.
By using a database there are many advantages an organisation can have. There is an increased flexibility on how and what information can be viewed, databases can also handle quick changes and it therefore increases the mobility and ability of the organisation. Another advantage of using a database is that it increases scalability and performance of an organisation, when data is imputed into systems such used in the Australian bureau of Static’s they are easily able to adapt the information to suit a persons searching needs.
There are multiple advantages that arise with the use of a data-driven website. The quick development of the website is one advantage, it allows the owner to make quick alterations and additions with a little to no training on editing a web page. The content management is simplified, it removes the need for a programer who would normal be needed to update information on the website and quickens the update of data onto a website. The speed of which a data-driven website allows for fasters expandability of the site, and its reliability and the amount of data it can hold increases its efficiency and stability. The use of this style website minimises the risk of human error, even the most advanced programers can make mistakes which allow for bugs and other issues which are time consuming and expensive to fix. Lastly a data-driven website creates more convenience and self-sufficiency for website owners, creators and users.
6. Describe the roles and purposes of data warehouses and data marts in an organisation.
A data warehouse is a collection of information, gathered from many different databases to create a large collection of information and create a more detailed database. The main purpose of a data warehouse is that all information and data collected by one organisation can be collated in one depository and allow for the organisation to make business decisions and analysis's through the use of all information from one place rather than many. A data mart is a division of a data warehouse. These are focused on the needs of the organisation unit (e.g. finance pr production and operation) where as data warehouses hold all of an organisations data and information.
A data warehouse is a collection of information, gathered from many different databases to create a large collection of information and create a more detailed database. The main purpose of a data warehouse is that all information and data collected by one organisation can be collated in one depository and allow for the organisation to make business decisions and analysis's through the use of all information from one place rather than many. A data mart is a division of a data warehouse. These are focused on the needs of the organisation unit (e.g. finance pr production and operation) where as data warehouses hold all of an organisations data and information.
No comments:
Post a Comment