basic database primary/foreign key HELP?

Question

which is most likely to be a primary key?
a. persons last name
b. employees salary
c. customers id number
d. salespersons region of responsibility

which of the following is an integrity constraint required for primary keys?
a. must be associated with another tables foreign key
b. must be unique
c. cant be read by user
d. must be a numeric value

the field that links a dependant table to its related primary field is called an:
a. primary key
b. foreign key
c. linking key
d. relational key

which is not allowed for foreign keys:
a. duplication of foreign keys in a table
b. foreign key value of blank (or null)
c. foreign key value matching a primary key of a related table
d. foreign key value not matching any primary key of a related table

when more than one field is needed in order to ensure that a primary key uniquely identifies a record, a ____ is used:
a. foreign key
b. summary field
c. vanguard operation
d. compound/ composite key

if you want to create a field indicating the year level of a student, in which the value entered can only be within 1 to 10 years at school a validation option to use would be"
a. unique
b. auto-enter
c. range
d. formula

an example of a virtual or a derived key would be:
a. student id
b. count of student id
c. date
d. last name

scripts in filemaker are similar to what in excel?
a. functions
b. cells
c. macros
d. buttons

the basic unit of data in a record is a:
a. byte
b. table
c. character
d. field

Answer 1

which is most likely to be a primary key?

c. customers id number



which of the following is an integrity constraint required for primary keys?

b. must be unique



the field that links a dependant table to its related primary field is called an:

b. foreign key



which is not allowed for foreign keys:

d. foreign key value not matching any primary key of a related table



when more than one field is needed in order to ensure that a primary key uniquely identifies a record, a ____ is used:

d. compound/ composite key



if you want to create a field indicating the year level of a student, in which the value entered can only be within 1 to 10 years at school a validation option to use would be"

c. range



an example of a virtual or a derived key would be:

b. count of student id



scripts in filemaker are similar to what in excel?

c. macros



the basic unit of data in a record is a:

d. field

Answer 2

To add to 1, for the same reason a screwdriver is better to screw in a screw than a ball point pen is - Excel is a spreadsheet (a "what if" calculator), not a database. (Microsoft keeps coming out with programs that are neither fish nor fowl - and they work equally poorly at both tasks.)

Answer 3

C.

B.

B.

D.

D.

C.

B.

C.

A.