Chapter 6 Questions
List, describe, and provide an example of each of the five characteristics of high quality information.
The characteristics of high quality management include:
Accuracy: data should be accurate and captured at the point of activity.
Completeness: in order to add value to any organisation, information must be unique and distinctive.
Consistency: is key when entering data into a database.
Uniqueness: data should be captured as quickly as possible after the event or activity and must be available for the intended use within a reasonable time period.
Timeliness: data requirement should be clearly specified based on the information needs of the organisation and data collection processes matched to these requirements.
Define the relationship between a database and a database management system.
A database is the heart of an organisation, it stores key business information like; sales data, inventory data and student data. All businesses use a database of some type. Database management system (DMS) is the - software through which users and application programs interact with a database.
Describe the advantages an organisation can gain by using a database.
- Users will be able to access a large amount of information.
- This information can be used to solve problems, and it can also be used to increase profits in the company.
- Data is consistent
- The data is relevant and and organised in an efficient manner.
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 recognise the database tables. That is, once relationships are created, tables can “talk” to eachother. We can link the tables to find for example, which students are in which class.
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. Its benefits include:
- mimisation of human error
- future expandability
- An improved sustainablility
- Known to be more efficient
6. Describe the roles and purposes of data warehouses and data marts in an organisation.
Data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. Its purpose is: to aggregate information throughtout an organisation into single repository for decision making purposes.
A data mart is a subset of an organisational datastore, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs.
No comments:
Post a Comment