questions for assessment

Potential Questions for AssessmentIntroduction to databases

1.      Define the term ‘database’.

database  is a collection of related records orgisined and stored so that information can be obtained by the user.

2.      Identify an example of a manual database.

filing cabinet.

3.      Describe the disadvantages of a manual database.

you cant backup your work. harder to find data.

4.      Name an example of a database program.

access is a database program.

5.      Define the term ‘dbms’.

database management system

6.      Describe ONE method to protect an electronic database.

backup your work

7.      Identify THREE advantages of an electronic database.

you can backup your work, it is easy to find what you are looking for and you can access a electronic database where ever you have a computer.

8.      Define the term ‘flat file’.

a flat file is a database that can bot link to other databases.

9.      Define the term ‘data’.

data is any fact that can be input, stored, processed, output and retrieved from a computer.

10. Define the term ‘information’. information is data that has been orginised in a way that is is meaningful to the user.Data Types

11. Identify FOUR different data types that can be stored in a database.

1. numbers/numeric

2. text/ letters

3. currency

4. hyperlink

12. Identify the TWO different values that a Boolean field can store. a boolean field can store either “yes” or “no”

Parts of a Database13. The diagram below is referred to as a database Hierarchy.

14. Define the term ‘record’.

i record is a collection of fact about about an entity in a database made up of one or more related fields.

15. Define the term ‘field’.

a field is a subdevision of a record  containing a specific piece of data

16. Define the term ‘form’.

a form is usually a database layout in which a single record is displayed.

17. Define the term ‘primary key’.

a primary key is a unique identifier, often an integer, labelling a certin row in a relationship.

18. Describe the purpose of a primary key.

the pourpose of a primary is to relate databases.

19. Identify the TWO ways we can sort data in a database.

1. forms2. report Mail Merge

20. Describe the process of creating a mail merge.

the process of creating a mail merge is

21. Describe the benefits of a mail merge.

The benefits of mail merging are:

• Create a single documents with ‘fields’ in it that data is imported to

• Consistent documents- keep the same formatting and look

• Maintain data in a spread sheet or other application such as an address book

• Import the data into the fields and generate one document per record

Planning and using a database

22. Describe the tool called a data dictionary

Where a description of each field in a database, including field name, field width, data type and description of purpose

.23. Create a form (like in Woofu) to capture data for a survey on favourite television shows. Include at least 3 different data entry components.

Click here for tv show form: http://creator.zoho.com/nathanc/form/4/U2wyMWF9reTnVP8MQXa4EmwXO8OeewSD2JKd4qRWB3ZN07tRUwupuUSCT6h8XSuDayKu2uVMC7wkp9yEDsYQ55WAr1fY4kRwFsgX/

24. Draw a data dictionary which is based on your form.

25. Define the term ‘filter’.

A process that translates the form of the data in the database during a query  to display the output from the query

26. Explain why it is not a good idea to store First name and Surname together in one field.

because it is easier to search for names that you want.

27. Describe what happens when you create a database table without selecting a primary key.

you wont be able to link or relate other databases.

28. Describe what a field with type ‘Auto number’ does.

auto number fields gives the person or object entered a number.

29. Describe the problem if a user enters “Comedy” and “comedy” into the Genre field of a database.

they are different word according to a database so it will not show up

30. Define the term ‘query’. Uses of databases in the public

a query is a question given to the database to find all  enrtieswith same answerin the same field. e.g. Andrew in name field.

31. The RTA uses a huge database to store data about drivers and cars. How can this data be misused?

to find private informaton about a person.

32. Find out about the Australian ID card. What are the social and ethical issues about this idea?

This card is a card that all Australians need to have to be able to access medicare and welfare payments. It contains enhanced security and will be replacing other cards for medicare benefits, family tax, childcare, unemployment payments, pensions, etc.The card Australiand ID card will also be used to check id for immigration and security and to lower fraud rates. Its embedded computer chip will include a photograph, number, signature, date of birth and address. This is like a personal database all focused around the actual person.