Latihan 1
Dari gambar diatas akan ditentukan relation key-nya :
1. Candidate key :
account-number, branch-name, branch-city, customer-name, customer-city,
ioan-number
2. Primary key :
account-number, loan-number,branch-name,customer-name
3. Alternate key :
branch-city, customer city,
4. Foreign key :
ioan-number, account-number
Latihan 2
TABEL SISWA
|
NIS
|
NAMA
|
TANGGAL LAHIR
|
JENIS KELAMIN
|
|
08091111
|
MUHTAR
|
20/01/1993
|
L
|
|
08091112
|
HENDRO
|
22/02/1992
|
L
|
|
08091113
|
HENDRA
|
17/08/1993
|
L
|
|
08091114
|
AHMAD
|
11/09/1993
|
L
|
|
08091115
|
ANIN
|
01/01/1993
|
L
|
TABEL GURU
|
NIP
|
Nama-Guru
|
No hp
|
|
004523
|
Samsul
|
085743217347
|
|
023188
|
Casanin
|
081632234201
|
|
529753
|
Sri mulyani
|
089907528957
|
|
619452
|
Andre
|
081543347298
|
|
Kode-pelajaran
|
Nama-pelajaran
|
|
Math
|
Matematika
|
|
Fis
|
Fisika
|
|
Kim
|
Kimia
|
|
Bio
|
Biologi
|
|
Eng
|
Bahasa Inggris
|
|
Ind
|
Bahasa Indonesia
|
|
PAIs
|
Pend. Agama Islam
|
|
NIS
|
Nama-siswa
|
Kode-pelajaran
|
NIP
|
Nilai
|
|
5300701023
|
Tantowi
|
AS007
|
008762
|
86
|
|
5300701054
|
Ruland
|
AA005
|
007321
|
90
|
|
5300701033
|
Achmad rifa’i
|
CA001
|
011320
|
77
|
|
5300701028
|
Danang subagiyo
|
KU004
|
003417
|
82
|
|
5300701057
|
Catharina
|
SJ007
|
002742
|
75
|
|
5300701062
|
Tri anni
|
VB800
|
010472
|
80
|
1. Candidate Key : NIS,
Nama-siswa, Tanggal Lahir, NIP, Nama-Guru, No hp, Kode-pelajaran,
Nama-pelajaran
2. Primary Key : NIS,
NIP, Kode-pelajaran
3. Alternate Key :
Nama-siswa, Tanggal-lahir, Nama-Guru, No hp, Nama-pelajaran
4. Foreign Key : NIS,
NIP, Kode-pelajaran
Entity Relationship Diagram
Tidak ada komentar:
Posting Komentar