Catatan Oracle

MHS
NIM varchar(9),
Nama Varchar(25),
Tgl. Lahir Date
Jenis Kelamin Varchar(2)
Alamat Varchar(50)
Kd_Jur Varchar2(5)

JURUSAN
Kd_Jur varchar(5),
Jurusan varchar(20),
lm_pend(2)

Kd_MK
Nama Varchar(10)
Kd_Jur varchar(5)
Jml_SKS Varchar(5)

Grade
Nilai_Awal Number(5)
Nilai_Akhir Number(3)
Grade varchar2(2)

creat table nama_table
Atribut value,

Insert Into nm_table Values ('Atribut','Atribut',)

Jurusan :
1. Teknik Informatika
2. Sistem Informasi
3 Manajemen Informatika

Mata Kuliah :
001, Matdis, 1,3
002, Tekonologi WEB, 2,2
003, APS, 3,3
004, Sistem Digital, 7,2
005, RPL, 3,3

Grade :
95 - 100 A
85 - 90 B+
75 - 80 B
65 - 70 C+
55 - 60 C
45 - 50 D+
25 - 40 D
0 - 30 E

Sekian dulu catatan dari oracle Pelajaran Kamis, 19 Maret 2009

Code Cruzen Yang Jalan
create table mhs
(NIM varchar (9),
nama varchar (25),
tgl_lahir date,
jenis_kelamin varchar (2),
alamat varchar (50),
kd_jur varchar (5));

drop table mhs

create table jur
(kd_jur varchar (5),
jurusan varchar (25),
lm_pendidikan varchar (2));

drop table jur

create table mk
(kd_mk varchar (6),
nama_mk varchar (15),
kd_jur varchar (5),
jumlah_sks varchar (3));

drop table mk

create table grade
(nilai_awal number (3),
nilai_akhir number (3),
grade varchar (2));

drop table grade
---------------------------------------------------------------------------------------

insert into mhs values ('TI001', 'Budi', '19-dec-86', 'L', 'Tangerang', '1');
insert into mhs values ('TI002', 'Andi', '31-mar-88', 'L', 'Jakarta', '1');
insert into mhs values ('SI001', 'Dina', '28-jun-85', 'P', 'Bogor', '2');
insert into mhs values ('SI003', 'Ariel', '18-apr-86', 'P', 'Bandung', '2');
insert into mhs values ('MI001', 'Doni', '20-aug-90', 'L', 'Depok', '3');

select * from mhs
---------------------------------------------------------------------------------------

insert into jur values ('1', 'Teknik Informatika', '2');
insert into jur values ('2', 'Sistem Informasi', '3');
insert into jur values ('3', 'Manajemen Informatika', '4');

select * from jur

---------------------------------------------------------------------------------------

insert into mk values ('0001', 'Matdis', '2', '3');
insert into mk values ('0002', 'Teknologi Web', '2', '2');
insert into mk values ('0003', 'APS', '3', '3');
insert into mk values ('0004', 'Sistem Digital', '1', '2');
insert into mk values ('0005', 'RPL', '3', '3');

select * from mk

---------------------------------------------------------------------------------------

insert into grade values (95, 100, 'A');
insert into grade values (85, 90, 'B+');
insert into grade values (75, 80, 'B');
insert into grade values (65, 70, 'C+');
insert into grade values (55, 60, 'D');
insert into grade values (45, 50, 'D+');
insert into grade values (35, 40, 'D');
insert into grade values (0, 30, 'E');

select * from grade