Week 7 Blog Questions

1. List, describe, and provide an example of each of the five characteristics of high quality information.

The 5 Characteristics of high quality information include:
1.Accuracy - Ensuring that all the values are correct (i.e names correctly spelt)

2.Completeness – Ensuring there are no values missing (i.e all addresses are complete, including street, city, state, and zip code)
3.Consistency –Ensuring that the aggregate or summary information agrees to the detailed information.
(i.e all total fields equal the true total of the individual fields)
4.Uniqueness – Ensuring that each transaction, entity, and event is represented only once in the information (i.e ensuring that there are no duplicate names)
5. Timeliness- Ensuring that all information is current with regards to the business requirements. (i.e all information is updated regularly)
.(Baltzan P, Phillips A, Lynch K, Blakey P, 2010 Business Driven Information Systems, 1st edn, McGraw-Hill Australia)


2. Define the relationship between a database and a database management system.

A database is an organised collection of data and Database management systems are a group of programs that manipulate the database and provide an interface between the database and its users and other application programs..(Baltzan P, Phillips A, Lynch K, Blakey P, 2010 Business Driven Information Systems, 1st edn, McGraw-Hill Australia)

3. Describe the advantages an organisation can gain by using a database.

Advantages that an organisation can gain by using a database is that the those working for the organisation can search the database for the information they are looking for and they can access it in a timely and orderly manner.


4. Define the fundamental concepts of the relational database model.

The fundamental concept of the relational database model are unique records and primary keys. To ensure that each record is unique in each table, one field can be set up to be a Primary Key field. A Primary Key is a field that that will contain no duplicates and no blank values. (Baltzan P, Phillips A, Lynch K, Blakey P, 2010 Business Driven Information Systems, 1st edn, McGraw-Hill Australia)


 
5. Describe the benefits of a data-driven website.


The benefits of a data-driven website are:
Development
Content management
Future expandability
Minimising human error
Cutting production and update costs
More efficient
Improved stability
Real time info like stock levels &price changes