Silahkan masukkan instruksi SQL untuk:
- Mengcreate TABEL Customer (DDL)
- Memasukkan Data pada Tabel Customer (DML)
Datanya untuk Master Customer silahkan tentukan sendiri
sementara ini gunakan 10 record untuk master customer
Silahkan tuliskan instruksinya di comment
Blogged with the Flock Browser
Tags: pieceof code
on 
CREATE TABLE MsCustomer (
KodeCust VARCHAR2(5)
CONSTRAINT kdcust_pk PRIMARY KEY,
NamaCust VARCHAR2 (25)
CONSTRAINT nama_cust_nn NOT NULL,
Alamat VARCHAR2 (50)
CONSTRAINT alamat_cust_nn NOT NULL,
Telp VARCHAR2 (12)
CONSTRAINT telp_cust_nn NOT NULL,
Email VARCHAR2 (25)
);
INSERT INTO MsCustomer VALUES (‘CS001′,’Cua’,'Jl.laptop’,’087899787844′,’gg@gg.com’);
INSERT INTO MsCustomer VALUES (‘CS002′,’Cubby’,'Jl.driver’,’085988594848′,’hh@hh.com’);
INSERT INTO MsCustomer VALUES (‘CS003′,’Cuce’,'Jl.monitor’,’08171247890′);
INSERT INTO MsCustomer VALUES (‘CS004′,’Cudi’,'Jl.Software’,’0813131399′,’jj@jj.com’);
INSERT INTO MsCustomer VALUES (‘CS005′,’Cuen’,'Jl.buku IT’,’081234589811′);
INSERT INTO MsCustomer VALUES (‘CS006′,’Cufi’,'Jl.handycam’,’0888812388′);
INSERT INTO MsCustomer VALUES (‘CS007′,’Cien’,'Jl.Optic Drive’,’021338899′);
INSERT INTO MsCustomer VALUES (‘CS008′,’Cugi’,'Jl.Mouse Pad’,’031332288′,’kk@kk.com’);
INSERT INTO MsCustomer VALUES (‘CS009′,’Cuhen’,'Jl.Touch Screen’,’0219882211′,’po@po.com’);
INSERT INTO MsCustomer VALUES (‘CS010′,’Cupin’,'Jl.Keyboard’,’087833661122′);
NIM : 1000854946
06PGT
CREATE TABLE MsPelanggan{
IdPelanggan int NOT NULL,
NamaPelanggan Varchar (20) NOT NULL,
AlamatPelanggan Varchar (50) NOT NULL,
NoTelpPelanggan int NOT NULL,
EmailPelanggan varchar (50) NOT NULL,
}
INSERT INTO MsPelanggan VALUES (‘F0001′,’Fernando’, ‘Jln. FEr_cAP01′, ’08988243404′, ‘fer_cap_2004@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0002′,’Fernandi’, ‘Jln. FEr_cAP02′, ’08988243405′, ‘fer_cap_2005@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0003′,’Fernandu’, ‘Jln. FEr_cAP03′, ’08988243406′, ‘fer_cap_2006@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0004′,’Fernanda’, ‘Jln. FEr_cAP04′, ’08988243407′, ‘fer_cap_2007@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0005′,’Fernande’, ‘Jln. FEr_cAP05′, ’08988243408′, ‘fer_cap_2008@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0006′,’Febri’, ‘Jln. FEr_cAP06′, ’08988243409′, ‘fer_cap_2009@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0007′,’Febro’, ‘Jln. FEr_cAP07′, ’08988243410′, ‘fer_cap_2010@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0008′,’Febru’, ‘Jln. FEr_cAP08′, ’08988243411′, ‘fer_cap_2011@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0009′,’Febra’, ‘Jln. FEr_cAP09′, ’08988243412′, ‘fer_cap_2012@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (‘F0010′,’Febre’, ‘Jln. FEr_cAP10′, ’08988243413′, ‘fer_cap_2013@yahoo.co.id’);
1000860652
06PGT
CREATE TABLE MsCustomer
(
KdCustomer CHAR(5) PRIMARY KEY,
NamaCustomer VARCHAR(50),
AlamatCustomer VARCHAR(100),
TelpCustomer VARCHAR(15)
);
INSERT INTO MsCustomer VALUES (’C001′, ‘Frank’, ‘Jl. A no 1’, ‘4534275687′);
INSERT INTO MsCustomer VALUES (’C002′, ‘Michael’, ‘Jl. B no 2’, ‘1356846798′);
INSERT INTO MsCustomer VALUES (’C003′, ‘Sarah’, ‘Jl. C no 3’, ‘4576245980′);
INSERT INTO MsCustomer VALUES (’C004′, ‘Clive’, ‘Jl. D no 4’, ‘1258765398′);
INSERT INTO MsCustomer VALUES (’C005′, ‘Brad’, ‘Jl. E no 5’, ‘2574357784′);
INSERT INTO MsCustomer VALUES (’C006′, ‘Jennifer’, ‘Jl. F no 6 ‘, ‘2769045623′);
INSERT INTO MsCustomer VALUES (’C007′, ‘Angelina’, ‘Jl. G no 7′, ‘1487053642′);
INSERT INTO MsCustomer VALUES (’C008′, ‘John’, ‘Jl. H no 8′, ‘2670356734′);
INSERT INTO MsCustomer VALUES (’C009′, ‘Julia’, ‘Jl. I no 9′, ‘4815094578′);
INSERT INTO MsCustomer VALUES (’C010′, ‘Edward’, ‘Jl. J no 10’, ‘4603478254′);
Susanti
1000861503
06PGT
CREATE TABLE MsCustomer
(
KdCustomer CHAR(5) PRIMARY KEY,
NamaCustomer VARCHAR(50),
AlamatCustomer VARCHAR(50),
TelpCustomer VARCHAR(20),
)
INSERT INTO MsCustomer(‘C0115′,’Anto’,'Jl.Kemayoran no.23′,’0817980798′);
INSERT INTO MsCustomer(‘C1192′,’Angung’,'Jl.Kemanggisan Barat no.21′,’085229823208′);
INSERT INTO MsCustomer(‘C9898′,’Angelina’,'Jl.Meruya Barat no 45′,’081823213422′);
INSERT INTO MsCustomer(‘C8768′,’Anastasia’,'Jl.Raya Hilir no. 21′,’0819221344′);
INSERT INTO MsCustomer(‘C8762′,’Rayne’,'Jl.Jeruk no 67′,’081234323322′);
INSERT INTO MsCustomer(‘C9876′,’Ami’,'Jl.Kamboja Barat no.31E’,’081392736443′);
INSERT INTO MsCustomer(‘C1234′,’Kirana’,'Jl.Kampung Baru no.29′,’0811231344′);
INSERT INTO MsCustomer(‘C5678′,’Riska’,'Jl.Manggis no. 89′,’081908863837′);
INSERT INTO MsCustomer(‘C6789′,’Susi’,'Jl.Kumbangan Raya no.78′,’0811242213′);
INSERT INTO MsCustomer(‘C7865′,’Jessica’,'Jl.Kebayoran Baru’,’08172393432′);
1000835764
06PGT
CREATE TABLE MsCustomer (
CustomerId VARCHAR2(5) NOT NULL,
CustomerName VARCHAR2(25) NOT NULL,
CustomerAddress VARCHAR2(60) NOT NULL,
CustomerPhone VARCHAR2(15) NOT NULL,
CustomerEmail VARCHAR2(25) NOT NULL,
PRIMARY KEY(CustumerId)
);
INSERT INTO MsCustomer VALUES (’C001,’A’,’Jln A’,’M’,’1231232,’a@a.com’);
INSERT INTO MsCustomer VALUES (’C002,’B’,’Jln B’,’M’,’1231231,’b@b.com’);
INSERT INTO MsCustomer VALUES (’C003,’C’,’Jln C’,’F’,’1231231,’c@c.com’);
INSERT INTO MsCustomer VALUES (’C004,’D’,’Jln D’,’M’,’7623123,’d@d.com’);
INSERT INTO MsCustomer VALUES (’C005,’E’,’Jln E’,’F’,’2097896,’f@f.com’);
INSERT INTO MsCustomer VALUES (’C006,’F’,’Jln F’,’M’,’6523845,’g@g.com’);
INSERT INTO MsCustomer VALUES (’C007,’G’,’Jln G’,’F’,’8924532,’h@h.com’);
INSERT INTO MsCustomer VALUES (’C008,’H’,’Jln H’,’M’,’8544761,’i@i.com’);
INSERT INTO MsCustomer VALUES (’C009,’I’,’Jln I’,’F’,’9812546,’e@e.com’);
INSERT INTO MsCustomer VALUES (’C010,’J’,’Jln J’,’F’,’7629485,’j@j.com’);
Beny
1000867734
06PGT
- Mengcreate TABEL Customer (DDL)
CREATE TABLE MsCustomer
(
kodeCustomer char(5) primary key not null,
namaCustomer varchar(25) not null,
alamatCustomer varchar(40)
);
- Memasukkan Data pada Tabel Customer (DML)
insert into MsCustomer values(’c0001′,’Squall’,’Jl. Empang 3’);
insert into MsCustomer values(’c0002′,’Zidane’,’Jl. Batusari’);
insert into MsCustomer values(’c0003′,’Rinoa’,’Jl. Pertamburan’);
insert into MsCustomer values(’c0004′,’Tidus’,’Jl. Menteng’);
insert into MsCustomer values(’c0005′,’Seifer’,’Jl. Pejaten Barat’);
insert into MsCustomer values(’c0006′,’Steiner’,’Jl. Pejaten Timur’);
insert into MsCustomer values(’c0007′,’Garnet’,’Jl. Lenteng Agung’);
insert into MsCustomer values(’c0008′,’Yuna’,’Jl. Kuningan’);
insert into MsCustomer values(’c0009′,’Vivi’,’Jl. Medan Merdeka’);
insert into MsCustomer values(’c0010′,’Eiko’,’Jl. Gatot Subroto’);
/* Andreyus – 1000839560 (06PGT) */
create table Customer
(
KodeCustomer varchar2(10) primary key,
NamaCustomer varchar2(30),
AlamatCustomer varchar2(50),
TelpCustomer varchar2(30),
EmailCustomer varchar2(30)
);
insert into Customer values(‘KC001′,’Amank William’,'Jl. Salak no.41′,’65474457′,’amangblue@yahoo.com’);
insert into Customer values(‘KC002′,’Dhani Wirawan’,'Jl. Anggrek Cakra no.32′,’34565465′,’zelldintch@yahoo.co.id’);
insert into Customer values(‘KC003′,’Steven Kusuma’,'Jl. Bekasi Utara no. 3′,’65773457′,’hanhan@gmai.com’);
insert into Customer values(‘KC004′,’Ronaldy Wijaya’,'Jl. Kuntien Lama no. 96′,’55475345′,’loulingfan@hotmail.com’);
insert into Customer values(‘KC005′,’Hartini Deliana’,'Jl. Tambora III no. 19′,’23457774′,’delde@yahoo.com’);
insert into Customer values(‘KC006′,’Rosmiyani Wong Ve’,'Jl. Kemayoran Raya no. 84′,’45678435′,’kukulwong@gmail.com’);
insert into Customer values(‘KC007′,’Fajar Herlambang’,'Jl. Bekasi Raya no. 23′,’565477544′,’oeikifjr@hotmail.com’);
insert into Customer values(‘KC008′,’Joe Dianto Andrey’,'Jl. Pasar Baru no. 11′,’76524564′,’jdgitulo@yahoo.com’);
insert into Customer values(‘KC009′,’Michael Yosep’,'Jl. Cendana no. 54′,’65687543′,’yphehe@gmail.com’);
insert into Customer values(‘KC010′,’Veronica Tantri’,'Jl. Pontianak Ujung no. 88′,’45678845′,’veroyuhu@yahoo.com’);
create table Customer
(
CustomerID char(5) primary key not null,
CustomerName varchar(30) not null,
CustomerEmail varchar(30),
CustomerSex varchar(10) not null
);
INSERT INTO customer VALUES (‘CS001′, ‘Andi’, ‘a@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS002′, ‘Budi’, ‘b@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS003′, ‘Cendi’, ‘c@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS004′, ‘Dodi’, ‘d@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS005′, ‘Ery’, ‘e@yahoo.com’, ‘Female’);
INSERT INTO customer VALUES (‘CS006′, ‘Fendi’, ‘f@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS007′, ‘Ghandi’, ‘g@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS008′, ‘Hendi’, ‘h@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS009′, ‘Indri’, ‘i@yahoo.com’, ‘Male’);
INSERT INTO customer VALUES (‘CS010′, ‘Jodi’, ‘j@yahoo.com’, ‘Female’);
erfan melanaga
1000873503
create table pelanggan
(
idPelanggan varchar2(10) PRIMARY KEY,
nm varchar2(50),
alamat varchar2(50),
telp varchar2(50),
umur numeric,
email varchar2(50) UNIQUE
);
insert into pelanggan values(‘PL001′,’erfan’,'Jl. Joglo raya’,’08568925957′,20,’melanaga@yahoo.com’);
insert into pelanggan values(‘PL002′,’milan’,'Jl. binus No.13′,’08568925958′,21,’milan@yahoo.co.id’);
insert into pelanggan values(‘PL003′,’Riko’,'Jl. Penghibur No.14′,’08568925959′,20,’rika@yahoo.com’);
insert into pelanggan values(‘PL004′,’Andi’,'Jl. Binus2 No.12′,’08568925950′,25,’andi83@yahoo.com’);
insert into pelanggan values(‘PL005′,’Herwin’,'Jl. Binus3 No.10′,’08568925951′,18,’herwin@yahoo.com’);
insert into pelanggan values(‘PL006′,’Andrew’,'Jl. Binus4 No.9′,’08568925952′,24,’andrew@yahoo.com’);
insert into pelanggan values(‘PL007′,’Renaldy’,'Jl. Binus5 No.28′,’08568925953′,23,’renaldy@yahoo.com’);
insert into pelanggan values(‘PL008′,’Harianto’,'Jl. Binus6 No.48′,’08568925954′,21,’harianto@yahoo.com’);
insert into pelanggan values(‘PL009′,’Andrey’,'Jl. Binus7 No.7′,’08568925955′,22,’andrey@yahoo.com’);
insert into pelanggan values(‘PL010′,’Rudy’,'Jl. Binus8 No.8′,’08568925956′,19,’rudy@yahoo.com’);
create table MsCustomer
(
KdCustomer varchar(10) primary key not null,
NamaCustomer varchar(30) not null,
AlamatCustomer varchar(50) not null,
TelpCustomer varchar(30) not null,
EmailCustomer varchar(30)
);
insert into MsCustomer values(‘CS001’,’Hamdi’,’Jl. Anoa no.1’,’021-8408210’,’a@yahoo.com’);
insert into MsCustomer values(‘CS002’,’Erfan’,’Jl. Bandeng no.2’,’ ‘021-8408211’,’b@yahoo.co.id’);
insert into MsCustomer values(‘CS003’,’Poyuandy’,’Jl. Cemara no. 3’,’ ‘021-8408213’,’c@gmai.com’);
insert into MsCustomer values(‘CS004’,’Angela’,’Jl. Dago no. 4’,’ ‘021-8408214’,’d@hotmail.com’);
insert into MsCustomer values(‘CS005’,’Edwardo’,’Jl. Elang no. 5’,’ ‘021-8408215’,’e@yahoo.com’);
insert into MsCustomer values(‘CS006’,’Anthony’,’Jl. Flamboyan no. 6’,’ ‘021-8408216’,’f@gmail.com’);
insert into MsCustomer values(‘CS007’,’Wunleng’,’Jl. Galah no. 7’,’ ‘021-8408217’,’g@hotmail.com’);
insert into MsCustomer values(‘CS008’,’Hans’,’Jl. Haji Senin no. 8’,’ ‘021-8408218’,’h@yahoo.com’);
insert into MsCustomer values(‘CS009’,’Hendra’,’Jl. Intan no. 9’,’ ‘021-8408219’,’i@gmail.com’);
insert into MsCustomer values(‘CS010’,’Kenrick’,’Jl. Jimbaran no. 10’,’ ‘021-8408220’,’j@yahoo.com’);
CREATE TABLE MsCustomer (
KdCust VARCHAR(5)PRIMARY KEY,
NamaCust VARCHAR (25) NOT NULL,
Telp VARCHAR (12) NOT NULL,
Email VARCHAR (25)
);
INSERT INTO MsCustomer VALUES (‘C0001′,’Cus’,’087877377766′,’cus@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0002′,’Tom’,’08195199283′,’tom@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0003′,’Mer’,’08125170880′,’mer@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0004′,’Custom’,’0811502040′,’custom@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0005′,’Tommer’,’081349876544′,’tommer@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0006′,’Mercus’,’08195130150′,’mercus@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0007′,’Casey’,’08789777857′,’casey@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0008′,’John’,’08115198754′,’john@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0009′,’Chuck’,’08561287456′,’chuck@mail.com’);
INSERT INTO MsCustomer VALUES (‘C0010′,’William’,’085249878755′,’william@mail.com’);
CREATE TABLE MsPelanggan{
IdPelanggan varchar (10) NOT NULL,
NamaPelanggan Varchar (20) NOT NULL,
AlamatPelanggan Varchar (50) NOT NULL,
NoTelpPelanggan int NOT NULL,
EmailPelanggan varchar (20) NOT NULL,
}
INSERT INTO MsPelanggan VALUES (’KP01′,’Pieter’, ‘Jln. Binus01′, ‘08988243404′, ‘e_mail01@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP02′,’Tampan’, ‘Jln. Binus02′, ‘08988243405′, ‘e_mail02@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP03′,’Baik’, ‘Jln. Binus03′, ‘08988243406′, ‘e_mail03@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP04′,’Hati’, ‘Jln. Binus04′, ‘08988243407′, ‘e_mail04@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP05′,’Tidak’, ‘Jln. Binus05′, ‘08988243408′, ‘e_mail05@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP06′,’Sombong’, ‘Jln. Binus06′, ‘08988243409′, ‘e_mail06@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP07′,’Penuh’, ‘Jln. Binus07′, ‘08388243410′, ‘e_mail07@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP08′,’Pengertian’, ‘Jln. Binus08′, ‘08188243411′, ‘e_mail08@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP09′,’Dan’, ‘Jln. Binus09′, ‘0817243412′, ‘e_mail09@yahoo.co.id’);
INSERT INTO MsPelanggan VALUES (’KP10′,’Keren’, ‘Jln. Binus10′, ‘0818243413′, ‘e_mail10@yahoo.co.id’);
Kelompok SQL 06PBT
create table MsCustomer
(
KodeCustomer varchar(5) not null,
NamaCustomer varchar(30) not null,
AlamatCustomer varchar(50) not null,
TelpCustomer varchar(30) not null,
Primary Key KodeCustomer,
constraint SI7 check (len(KodeCustomer) = 5),
constraint SI8 check (KodeCustomer like ‘KS[0-9][0-9][0-9]‘)
);
insert into MsCustomer values(‘KS001’,’Awan’,’Jl. Angrek no.5’,’021-
455446’);
insert into MsCustomer values(‘KS002’,’Deki’,’Jl. Bandeng no.5’,’
‘021-1564623’);
insert into MsCustomer values(‘KS003’,’Abi’,’Jl. Kelapa no. 5’,’ ‘021
-23156456’);
insert into MsCustomer values(‘KS004’,’Peter’,’Jl. Lalala no. 5’,’
‘021-4567842’);
insert into MsCustomer values(‘KS005’,’Okta’,’Jl. Syadan no. 5’,’
‘021-456786’);
insert into MsCustomer values(‘KS006’,’Pieter’,’Jl. Taisir no. 5’,’
‘021-4567869’);
insert into MsCustomer values(‘KS007’,’Albert’,’Jl. Taman Palem no.
5’,’ ‘4567842’);
insert into MsCustomer values(‘KS008’,’Martin’,’Jl. Haji Senin no.
5’,’ ‘021-546578’);
insert into MsCustomer values(‘KS009’,’Robert’,’Jl. Gading no. 5’,’
‘021-4567845’);
insert into MsCustomer values(‘KS010’,’Ferdy’,’Jl. Jelambar no. 5’,’
‘021-4567843’);
DESY AYU P/1000885200/06PGT
create table Customer (
KdCustomer varchar(8) primary key,
NamaCustomer varchar(30),
AlamatCustomer varchar(50),
KdJenisCustomer references JenisCustomer
)
create table JenisCustomer (
KdJenisCustomer varchar(8) primary key
NamaJenisCustomer varchar(20)
)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00001,’Ayesha’,’Kemangisan’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00002,’Andy Elfasa’,’Pamulang’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00003,’Arief’,’Permata Hijau’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer VALUES (C00004,’Ayu’,’Syahdan’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer VALUES (C00005,’Ferdian’,’Tomang’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer VALUES (C00006,’Catur’,’Kemanggisan’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer VALUES (C00007,’Cindra’,’Kemanggisan’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00008,’Shasha’,’Anggrek Cakra’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00009,’Elf’,’Pamulang’)
INSERT INTO Customer (KdCustomer,NamaCustomer,AlamatCustomer) VALUES (C00010,’Rinaldy’,’Senayan’);
INSERT INTO JenisCustomer (KdJenisCustomer,NamaJenisCustomer) VALUES (KC0001,’Rumah Tangga’)
INSERT INTO JenisCustomer (KdJenisCustomer,NamaJenisCustomer) VALUES (KC0002,’Perusahaan’);