Relation key:
1. Primary key:
* Account =
account_number
* Customer =
customer-name
* Loan =
loan-number
* Branch =
branch-name
2. Candidate key:
* Account =
account-number
* Customer =
customer-name
* Loan =
loan-number
* Branch = branch-name
3.
Foreign key:
* Account (branch-name)
references branch (branch-name)
* Account (account-number)
references loan (customer-number)
* Loan (customer-name)
references customer (customer-name)
4.
Alternatif key:
* Tidak terdapat
karena tuple yang dijadikan candidate key juga menjadi primary key
jawaban latihan 2:
1. Membuat Tabel dengan nama siswa, guru, mapel, dan gabungan :
- Tabel siswa
|
NIS
|
Nama
|
Jurusan
|
|
24356
|
DONI
|
IPA
|
|
24357
|
SEKAR
|
IPA
|
|
24358
|
YOGI
|
IPS
|
|
24359
|
LINDA
|
BAHASA
|
|
24311
|
SANTI
|
IPA
|
- Tabel MAPEL
|
Kode_MP
|
Nilai
|
|
00AP321
|
80
|
|
01MP891
|
79
|
|
02MTK345
|
90
|
|
03TP678
|
60
|
|
04BI880
|
75
|
- Tabel GURU
|
Nama
|
Kode_MP
|
ALAMAT
|
|
A’an,
S.Pd.,S.T.
|
01MP891
|
SURAKARTA
|
|
Inamarni,
S.T., M.T.
|
05FS421
|
KARANGAYAR
|
|
Mei
Riayani, S.T.
|
00AP321
|
JUMANTONO
|
|
Unni
Mida, S.T, S.S.
|
02MTK345
|
PATI
|
|
Jamilah,
S.Pd., M.T.
|
04BI880
|
KENDAL
|
2.
Tabel Gabungan
|
NIS
|
Kode_MP
|
Nilai
|
|
24356
|
01MP891
|
79
|
|
24357
|
05FS421
|
80
|
|
24358
|
00AP321
|
80
|
|
24359
|
02MTK345
|
90
|
|
24311
|
04BI880
|
75
|
3. Atribute key yang dipake:
-
Candidate key
a. Guru = nip, pengajar
b. Siswa = nis, nama
c. Pelajaran = mapel
-
Primary key
a. Guru = nip
b. Siswa = nis
c. Pelajaran = mapel
-
Alternate key
a. Guru = pengajar
b. Siswa = nama
c. Pelajaran = -
-
Foreign key
a. Nis references siswa NIS)
b. Mapel references pelajaran (mapel)
3. Membuat ERD
Tidak ada komentar:
Posting Komentar