A database is any organised collection of data.
2. Name three types of information products that may be produced using a database.
Address book
Registration form
Customer records (Eg. Bank, Hospital)
3. How does a database manage information?
Databases managed information by inputting facts/data into tables.
4. Provide three examples for each common data type.
Text (letters, numbers or special numbers)
Date (day, month, year and sometimes time information)
Currency (dollar and cent amounts or numbers containing decimal values)
5. In a CD collection database, name five of the fields that may be used. For each field describe the data type that each field will contain. Using details about your favourite artist and CDs make up some data that might be used in each of these fields. Then describe and write out what a record in this database may look like.
Name of CD: Nimrod
Name of singer/band: Green Day
In Stock: Yes
Type of music: Rock
Price: $9.99
6. What is meant by the phrase "data has integrity"?
Data has integrity means it has error.
7. Why is it important that data has integrity?
The database won’t be able to function, if data has integrity.
8. Explain the meaning of the term 'data'. Give three examples of data that may be input to a computer.
Data refers to information collected from primary and/or secondary sources
Examples of data are surveys, electronic mail, books or internet.
9. What is the difference between primary and secondary data sources? Give examples of each.
Primary source is the information recorded by ones personal knowledge, its also called original source.
An example of a primary source can be a wall painting found in the Roman city of Pompeii.
Secondary source is the information which has edited or added more details based on primary source.
An example of a secondary source is an article about Martin Luther King in a magazine.
