1. What is a database
A database is a collection of data organised to access, retrieve and process the data.
2. Name three types of information products that may be produced using a database.
- Address book
- Registration form
- Customer records
A database is a collection of data organised to access, retrieve and process the data.
2. Name three types of information products that may be produced using a database.
- Address book
- Registration form
- Customer records
3. How does a database manage information?
Information is managed in databases 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.
Fields - Artist, album name, year of release, cost, language.
Artist - Shugo Chara Egg
Album name - Shugo Shugo
Release – 2009
Cost - $17
Language – Japanese
6. What is meant by the phrase "data has integrity"?
When data has integrity it means that the data has no or very little errors. The more errors it has the lower the integrity.
When data has integrity it means that the data has no or very little errors. The more errors it has the lower the integrity.
7. Why is it important that data has integrity?
It is important for data to have integrity because computers and people use the information to make decisions.
8. Explain the meaning of the term 'data'. Give three examples of data that may be input to a computer.
Data is the raw facts gathered from primary and secondary sources; some 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 Sources are facts that we have obtained ourselves through measurement, data collection forms, like a survey, interviews, and direct observations or by electronic mail. Secondary Sources is data gathered from printed publications, electronic data sources and the internet.