| 1.表の作成と管理 |
|
|
|
|
|
|
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| B,E |
A,B,F |
C |
B |
A,D |
A,B |
C |
A |
B |
C,D |
|
| 11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
| C |
B,E |
B |
B,C |
B,D |
A,E |
C |
C |
D |
B |
|
| 2.制約の組み込み |
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| A |
C |
B,C |
D,E |
A,B |
C,D |
B |
E |
E |
D |
|
| 11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
| B |
A |
A,D |
A,D |
B |
B |
A |
A,B |
D |
D |
|
| 3.ビューの作成 |
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| C |
B |
A |
B,C |
A |
C |
D |
D |
B |
A,E |
|
| 11 |
12 |
13 |
14 |
15 |
|
| A |
C |
A,D |
B,D |
A,C |
|
|
| 4.その他のデータベースオブジェクト |
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| C |
D |
B,C |
C,D |
A,D |
A,B |
D,E |
A |
C |
B,D |
|
| 11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
| B |
A,B,D |
C |
B,E |
B |
A |
A,C |
B |
B |
A,E |
|
| 5.ユーザーアクセスの制御 |
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
| A,D |
D |
A,C |
B |
A,B,C |
A |
B |
B |
D |
B |
|
| 11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
| C |
D |
C |
C |
C |
B |
A |
A,C |
A,D |
C |
|
| 6.Oracleアーキテクチャ |
|
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
|
| A,B |
D |
B |
B |
B |
A |
D |
|
|
|
|
|
|
|
|
|
|
|
|