Jawaban Latihan 1 pertemuan 4
Relation Key
Yang bertindak sebagai Candidate Key :
Account : account-number,balance
Branch : branch-name, assets
Loan : Loan-number, amount
Costumer :costumer-name,costumer-city
Primary Key
Account-number
Branch-name
Loan-number
Costumer-name
Alternate Key
Balance
Amount
Asset
Costumer-city
Tidak ada foreign key
Jawaban Latihan 2
No Induk
|
Nama
|
TTL
|
Jenis Kelamin
|
Kelas
|
Alamat
|
991000
|
Nawang
|
Bandung, 07-10-1996
|
p
|
VII A
|
Bogor
|
889991
|
Astuti
|
Bogor, 09-10-1997
|
P
|
VIIB
|
Bogor
|
891000
|
Aditya
|
Jakarta, 18-02-1998
|
L
|
VIIA
|
Bogor
|
839910
|
Sabrina
|
Bandung, 19-05-1993
|
P
|
VIIC
|
Bogor
|
999100
|
Cindy
|
Tangerang, 08-05-1996
|
P
|
VIID
|
Bogor
|
NIP
|
NAMA
|
MATA PELAJARAN
|
GOLONGAN
|
ALAMAT
|
900000
|
INNAYAH
|
MATEMATIKA
|
III C
|
BOGOR
|
199999
|
ADITYAWAN
|
PPKn
|
IV A
|
BOGOR
|
910000
|
WIDYASTUTI
|
B.SUNDA
|
II A
|
BOGOR
|
819999
|
AFTAN
|
B.INDONESIA
|
III B
|
BOGOR
|
918888
|
ANDIKA
|
AGAMA
|
IV A
|
BOGOR
|
KODE MATA PELAJARAN
|
MATA PELAJARAN
|
NAMA GURU
|
JUMLAH JAM MENGAJAR
|
KELAS
|
1
|
MATEMATIKA
|
INNAYAH
|
4 JAM
|
VII
|
2
|
PPKn
|
ADITYAWAN
|
2 JAM
|
VIII
|
3
|
B.SUNDA
|
WIDYASTUTI
|
2 JAM
|
VII
|
4
|
B.INDONESIA
|
AFTAN
|
4 JAM
|
IX
|
5
|
AGAMA
|
ANDIKA
|
2 JAM
|
VIII
|
NAMA SISWA
|
KODE MA-PEL
|
NIP GURU
|
NILAI SISWA
|
KET
|
Nawang
|
1
|
900000
|
75
|
TUNTAS
|
Astuti
|
2
|
199999
|
67
|
TUNTAS
|
Aditya
|
3
|
910000
|
86
|
TUNTAS
|
Sabrina
|
4
|
819999
|
88
|
TUNTAS
|
Cindy
|
5
|
918888
|
90
|
TUNTAS
|
RELATION KEY
SISWA >> No _Ind,nama_siswa
Guru >> nip,nama_guru
Pelajaran >> kode_mapel,ma_pel
Nilai >> nama_siswa
PRIMARY KEY
No_induk
Nip
Kode_mapel
ALTERNATE KEY
Nama_gru
Tidak ada komentar:
Posting Komentar