A head teacher keeps the following student details in a database: Name, address, Town, Date of Birth, Marks scored, Fees paid.

A head teacher keeps the following student details in a database: Name,address, Town, Date of Birth, Marks scored, Fees paid.

i) Name the most appropriate primary key. Give a reason
ii) For each item in the student’s details above, indicate its most appropriate data type as used in the database. 
iii) Explain why input screens are better data entry designs than entering data directly to a table. 
b) List two career opportunities associated with databases. 
c) Distinguish between:
i) A table in word-processing application and a table in a database application 
ii) Mouse pointer and insertion point. 
d) Outline the steps to be followed in order to merge cells in a word processing table.

RESPONSES
i)Name the most appropriate primary key. Give a reason. 
 Name alone is not unique though it is very rare that two or more students will share the same name.
ii)For each item in the student's details above, indicate its most appropriate data type as used in the database.

• Name                      Text 
• Address                  Text 
• Town                      Text
• Date of Birth         Date/Time
• Mark Scored          Numeric
• Fees Paid             Numeric/Currency

iii) a) Explain why input screens are better data entry designs than entering data directly to a table.

•  Most forms are bound to one or more tables and query in the database hence a user can design input fields linked to several tables/queries. 
•  Forms are also appealing to the eye. They have GUI features unlike a table.

b) List two career opportunities associated with databases.

• Database Administrator
• Data Administrator System Analyst
• Database Developer 
• c) Distinguish between: 

i) A table in word-processing application and a table in a database application.

• A table in a database application is a data entry/storage object, while a table in a word processor is made up of rows and columns of cells that one can fill with text and graphics. Tables in word processors are often used to organize and present information 
• In a database one defines the data type for a table in design stage/view but not the case in a word processor.

ii) Mouse pointer and insertion point.

•  Mouse pointer refers to an indicator on the screen, which responds to the movement of the mouse
• Insertion point is the place, in a full-screen editor or drawing program, where characters will appear if you start typing. The insertion point, which is different from the mouse pointer, looks like a thin vertical bar or, in some contexts, a tall, thin letter "I"; it is relocated by clicking at the desired position.

d) Outline the steps to be followed in order to merge cells in a word processing table.

• i) Select/Highlight cells to be merged.
• ii) Prom the menu bar clicks on table. 
• iii)Click on merge cells under the menu items

​​Related Searches on database, Form 2 Level

Read More