1. List, describe, and provide an example of each of the five characteristics of high quality information.
1) Accuracy – information is precise and correct. For example, correctly recording customer details such as name, address, etc.
2) Completeness – all the necessary values are included for a field. For example, including the street, city, state and postcode in an address.
3) Consistency – basic information must correspond with detailed information. For example, all total fields should equal the true total of individual fields.
4) Uniqueness – Representing transactions, entities and events once in information. For example, duplicating a transaction.
5) Timeliness – Information is current and updated as the business requires. For example, is information updated weekly, daily or hourly?
2. Define the relationship between a database and a database management system.
Database: A logical collection of interrelated information, managed and stored as a unit. A database maintains information about various types of objects, events people and places. A database has a schema which provides a structural description of the type of facts held in the database.
http://geoapp2.gov.mb.ca/website/MAFRI/Glossary3.html&ei=dK7wS6jMHMyOkQXa0NznBg&sa=X&oi=define&ct=&cd=1&ved=0CCEQpAMoBw&usg=AFQjCNEwXVcF4VnOICOX0oxTQwehu9DDPw
3. Describe the advantages an organisation can gain by using a database.
Databases reduce data redundancy by recording data in one place. This also creates a more efficient computer system a less space is required. Databases can create limits for fields which also limit errors. Databases allow an increased level of security through authentication processes such as passwords and access controls. This is increasingly necessary due to the growth of the internet which has lead to more malicious virtual activity. http://www.businesslink.gov.uk/bdotg/action/detail?itemId=1075422994&type=RESOURCES
1) Accuracy – information is precise and correct. For example, correctly recording customer details such as name, address, etc.
2) Completeness – all the necessary values are included for a field. For example, including the street, city, state and postcode in an address.
3) Consistency – basic information must correspond with detailed information. For example, all total fields should equal the true total of individual fields.
4) Uniqueness – Representing transactions, entities and events once in information. For example, duplicating a transaction.
5) Timeliness – Information is current and updated as the business requires. For example, is information updated weekly, daily or hourly?
2. Define the relationship between a database and a database management system.
Database: A logical collection of interrelated information, managed and stored as a unit. A database maintains information about various types of objects, events people and places. A database has a schema which provides a structural description of the type of facts held in the database.
http://geoapp2.gov.mb.ca/website/MAFRI/Glossary3.html&ei=dK7wS6jMHMyOkQXa0NznBg&sa=X&oi=define&ct=&cd=1&ved=0CCEQpAMoBw&usg=AFQjCNEwXVcF4VnOICOX0oxTQwehu9DDPw
3. Describe the advantages an organisation can gain by using a database.
Databases reduce data redundancy by recording data in one place. This also creates a more efficient computer system a less space is required. Databases can create limits for fields which also limit errors. Databases allow an increased level of security through authentication processes such as passwords and access controls. This is increasingly necessary due to the growth of the internet which has lead to more malicious virtual activity. http://www.businesslink.gov.uk/bdotg/action/detail?itemId=1075422994&type=RESOURCES
4.Define the fundamental concepts of the relational database model.
A relational database maintains a set of separate, related tables, but combines data elements from these files for queries and reports when required. This is achieved by creating relationships between the fields of separate tables. The primary key function ensures that records within a table are unique. A primary key field will contain no duplicates or blank values.
http://www.pcmag.com/encyclopedia_term/0,2542,t=relational+database&i=50369,00.asp
http://www.novixys.com/Exult/Relationships_1021_01.jpg
A relational database maintains a set of separate, related tables, but combines data elements from these files for queries and reports when required. This is achieved by creating relationships between the fields of separate tables. The primary key function ensures that records within a table are unique. A primary key field will contain no duplicates or blank values.
http://www.pcmag.com/encyclopedia_term/0,2542,t=relational+database&i=50369,00.asp
http://www.novixys.com/Exult/Relationships_1021_01.jpg
5.Describe the benefits of a data-driven website.
Data driven website is an interactive website related to the needs of its customers by using a database. The benefits of data-driven websites are:Development: the website owner can make changes at any time without a developer or knowledge of HTML programming.Content management: Removes confusion as there is no intermediary such as a website developer to update websites.Future expandability: the website can easily be expanded in the future. Functions such as changing the layout, display and functionality such as adding more features and sections can be achieved easily.Minimising human error: errors and mistakes are likely to occur in a website. To compensate it is necessary to have error trapping mechanisms which ensure that the required information is filled out correctly and content is entered and displayed correctly.Cutting production and update costs: the website is cost-efficient because there is less need for a programmer as the website owner can publish content.More efficient: Computers enable large amounts of information to be stored in a small space. Global changes can be made to layout, navigation and site structure need to be programmed only once. A data-driven infrastructure improves the reliability and stability of a website.Improved stability: Data driven websites are not prone to information loss if the programmer is disrupted or does not retain the latest template.
An example of a data driven website is http://en.wikipedia.org/wiki/Main_Page.
Data driven website is an interactive website related to the needs of its customers by using a database. The benefits of data-driven websites are:Development: the website owner can make changes at any time without a developer or knowledge of HTML programming.Content management: Removes confusion as there is no intermediary such as a website developer to update websites.Future expandability: the website can easily be expanded in the future. Functions such as changing the layout, display and functionality such as adding more features and sections can be achieved easily.Minimising human error: errors and mistakes are likely to occur in a website. To compensate it is necessary to have error trapping mechanisms which ensure that the required information is filled out correctly and content is entered and displayed correctly.Cutting production and update costs: the website is cost-efficient because there is less need for a programmer as the website owner can publish content.More efficient: Computers enable large amounts of information to be stored in a small space. Global changes can be made to layout, navigation and site structure need to be programmed only once. A data-driven infrastructure improves the reliability and stability of a website.Improved stability: Data driven websites are not prone to information loss if the programmer is disrupted or does not retain the latest template.
An example of a data driven website is http://en.wikipedia.org/wiki/Main_Page.
6. Describe the roles and purposes of data warehouses and data marts in an organization.
A data warehouse is a logical collection of information from many different databases that help decision making and business analysis. The purpose of a data warehouse is to gather coarse information throughout an organisation into a single storage space to make business decisions and analysis. The purpose of a data warehouse is to gather information throughout an organisation into one store that enables employees to make decisions and conduct business analysis activities.
A data warehouse is a logical collection of information from many different databases that help decision making and business analysis. The purpose of a data warehouse is to gather coarse information throughout an organisation into a single storage space to make business decisions and analysis. The purpose of a data warehouse is to gather information throughout an organisation into one store that enables employees to make decisions and conduct business analysis activities.
No comments:
Post a Comment