Weekly Questions



Week 7 Questions

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

• Accuracy - are all the values correct? For example, is the spelling correct? are all financial recording correct? 
• Completeness - are any of the values missing? For example, are there full address details provided? 
• Consistency - is aggregate or summary information in agreement with detailed information? For example,does the true total of the individual fields equal the total fields. 
• Uniqueness - Is each transaction, entity and event represented only once in the information? for example, are their duplicate numbers and customers?
• Timeliness - Is the information current with respect to the business requirements? ex, is the information updates every hour, day, week or month?

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

A database maintains information about different types of objects (inventory), events (transactions), people (employees) and places (warehouses). From this set of information, management use it to access data in the data base so the program can consult it to answer queries. The computer program used to manage and query a database in known as database management system. 






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

Databases tend to mirror business structures, and a good database can handle changes quickly and easily, just as any good business needs to be handle changes in the most effective and efficient way. Databases also provide flexibility in allowing each user to access information in whatever way best suits their needs. 

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

The main concepts of the relational database model are entities, entity classes, attributes, keys and relationship. An entity in the relational database model is a person, place , thing, transaction or event about which information is stored. 

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

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. They are really useful when the site offers a great deal of information, products or services.