LAPORAN ONE TO MANY

create Database Jurusan
Use Jurusan
Create Table Jurusan(
Kd_Jurusan Char(5),
NamaJurusan varchar (30))
Select * from Jurusan
insert into Jurusan Values ('MI01','Manajemen Informatika')
insert into Jurusan Values ('Ak01','Akuntansi')
insert into Jurusan Values ('TI01','Tekhnik Industri')
insert into Jurusan Values ('S01','Sastra')
insert into Jurusan Values ('IK01','Ilmu Komunikasi')
Select * from Jurusan

Create Table Pilihan(
NIP Char(5)not null primary key,
Nama_Mahasiswa Char(30),
Jns_Kelamin Varchar(3),
Alamat Varchar(15),
Kd_Jurusan Char(5),
Constraint F_Pilihan Foreign Key(Kd_Jurusan)References Jurusan(Kd_Jurusan))
Select * from Pilihan
Insert into Pilihan Values('0001','Yanthie','P','Jl.Pangad No.8','TI01')
Insert into Pilihan Values('0002','Yongkie','L','Jl.Kasad No.17','S01')
Insert into Pilihan Values('0003','Kumala','P','Jl.Batalyon No.21','IK01')
Insert into Pilihan Values('0004','Andika','L','Jl.Regu No.11','Ak01')
Insert into Pilihan Values('0005','Pratama','L','Jl.Bajoka No.101','MI01')
Select * From Pilihan