Accuracy: Information needs to be accurate and high quality. High accuracy will allow organisations to meet their goals. E.g: Excel spreadsheets designed to report monthly sales figures for a clothes store.
Completeness: Gives a big part of the picture of the information being reported. E.g: Total sales figures of a shoe store for the whole year.
Consistency: It is important to keep information reported consistant, to keep all added information on the same level as what was previously reported. E.g: When adding a telephone no. in the field, the field wont accept more than a 10 digit number to reduce inaccuracy.
Uniqueness: In order to add value to an organisation, information must be unique and distinctive. E.g:Is the information available on other sites?
Timeliness: New and current data is more valuable to an organisation than old and outdated information. It is important to keep up to date with information, as the era is more competitive. Eg: Real time information.
2. Define the relationship between a database and a database management system.
Database: A collection of organised information that allows data to be manipulated or extracted to suit the reporting needs.
Database management system: A set of programs used for managing the database. It facilitates the creation and maintenance and use of an electronic database.
3. Describe the advantages an organisation can gain by using a database.
Increased flexibility:
- Handles changes quickly and easily.
- Provides users with different views.
Increased scalability and performance
-scalability: How well a system can adapt to increased demands.
-Performance: measures how quicky a system performs a certain process or transaction.
Increased information integrity (quality)
Assurance that the information has not been changed or altered since the last time accessed.
Increased information security
- Information must be protected as it is an organisational asset. This is controlled through passwords and access controls.
An example of a database is MySQL is below
4. Define the fundamental concepts of the relational database model.
A database system in which any database file can be part of more than one of the database's tables.
5. Describe the benefits of a data-driven website.
Development- Allows owner to make changes to website at anytime-> user friendly.
Content Management- A static website required a programmer to make updates. This can lead to misunderstandings to desired changes.
Future Expandability- Allows the site to grow faster allowing changes to be easily updated.
6. Describe the roles and purposes of data warehouses and data marts in an organisation
Roles-
Data Warehouses
A logical gathering of information from different databases supporting business analysis and decision making.
Data Marts
Contains a subset (a set of numbers who are part of another set) of data warehouse information.
Purposes-
Data Warehouses
To aggregate information through the organisation into a single location of storage, so employees can make decsions and undertake business activities. Therefore the information stored to support decision making processes.
Below is an image showing an example of data warehouse
Data Mart
Focuses on informational subsets depending on the needs of a business unit such as finance or production.
Below is an image showing the components that make up a data mart
No comments:
Post a Comment