Latihan 1

1. Candidate Key :

          Account   : account number, balance. 

          Customer : customer name, customer city, customer street. 

          Branch     : branch name, branch city, assets.

          Loan        : loan number, amount.

2. Primary Key    : account number, customer name, branch name, loan number.

3. Alternate Key  : balance, customer city, customer street, branch city, assets, amount.

4. Foreign Key    : tidak ada.

Latihan 2

Tabel Siswa

Tabel Pelajaran

Tabel Guru

Tabel Keterhubungan

1. Candidate Key : Nama_siswa, no_presensi, kode_pelajaran,nama_pelajaran,ruang,nama_guru,NIP_guru.

2. Primary key : no_presensi

3. Alternate Key : Nama_siswa, kode_pelajaran,nama_pelajaran,ruang,nama_guru,NIP_guru.

4. Foreign Key : Kode_pelajaran, NIP_guru.

Entity Relationship Diagram