- Accuracy: Information is correct e.g. names spelt correctly, values correct or correct units
- Completeness: No blank information e.g. all personal details included
- Consistency: Information agrees with other information. e.g. are totals correct
- Uniqueness: Does information only appear once. e.g. are there duplicates of the same customer
- Timeliness: Information is not outdated. e.g. customer details are up-to-date
2. Define the relationship between a database and a database management system.
Database management system is software through which users and application programs interact with a database. DMS is the way all people can access and manipulate the database, and the database is an organised system of data.
3. Describe the advantages an organisation can gain by using a database.
Database advantages a business can gain from databases include:
- Increased flexibility
- Increased scalability and performance
- Reduced information redundancy
- Increased information integrity (quality)
- Increased information security
The relational database model is a type of database that stores information in the form of logically related two dimension tables each consisting of rows and columns.
5. Describe the benefits of a data-driven website
In a data-driven website the customer enters search criteria in to the website, hence making the database run a query on the search criteria to give the customer a specified result. Advantages include development, content management, future expandability, minimising human error, cutting production/update costs, efficiency and improved stability.
6. If you were a sales manager in multi national company, what are some reports you would want to see?
As a sales manager for a multi-national company you would want to see reports such as budgets, sales forcastes, revenue and profits, sales representative statistics, average product sale results and individual product sale results.
No comments:
Post a Comment