Pemrograman SQL Pertemuan 6, Tabel Master Detail
1. Susun Class Diagram menggunakan Rasional Rose
a. Mahasiswa
b. Dosen
c. Mata Kuliah
d. KRS
e. Pembayaran
2. Class
Terdiri dari Nama Class, Atribut, Method
3. Pilihan
relasi yang terbentuk
a. One to one
b. One to many
c. Many to one
d. Many to many
a. One to one
b. One to many
c. Many to one
d. Many to many
4. Susun
tabel Master KRS & Detail KRS
Tabel Master KRS
No
|
Nama
Field
|
Type
|
Size
|
Ket
|
1
|
Nim
|
Varchar
|
10
|
Primary
Key
|
2
|
Tanggal
KRS
|
Date
|
||
3
|
Progdi
|
Varchar
|
20
|
Tabel Detail KRS
No
|
Nama
Field
|
Type
|
Size
|
Ket
|
1
|
Nim
|
Varchar
|
10
|
Secondary
key
|
2
|
Kodematkul
|
Varchar
|
10
|
Secondary
key
|
0 comments:
Post a Comment