Latihan Soal Model Data Relational

LATIHAN 1

Jawaban dari latihan soal disamping adalah:

Relation Key

> Entitas Account

Candidate Key= Account_number, balance

Primary Key= account_number

Alternate Key= balance

Foreign Key=-

> Entitas Branch

Candidate Key = branch-name, branch-city,assets

Primary Key = branch-name

Alternate Key = branch-city, assets

> Entitas Customer

Candidate Key = customer-name,customer-street,customer-city

Primary Key = customer-name

Alternate Key = customer-street, customer-city

 > Entitas Loan

Candidate Key = loan-number,amount

Primary Key = loan-number

Alternate Key = amount

LATIHAN2

 gambar di samping adalah jawaban dari soal diatas untuk point pertama

jawaban untuk tabel keterhubungan

Primary key nya adalah NIS,Kode_mapel, dan NIS

ER Diagram