9-8
In handling a database, the key to specify a record is required. Which of the following is
the appropriate key to specify a record in the student management table of a certain school
year?
a)
b)
c)
d)
9-9
Name
Address
Student number
Birth date
Which of the following is the membership number of the woman whose present address
and work location are both Tokyo in the member list table?
Member list
Membership
number
Name
Sex
Present address
Work location
0001
Akio Tanizawa
Male
Saitama Prefecture
Tokyo
0002
Masato Toyonaga
Male
Tokyo
Tokyo
0003
Mayumi Akiyama
Female
Chiba Prefecture
Saitama Prefecture
0004
Yuka Kasai
Female
Tokyo
Tokyo
0005
Kenta Yamauchi
Male
Saitama Prefecture
Saitama Prefecture
0006
Nobuko Yamamoto
Female
Chiba Prefecture
Tokyo
a)
b)
c)
d)
303
0001
0003
0004
0006