Week Seven - Databases and Data Warehouses Weekly Questions

Week 7 Questions




1. List, describe, and provide an example of each of the five characteristics of high quality information.
Accuracy: Ensuring all information provided is accurate.
Completeness: Ensure complete fields and data.
Consistancy: Fields correctly entered - maintaining time management.
Uniqueness: Entities unquie - Primary key.
Timeliness: Good decisions, effective time management systems, online processing.






2. Define the relationship between a database and a database management system.
A database is the physical data stored such information is tables, fields and reports.
A database management system are where information is used to run systems. E.g Microsoft Access and Word.




3. Describe the advantages an organisation can gain by using a database.
The advantages of databases are it seperates records, increases flexibility, performance and reduces redundancy. It provides correct data and security of data ( Group Based Security)

4. Define the fundamental concepts of the relational database model.
A Rational database model logically relates 2D tables, rows and coloums - data and attributes.
Primary key E.g Student I.D, Links to table which link to acedemic table - who get information from many tables.


5. Describe the benefits of a data-driven website.
They provide website links to databases which are quicker, flexible and reduce multiple entries. They provide assistance when searching the web.




6. Describe the roles and purposes of data warehouses and data marts in an organisation
Data Warehouses are many databases put into a single system. They are used to make business reports from many systems. Data marts are the same as data warehouse but they are smaller but still similar.