Access07:Heights:Answers

T.2q: Answers
1. Why is it better to assign a number to each person rather than use their full name as an identifier?

Several people can have the same name

2. What problems can occur when entering data if the field is called FullName (clue: Think of Chinese names)?

First Name/Last Name can be in a different order (Chinese), people can enter the name in many ways (First Last or Last, first, or intiials Last etc

3. Heights is entered as an integer (+/-32767). What unit of measurement should be used (m, cm,mm)?

mm is probably th best as there are no decimal points allowed

4. The identifier is a long integer. How many people can be uniquely identified?

2,147,483,648 to 2,147,483,647 !!

5. Why is it a good idea to add a prefix (like Peo) to field names? When databases contain many tables, then different tables can have the same field (attribute) name. Example a customer table and supplier table may have a CellPhoneNumber field.

6. Why do we add prefixes like tbl to tables?

This helps to distinguish the different objects in the database and are really useful when doing programming.