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
- Mengcreate TABEL Customer (DDL):
————————————-
create table MsCustomer (
IDCustomer varchar2(20) primary key,
Nama_Customer varchar2(20))
- Memasukkan Data pada Tabel Customer (DML):
insert into MsCustomer values (‘C1′,’Tirtha’);
insert into MsCustomer values (‘C2′,’Novia’);
insert into MsCustomer values (‘C3′,’Rendi’);
insert into MsCustomer values (‘C4′,’Ica’);
insert into MsCustomer values (‘C5′,’Rinaldi’);
insert into MsCustomer values (‘C6′,’Julianto’);
insert into MsCustomer values (‘C7′,’Chandra’);
insert into MsCustomer values (‘C8′,’Bagus’);
insert into MsCustomer values (‘C9′,’Ancur’);
insert into MsCustomer values (‘C10′,’Gokil’);
CREATE TABLE Customer (
KdCust VARCHAR2(5) NOT NULL,
NmCust CHAR(50) NOT NULL ,
AlamatCust CHAR(300),
TelpCust CHAR(30),
PRIMARY KEY (“KDCUST”)
)
Insert Into Customer VALUES (‘C0001′, ‘Ananda’, ‘Jl. Palmerah’, ’123645′);
Insert Into Customer VALUES (‘C0002′, ‘Adinda’, ‘Jl. Suka maju’, ’2123645′);
Insert Into Customer VALUES (‘C0003′, ‘Acoda’, ‘Jl. hidup baru’, ’3123645′);
Insert Into Customer VALUES (‘C0004′, ‘Budi’, ‘Jl. pademangan’, ’4123645′);
Insert Into Customer VALUES (‘C0005′, ‘Dinda’, ‘Jl. kedoya’, ’5123645′);
Insert Into Customer VALUES (‘C0006′, ‘Erna’, ‘Jl. kebayoran baru’, ’6123645′);
Insert Into Customer VALUES (‘C0007′, ‘Franklin’, ‘Jl. lenteng agung’, ’7123645′);
Insert Into Customer VALUES (‘C0008′, ‘Gara’, ‘Jl. selat merah’, ’8123645′);
Insert Into Customer VALUES (‘C0009′, ‘Marel’, ‘Jl. rumah sakit’, ’9123645′);
Insert Into Customer VALUES (‘C0010′, ‘Senot’, ‘Jl. mangga dua’, ’5648971′);
–DDL-
create table MsCustomer (
KodeCustomer varchar2(10) NOT NULL,
NamaCustomer varchar2(50) NOT NULL,
AlamatCustomer varchar2(100) NOT NULL,
TelpCustomer varchar2(15) NOT NULL,
TanggalUpdate DATE
);
–DML–
INSERT INTO MsCustomer VALUES (‘C0001′, ‘Erico’, ‘Jl. Merkurius No.1′, 0812123456780, SYSDATE);
INSERT ALL
INTO MsCustomer VALUES (‘C0002′, ‘Andrianto’, ‘Jl. Venus No.2′, 0812123456781, SYSDATE)
INTO MsCustomer VALUES (‘C0003′, ‘Putu’, ‘Jl. Bumi No.3′, 0812123456782, SYSDATE)
INTO MsCustomer VALUES (‘C0004′, ‘Johan’, ‘Jl. Bulan No.4′, 0812123456783, SYSDATE)
INTO MsCustomer VALUES (‘C0005′, ‘Henri’, ‘Jl. Mars No.5′, 0812123456784, SYSDATE)
INTO MsCustomer VALUES (‘C0006′, ‘Amir’, ‘Jl. Jupiter No.6′, 0812123456785, SYSDATE)
INTO MsCustomer VALUES (‘C0007′, ‘Budi’, ‘Jl. Saturnus No.7′, 0812123456786, SYSDATE)
INTO MsCustomer VALUES (‘C0008′, ‘Caca’, ‘Jl. Uranus No.8′, 0812123456787, SYSDATE)
INTO MsCustomer VALUES (‘C0009′, ‘Didi’, ‘Jl. Neptunus No.9′, 0812123456788, SYSDATE)
INTO MsCustomer VALUES (‘C0010′, ‘Ela’, ‘Jl. Pluto No.10′, 0812123456789, SYSDATE)
SELECT * FROM MsCustomer
^^
oia lupa nim 1000835360
06PGT
[Oracle 10g]
1000842252 / 06PGT
~ORACLE~
Di sini saya tambahkan untuk jenis customer karena Bapak bilang bahwa jenis customer ada 2 yaitu pelanggan rumah yang hanya dapat membeli produk sebanyak 1-10 dan pelanggan perusahaan yang dapat membeli produk sebanyak 20-50, di mana J1 adalah pelanggan rumah dan J2 adalah pelanggan perusahaan.
CREATE TABLE JnsCust
(
KdJnsCust CHAR(5) PRIMARY KEY,
Jenis varchar(20)
);
INSERT INTO JnsCust VALUES (‘J0001′,’J1′);
INSERT INTO JnsCust VALUES (‘J0002′,’J2′);
CREATE TABLE customer
(
KdCust CHAR(5),
NmCust VARCHAR2(20),
KdJnsCust CHAR(5),
CONSTRAINT cust_pk PRIMARY KEY(KdCust),
CONSTRAINT jnsid_fk FOREIGN KEY (KdJnsCust) REFERENCES JnsCust(KdJnsCust)
);
INSERT INTO customer VALUES (‘C0001′,’A',’J0001′);
INSERT INTO customer VALUES (‘C0002′,’B',’J0001′);
INSERT INTO customer VALUES (‘C0003′,’C',’J0001′);
INSERT INTO customer VALUES (‘C0004′,’D',’J0001′);
INSERT INTO customer VALUES (‘C0005′,’E',’J0001′);
INSERT INTO customer VALUES (‘C0006′,’F',’J0002′);
INSERT INTO customer VALUES (‘C0007′,’G',’J0002′);
INSERT INTO customer VALUES (‘C0008′,’H',’J0002′);
INSERT INTO customer VALUES (‘C0009′,’I',’J0002′);
INSERT INTO customer VALUES (‘C0010′,’J',’J0002′);
Kelas: 06PGT
Nim : 1000837265
–Create Table–
CREATE TABLE MsCustomer(
KdCustomer varchar(20) primary key,
NamaCustomer varchar(30),
AlamatCustomer varchar(100),
TelpCustomer varchar(20)
);
–Input Data–
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0001′,’Hermanto’,’Jl.Taman Palem blok E9 no 28′,’9184568′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0002′,’Ivan’,’Jl.Kebon Jeruk Raya no 32′,’08561254255′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0003′,’Rahmania’,’Jl.Kebayoran Baru no 04′,’081854736988′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0004′,’Ervin’,’Jl.Kemanggisan Raya no 13′,’08187452689′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0005′,’Dewi’,’Jl.Gereja St.Theresia no 05′,’08989184531′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0006′,’Yuliana’,’Jl.Cempaka Putih Utara no 29′,’4263184′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0007′,’Connie’,’Jl.Taman Duta Mas blok A3 no 08′,’5679033′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0008′,’Fernando’,’Jl.Menteng Raya no 17′,’08124750264′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0009′,’Angela’,’Jl.Jembatan Dua blok F4 no 05′,’5687921′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0010′,’Edwardo’,’Jl.Kampung Bali I no 18′,’31536418′);
06PGT
1000836306
CREATE TABLE Products
(
KdProduk int NOT NULL,
NamaProduk varchar(50) NOT NULL,
JenisProduk varchar(50) NOT NULL,
HargaSatuan int NOT NULL DEFAULT ’0′ ,
CONSTRAINT product_pk PRIMARY KEY (KdProduk)
)
CREATE SEQUENCE seq_products
MINVALUE 001
START WITH 001
INCREMENT BY 1
NOCACHE
INSERT ALL
INTO Products (KdProduk,NamaProduk, JenisProduk, HargaSatuan)
VALUES (‘P’+seq_products.nextval, ‘Cup 240ml’, ‘Cup’, ’12000′)
INTO Products (KdProduk,NamaProduk, JenisProduk, HargaSatuan)
VALUES (‘P’+seq_products.nextval, ‘Botol 600ml, ‘ Botol ‘, ’19000′)
INTO Products (KdProduk,NamaProduk, JenisProduk, HargaSatuan)
VALUES (‘P’+seq_products.nextval, ‘Botol 1500ml’, ‘Botol’, ’19500′)
INTO Products (KdProduk,NamaProduk, JenisProduk, HargaSatuan)
VALUES (‘P’+seq_products.nextval, ‘Galon 19L’, ‘Galon’, ’6000′)
salah submit pak
Novia Novianty
1000835556 / 06PGT
CREATE TABLE MsPelanggan
{
KdPelanggan VARCHAR2(10) NOT NULL,
NamaPelanggan VARCHAR2(50) NOT NULL,
AlamatPelanggan VARCHAR2(50),
KdJenisPelanggan VARCHAR2(10),
CONSTRAINT mspelanggan_pk PRIMARY KEY (KdPelanggan),
CONSTRAINT fk_jenispelanggan FOREIGN KEY (KdJenisPelanggan)
REFERENCES MsJenisPelanggan(KdJenisPelanggan)
};
INSERT INTO MsPelanggan values (‘C001′,’Novia Novianty’, ‘Jl. KH syahdan no 27′, ‘J001′);
INSERT INTO MsPelanggan values (‘C002′,’Olivia Liestiawan’, ‘Jl. KH syahdan no 26′, ‘J001′)
INSERT INTO MsPelanggan values (‘C003′,’PT. Maju Terus’, ‘Jl. KH syahdan no 25′, ‘J002′)
INSERT INTO MsPelanggan values (‘C004′,’Mario’, ‘Jl. KH syahdan no 24′, ‘J001′)
INSERT INTO MsPelanggan values (‘C005′,’PT. Avicom’, ‘Jl. KH syahdan no 23′, ‘J002′)
INSERT INTO MsPelanggan values (‘C006′,’PT. ABC’, ‘Jl. KH syahdan no 22′, ‘J002′)
INSERT INTO MsPelanggan values (‘C007′,’PT. DEF’, ‘Jl. KH syahdan no 21′, ‘J002′)
INSERT INTO MsPelanggan values (‘C008′,’Irvan’, ‘Jl. KH syahdan no 20′, ‘J001′)
INSERT INTO MsPelanggan values (‘C009′,’Suwanto’, ‘Jl. KH syahdan no 19′, ‘J001′)
INSERT INTO MsPelanggan values (‘C010′,’PT. GHI’, ‘Jl. KH syahdan no 18′, ‘J002′)
Tambahan agar table di atas dapat berfungsi:
CREATE TABLE MsJenisPelanggan
{
KdJenisPelanggan VARCHAR2(5) NOT NULL,
NamaKenisPelanggan VARCHAR2(50) NOT NULL,
CONSTRAINT msjenispelanggan_pk PRIMARY KEY (KdJenisPelanggan),
};
INSERT INTO MsJEnisPelanggan values (‘J001′, ‘Perseorangan’);
INSERT INTO MsJenisPelanggan values (‘J002′, ‘Perusahaan’);
ORACLE
======
CREATE TABLE Customer
{
Customer_id VARCHAR(5) NOT NULL,
Customer_name VARCHAR(50),
Customer_address VARCHAR(100),
Customer_phone VARCHAR(15),
CONSTRAINT cust_pk PRIMARY KEY (Customer_id)
};
INSERT INTO Customer values (‘CS001′, ‘Mario’, ‘Jl. KArtini no 77 Bekasi’, ’08182232323′);
INSERT INTO Customer values (‘CS002′, ‘Adi’, ‘Jl. Panjang no 18 Jakbar’, ’0817232323′);
INSERT INTO Customer values (‘CS003′, ‘Budi’, ‘Jl. Kemanggisan raya no 1 Jakbar’, ’0217384738′);
INSERT INTO Customer values (‘CS004′, ‘Ani’, ‘Jl. Sudirman no 8 Jakpus’, ’08192345345′);
INSERT INTO Customer values (‘CS005′, ‘Anton’, ‘Jl. M.H. Thamrin no 99 Jakpus’, ’0219823256′);
INSERT INTO Customer values (‘CS006′, ‘Udin’, ‘Jl. Jalan no 6 ‘, ’08992324567′);
INSERT INTO Customer values (‘CS007′, ‘Ana’, ‘Jl. Mundur no 11′, ’08568934906′);
INSERT INTO Customer values (‘CS008′, ‘Andi’, ‘Jl. Atas no 56′, ’0816534535′);
INSERT INTO Customer values (‘CS009′, ‘Tono’, ‘Jl. Kebon Jeruk no 90′, ’081923433523′);
INSERT INTO Customer values (‘CS010′, ‘Tina’, ‘Jl. S.Parman no 14 Jakbar’, ’081234565656′);
Nama : Mario
NIM : 1000836136
Kelas: 06PGT
Alfian Arief Phanoto
1000837896
06 PGT
–create table customer–
create table customer
(
kdCust varchar(10) primary key,
nama varchar(50),
jenis varchar(20)
);
–insert table customer–
insert into customer values(’1′,’Adi’,'Company’);
insert into customer values(’2′,’Budi’,'Self’);
insert into customer values(’3′,’Caca’,'Store’);
insert into customer values(’4′,’Dudi’,'Store’);
insert into customer values(’5′,’Echa’,'Self’);
insert into customer values(’6′,’Fany’,'Sefl’);
insert into customer values(’7′,’Gilang’,'Company’);
insert into customer values(’8′,’Harry’,'Company’);
insert into customer values(’9′,’Ignatius’,'Store’);
insert into customer values(’10′,’Jacob’,'Self’);
Alfian Arief Phanoto
1000837896
06 PGT
create table customer
(
kdCust varchar(10) primary key,
nama varchar(50),
jenis varchar(20)
);
insert into customer values(’1′,’Adi’,'Company’);
insert into customer values(’2′,’Budi’,'Self’);
insert into customer values(’3′,’Caca’,'Store’);
insert into customer values(’4′,’Dudi’,'Store’);
insert into customer values(’5′,’Echa’,'Self’);
insert into customer values(’6′,’Fany’,'Sefl’);
insert into customer values(’7′,’Gilang’,'Company’);
insert into customer values(’8′,’Harry’,'Company’);
insert into customer values(’9′,’Ignatius’,'Store’);
insert into customer values(’10′,’Jacob’,'Self’);
msCustomer
===========
create table msCustomer
(
kdCustomer char(5) primary key,
kdJenisCustomer char(5),
namaCustomer varchar(20),
foreign key (kdCustomer) references msJenisCustomer
);
create table msJenisCustomer
(
kdJenisCustomer char(5) primary key,
jenisCustomer varchar(20)
);
insert into msJenisCustomer values(‘J001′,’Perorangan’);
insert into msJenisCustomer values(‘J002′,’Perusahaan’);
insert into msCustomer values(‘P001′,’J001′,’Juriana’);
insert into msCustomer values(‘P002′,’J001′,’Febby’);
insert into msCustomer values(‘P003′,’J001′,’Martha’);
insert into msCustomer values(‘P004′,’J001′,’Aprilia’);
insert into msCustomer values(‘P005′,’J001′,’Maymay’);
insert into msCustomer values(‘P006′,’J001′,’Juniawan’);
insert into msCustomer values(‘P007′,’J001′,’Juliana’);
insert into msCustomer values(‘P008′,’J001′,’Agus’);
insert into msCustomer values(‘P009′,’J002′,’PT.Septa Ria’);
insert into msCustomer values(‘P010′,’J002′,’PT.OK’);
Marlene (1000867860)
06PGT
msCustomer
===========
create table msCustomer
(
kdCustomer char(5) primary key,
kdJenisCustomer char(5),
namaCustomer varchar(20),
foreign key (kdCustomer) references msJenisCustomer
);
create table msJenisCustomer
(
kdJenisCustomer char(5) primary key,
jenisCustomer varchar(20)
);
insert into msJenisCustomer values(‘J001′,’Perorangan’);
insert into msJenisCustomer values(‘J002′,’Perusahaan’);
insert into msCustomer values(‘C001′,’J001′,’Juriana’);
insert into msCustomer values(‘C002′,’J001′,’Febby’);
insert into msCustomer values(‘C003′,’J001′,’Martha’);
insert into msCustomer values(‘C004′,’J001′,’Aprilia’);
insert into msCustomer values(‘C005′,’J001′,’Maymay’);
insert into msCustomer values(‘C006′,’J001′,’Juniawan’);
insert into msCustomer values(‘C007′,’J001′,’Juliana’);
insert into msCustomer values(‘C008′,’J001′,’Agus’);
insert into msCustomer values(‘C009′,’J002′,’CT.Septa Ria’);
insert into msCustomer values(‘C010′,’J002′,’CT.OK’);
Marlene (1000867860)
06PGT
*maaf yg sebelumnya ada kesalahan ketik di kode customer yg insert ms customernya
1000858370/I Putu Ananta Yogiswara/06PGT
SQL> CREATE TABLE customer(
2 KODE_CUSTOMER char(6),
3 NAMA_CUSTOMER varchar2(30),
4 ALAMAT_CUSTOMER varchar2(30),
5 KOTA_CUSTOMER varchar2(15),
6 TELEPON_CUSTOMER varchar2(15),
7 constraint pk_customer PRIMARY KEY(KODE_CUSTOMER)
8 );
SQL> INSERT INTO customer VALUES(‘J-0001′,’TOKO KARISMA’,'JL CIMANGGIS 34′,’JAKARTA’,'(021)856-4209′);
SQL> INSERT INTO customer VALUES(‘J-0002′,’TOKO AYU’,'JL CIMANGGIS 12′,’JAKARTA’,'(021)856-1321′);
SQL> INSERT INTO customer VALUES(‘B-0001′,’TOKO WARNA’,'JL ABC 234′,’BANDUNG’,'(022)432-6635′);
SQL> INSERT INTO customer VALUES(‘B-0002′,’TOKO SURYA’,'JL ABC 309′,’BANDUNG’,'(022)432-6024′);
SQL> INSERT INTO customer VALUES(‘J-0003′,’TOKO BUDI’,'JL ANGGREK 49′,’JAKARTA’,'(021)856-6329′);
SQL> INSERT INTO customer VALUES(‘D-0001′,’TOKO SURYA’,'JL DURI 03′,’DEPOK’,'(021)897-0921′);
SQL> INSERT INTO customer VALUES(‘B-0003′,’TOKO CAKRA’,'JL CIAMPLAS 05′,’BANDUNG’,'(021)432-6787′);
SQL> INSERT INTO customer VALUES(‘B-0004′,’TOKO SYAHDAN’,'JL SOEKARNO 87′,’BANDUNG’,'(021)432-0912′);
SQL> INSERT INTO customer VALUES(‘J-0004′,’TOKO MANGGIS’,'JL PEMUDA 76′,’JAKARTA’,'(021)856-4532′);
SQL> INSERT INTO customer VALUES(‘J-0005′,’TOKO SYAHDAN’,'JL BALI 65′,’JAKARTA’,'(021)856-4961′);
Nim : 1000868075
Kelas : 06PGT
———- untuk mengcreate table ———-
CREATE TABLE MasterCustomer
(
KodeCustomer varchar(10)primary key,
NamaCustomer varchar(30),
AlamatCustomer varchar(50),
TeleponCustomer varchar(15)
);
———- untuk insert ———-
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0001′,’Randie’,'Jl. Nuri no 45′,’0218719888′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0002′,’Donny’,’Jl.Apel no 12′,’0234562783′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0003′,’Tukiyem’,’Jl. Mangga no 2′,’8492784523′);
INSERT INTO MsCustomer(KdCustomer, NamaCustomer, AlamatCustomer, TelpCustomer) VALUES(’C0004′,’Anton’,’Jl. Melon no 23′,’7364782983′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0005′,’Tarjo’,’Jl.Semangka no 3′,’4535672349′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0006′,’Suci’,’Jl.Cakra no 23′,’2341239876′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0007′,’Takizawa’,’Jl.Manggis no 5′,’2387165765′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0008′,’Ponari’,’Jl. Salak no 8′,’6275634512′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0009′,’Juminten’,’Jl. Kelapa no 6′,’6372654981′);
INSERT INTO MasterCustomer(KodeCustomer, NamaCustomer, AlamatCustomer, TeleponCustomer) VALUES(’C0010′,’Tukul’,’Jl. Jeruk Asem no 4′,’5267356187′);
1000842624/06PGT
CREATE TABLE JenisPelanggan
(
KdJenisPelanggan CHAR(5) PRIMARY KEY,
JenisPelanggan varchar(20)
);
INSERT INTO JenisPelanggan VALUES (’J001′,’Perorangan’);
INSERT INTO JenisPelanggan VALUES (’J002′,’Perusahaan’);
CREATE TABLE Pelanggan
(
KdPelanggan CHAR(5) NOT NULL PRIMARY KEY,
NamaPelanggan VARCHAR2(20),
KdJenisPelanggan CHAR(5) FOREIGN KEY REFERENCES JenisPelanggan(KdJenisPelanggan),
);
INSERT INTO Pelanggan VALUES (’C001′,’A’,’J001′);
INSERT INTO Pelanggan VALUES (’C002′,’B’,’J001′);
INSERT INTO Pelanggan VALUES (’C003′,’C’,’J001′);
INSERT INTO Pelanggan VALUES (’C004′,’D’,’J001′);
INSERT INTO Pelanggan VALUES (’C005′,’E’,’J001′);
INSERT INTO Pelanggan VALUES (’C006′,’F’,’J002′);
INSERT INTO Pelanggan VALUES (’C007′,’G’,’J002′);
INSERT INTO Pelanggan VALUES (’C008′,’H’,’J002′);
INSERT INTO Pelanggan VALUES (’C009′,’I’,’J002′);
INSERT INTO Pelanggan VALUES (’C010′,’J’,’J002′);
*untuk atribute Pelanggan bisa ditambahin lai seperti alamat, no telp dan lain sebagainya ya.. hehe… thx
CREATE TABLE MsCustomer (
CustNo VARCHAR2(5) NOT NULL,
CustName VARCHAR2(30) NOT NULL,
CustAddress VARCHAR2(50) NOT NULL,
CustGender CHAR(1) NOT NULL,
CustPhone VARCHAR2(10) NOT NULL,
CustEmail VARCHAR2(20) NOT NULL,
PRIMARY KEY(CustNo)
);
INSERT INTO MsCustomer VALUES (‘C001′,’Aditya’,'Jln A’,'M’,’1234567′,’a@a.com’);
INSERT INTO MsCustomer VALUES (‘C002′,’Andi’,'Jln B’,'M’,’3459871′,’di@a.com’);
INSERT INTO MsCustomer VALUES (‘C003′,’Anita’,'Jln C’,'F’,’9876548′,’ni@a.com’);
INSERT INTO MsCustomer VALUES (‘C004′,’Budi’,'Jln D’,'M’,’7652543′,’b@a.com’);
INSERT INTO MsCustomer VALUES (‘C005′,’Chacha’,'Jln E’,'F’,’2097896′,’ch@a.com’);
INSERT INTO MsCustomer VALUES (‘C006′,’Deri’,'Jln F’,'M’,’6539845′,’d@a.com’);
INSERT INTO MsCustomer VALUES (‘C007′,’Wanda’,'Jln G’,'F’,’8976532′,’w@a.com’);
INSERT INTO MsCustomer VALUES (‘C008′,’Ferry’,'Jln H’,'M’,’8548761′,’F@a.com’);
INSERT INTO MsCustomer VALUES (‘C009′,’Mira’,'Jln I’,'F’,’98125467′,’m@a.com’);
INSERT INTO MsCustomer VALUES (‘C010′,’popi’,'Jln J’,'F’,’7629485′,’p@a.com’);
.. 1000878883 ..
create table SalesPerson (
idSP varchar(10) primary key
nameSP varchar(30),
addrSP varchar(50)
)
Insert all
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0001,’Chad Michael Murray’,’Jl.Kemanggisan Barat No.2’)
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0002,’Bethany Joy Lenz’,’Jl.Mahoni No.18 Ciputat’)
Into SalesPerson (idSP,nameSP,addrSP) Values (SP0003,’Hillary Burton’,’Jl.Tangerang Raya No.202’);
.. 1000878883 ..
create table Customer (
idCust varchar(10) primary key
nameCust varchar(30),
addrCust varchar(50)
)
Insert all
Into Customer (idCust,nameCust,addrCust) Values (C00001,’Nicholas Cage’,Bintaro)
Into Customer (idCust,nameCust,addrCust) Values (C00002,’Bruce Willis’,Serpong)
Into Customer (idCust,nameCust,addrCust) Values (C00003,’Sandra Bullock’,Bintaro)
Into Customer (idCust,nameCust,addrCust) Values (C00004,’Julia Robert’,Serpong)
Into Customer (idCust,nameCust,addrCust) Values (C00005,’Vin Diesel’,Ciputat)
Into Customer (idCust,nameCust,addrCust) Values (C00006,’Russel Crowe’,Ciputat)
Into Customer (idCust,nameCust,addrCust) Values (C00007,’Ambler Tamblyin’,Slipi)
Into Customer (idCust,nameCust,addrCust) Values (C00008,’Britany Murphy’,Pamulang)
Into Customer (idCust,nameCust,addrCust) Values (C00009,’Dakota Fanning’,Tangerang)
Into Customer (idCust,nameCust,addrCust) Values (C00010,’Denzel Washington’,Slipi);
* maaf pak yg sbelumny ikut ke copy..
–Mengcreate TABEL Customer (DDL)–
CREATE TABLE MsCustomer(
KodeCustomer varchar(5) primary key,
NamaCustomer varchar(30),
AlamatCustomer varchar(50)
);
Memasukkan Data pada Tabel Customer (DML)
INSERT INTO MsCustomer VALUES (’C001′,’Yessica’, ‘Jl. Salam No.45′);
INSERT INTO MsCustomer VALUES (’C002′,’Cindy’, ‘Jl. Salam Raya No.18′);
INSERT INTO MsCustomer VALUES (’C003′,’Brian’, ‘Jl. Sunrise Garden No.12′);
INSERT INTO MsCustomer VALUES (’C004′,’Andreas’, ‘Jl. Kebayoran Lama No.21′);
INSERT INTO MsCustomer VALUES (’C005′,’Coli’, ‘Jl. Kebon Jeruk No.40′);
INSERT INTO MsCustomer VALUES (’C006′,’Ian’, ‘Jl. Kedoya No. 1′);
INSERT INTO MsCustomer VALUES (’C007′,’Valen’, ‘Jl. Palmerah Barat No. 22′);
INSERT INTO MsCustomer VALUES (’C008′,’Diana’, ‘Jl. Kelapa Dua No. 15′);
INSERT INTO MsCustomer VALUES (’C009′,’Dion’, ‘Jl. Tanjung Duren Barat No.8′);
INSERT INTO MsCustomer VALUES (’C010′,’Defi’, ‘Jl. Manggis No.28′);
create table msjeniscustomer
(
kdjeniscustomer varchar2(5) primary key,
jeniscustomer varchar2(100)
);
create table mscustomer
(
kdcustomer varchar2(5) not null primary key,
namacustomer varchar2(100),
alamatcustomer varchar2(100),
teleponcustomer varchar2(12),
kdjeniscustomer varchar2(20),
constraint fk_kdjeniscustomer FOREIGN KEY (kdjeniscustomer) REFERENCES msjeniscustomer(kdjeniscustomer)
);
insert into msjeniscustomer values (‘J001′,’Mahasiswa’);
insert into msjeniscustomer values (‘J002′,’Perusahaan’);
insert into msjeniscustomer values (‘J003′,’Lainnya’);
insert into mscustomer values (‘C001′,’A',’Jl. kemanggisan1′,’081912341232′,’J001′);
insert into mscustomer values (‘C002′,’B',’Jl. kemanggisan2′,’081912341233′,’J001′);
insert into mscustomer values (‘C003′,’C',’Jl. kemanggisan3′,’081912341234′,’J001′);
insert into mscustomer values (‘C004′,’D',’Jl. kemanggisan4′,’081912341235′,’J003′);
insert into mscustomer values (‘C005′,’E',’Jl. kemanggisan5′,’081912341236′,’J003′);
insert into mscustomer values (‘C006′,’F',’Jl. kemanggisan6′,’081912341237′,’J003′);
insert into mscustomer values (‘C007′,’G',’Jl. kemanggisan7′,’081912341238′,’J002′);
insert into mscustomer values (‘C008′,’H',’Jl. kemanggisan8′,’081912341239′,’J002′);
insert into mscustomer values (‘C009′,’I',’Jl. kemanggisan9′,’081912341229′,’J002′);
insert into mscustomer values (‘C0010′,’J',’Jl. kemanggisan10′,’081912341249′,’J001′);
NIM : 1000877211
NAMA : Mely
Kelas : 06PGT
create table msjeniscustomer
(
kdjeniscustomer varchar2(5) primary key,
jeniscustomer varchar2(100)
);
create table mscustomer
(
kdcustomer varchar2(5) not null primary key,
namacustomer varchar2(100),
alamatcustomer varchar2(100),
teleponcustomer varchar2(12),
kdjeniscustomer varchar2(20),
constraint fk_kdjeniscustomer FOREIGN KEY (kdjeniscustomer) REFERENCES msjeniscustomer(kdjeniscustomer)
);
insert into msjeniscustomer values (‘J001′,’Mahasiswa’);
insert into msjeniscustomer values (‘J002′,’Perusahaan’);
insert into msjeniscustomer values (‘J003′,’Lainnya’);
insert into mscustomer values (‘C001′,’A',’Jl. kemanggisan1′,’081912341232′,’J001′);
insert into mscustomer values (‘C002′,’B',’Jl. kemanggisan2′,’081912341233′,’J001′);
insert into mscustomer values (‘C003′,’C',’Jl. kemanggisan3′,’081912341234′,’J001′);
insert into mscustomer values (‘C004′,’D',’Jl. kemanggisan4′,’081912341235′,’J003′);
insert into mscustomer values (‘C005′,’E',’Jl. kemanggisan5′,’081912341236′,’J003′);
insert into mscustomer values (‘C006′,’F',’Jl. kemanggisan6′,’081912341237′,’J003′);
insert into mscustomer values (‘C007′,’G',’Jl. kemanggisan7′,’081912341238′,’J002′);
insert into mscustomer values (‘C008′,’H',’Jl. kemanggisan8′,’081912341239′,’J002′);
insert into mscustomer values (‘C009′,’I',’Jl. kemanggisan9′,’081912341229′,’J002′);
insert into mscustomer values (‘C0010′,’J',’Jl. kemanggisan10′,’081912341249′,’J001′);
1000842290 / 06 PGT
ORACLE
CREATE TABLE MsCustomer
(
KodeCustomer CHAR(5),
NamaCustomer VARCHAR2(30),
AlamatCustomer VARCHAR2(30),
TelpCustomer VARCHAR2(20),
CONSTRAINT customer_pk PRIMARY KEY(KodeCustomer)
);
INSERT INTO MsCustomer VALUES(‘C0001′,’Alpha’,'Jl. Binuss No.1′,’021-8878702′);
INSERT INTO MsCustomer VALUES(‘C0002′,’Beta’,'Jl. Binuss No.2′,’021-7777202′);
INSERT INTO MsCustomer VALUES(‘C0003′,’Charlie’,'Jl. Binuss No.3′,’021-4527765′);
INSERT INTO MsCustomer VALUES(‘C0004′,’Daniel’,'Jl. Binuss No.4′,’0285-424875′);
INSERT INTO MsCustomer VALUES(‘C0005′,’Erick’,'Jl. Binuss No.5′,’021-8465461′);
INSERT INTO MsCustomer VALUES(‘C0006′,’Fransisca’,'Jl. Binuss No.6′,’021-6463678′);
INSERT INTO MsCustomer VALUES(‘C0007′,’Garry’,'Jl. Binuss No.7′,’021-5635723′);
INSERT INTO MsCustomer VALUES(‘C0008′,’Hutomo’,'Jl. Binuss No.8′,’021-562178′);
INSERT INTO MsCustomer VALUES(‘C0009′,’Ivan’,'Jl. Binuss No.9′,’021-9216544′);
INSERT INTO MsCustomer VALUES(‘C0010′,’Johan’,'Jl. Binuss No.10′,’021-8567234′);
create table Customer
(
KdCustomer varchar2(10) Primary Key,
NamaCust varchar2(50),
AlamatCust varchar2(50),
TelpCust varchar2(50),
EmailCust varchar2(50) UNIQUE
);
insert into Customer values (‘C0001′,’Ronney’,’Jl. Manchester No. 9′,’081931907321′,’wayneroo@yahoo.com’);
insert into Customer values (‘C0002′,’Tevez’,'Jl. United No. 10′,’0819768548989′,’tevezmu@yahoo.com’);
insert into Customer values (‘C0003′,’Jisung’,'Jl. Park 3 No. 1A’,’08156508008′,’parkjisung@yahoo.com’);
insert into Customer values (‘C0004′,’Ronaldo’,'Jl. Oldtraford No. 7′,’08170001787′,’cr7@yahoo.com’);
insert into Customer values (‘C0005′,’Ferdinand’,’Jl. Syahdan No. 104’,’0854445698′,’rioferdi@yahoo.com’);
insert into Customer values (‘C0006′,’Ryan’,'Jl. Taisier 2 No. 12′,’08167895400′,’gigsy@yahoo.com’);
insert into Customer values (‘C0007′,’Edwin’,'Jl. Jaimin No. 8′,’081978783344′,’vandesar@yahoo.com’);
insert into Customer values (‘C0008′,’Alex’,'Jl. Senen No. 99′,’081555446612′,’fergie@yahoo.com’);
insert into Customer values (‘C0009′,’Paul’,'Jl. Anggrek 13′,’0853113777′,’paulscholes@yahoo.com’);
insert into Customer values (‘C0010′,’Gary’,'Jl. Salam 2 No. 9′,’08191348769′,’garyneville@yahoo.com’);
Wunleng Prawijogo
1000839283 (06PGT)
Oracle
–Create Table dan Insert MsJenisCustomer–
CREATE TABLE MsJenisCustomer
(
KdJenisCustomer varchar(6) NOT NULL,
JenisCustomer varchar(20),
CONSTRAINT msjeniscustomerpk PRIMARY KEY (KdJenisCustomer),
);
INSERT INTO MsJenisCustomer VALUES (‘JC001′,’Gold’);
INSERT INTO MsJenisCustomer VALUES (‘JC002′,’Silver’);
–Create Table dan Insert MsCustomer–
CREATE TABLE MsCustomer
{
KdCustomer varchar(6) NOT NULL,
NamaCustomer varchar(30) NOT NULL,
Alamat varchar(100) NOT NULL,
NoTlp varchar(20),
KdJenisCustomer varchar(6) NOT NULL,
CONSTRAINT mscustomerpk PRIMARY KEY (KdCustomer),
CONSTRAINT msjeniscustomerfk FOREIGN KEY (KdJenisCustomer)
REFERENCES MsJenisCustomer(KdJenisCustomer)
};
–Insert Datanya–
INSERT INTO MsCustomer VALUES (‘CU001′,’Mukelele’, ‘Jl. Hore’,’021-1234567′,’JC001′);
INSERT INTO MsCustomer VALUES (‘CU002′,’Drogba’, ‘Jl. Melati’,’021-1234568′,’JC001′);
INSERT INTO MsCustomer VALUES (‘CU003′,’Messi’, ‘Jl. Barcelona’,’021-1234569′,’JC001′);
INSERT INTO MsCustomer VALUES (‘CU004′,’Mukea’, ‘Jl. Lalilulelo’,’021-1234571′,’JC001′);
INSERT INTO MsCustomer VALUES (‘CU005′,’Hurip’, ‘Jl. Kelabu’,’021-1234572′,’JC001′);
INSERT INTO MsCustomer VALUES (‘CU006′,’Donny’, ‘Jl. Keluarga’,’021-1234573′,’JC002′);
INSERT INTO MsCustomer VALUES (‘CU007′,’Freddy’, ‘Jl. Kemanggisan’,’021-1234574′,’JC002′);
INSERT INTO MsCustomer VALUES (‘CU008′,’Doni’, ‘Jl. Sunter’,’021-1234575′,’JC002′);
INSERT INTO MsCustomer VALUES (‘CU009′,’Keren’, ‘Jl. Cumi’,’021-1234576′,’JC002′);
INSERT INTO MsCustomer VALUES (‘CU010′,’Wunz’, ‘Jl. Gurita’,’021-1234577′,’JC002′);
create table customer
(
idCustomer varchar2(10) PRIMARY KEY,
nama varchar2(50),
alamat varchar2(50),
telp varchar2(50),
umur numeric,
email varchar2(50) UNIQUE
);
insert into customer values(‘CS001′,’Anto’,'Jl. Sandang No.8′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS002′,’Budi’,'Jl. Kijang No.5′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS003′,’Rika’,'Jl. Penghibur No.14′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS004′,’Andi’,'Jl. Somba Opu No.12′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS005′,’Herwin’,'Jl. Pattimura No.10′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS006′,’Andrew’,'Jl. Tulip No.9′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS007′,’Renaldy’,'Jl. Katalia No.28′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS008′,’Harianto’,'Jl. Flamboyan No.48′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS009′,’Andrey’,'Jl. Manggis No.7′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS010′,’Rudy’,'Jl. U No.8′,’08194241095′,20,’anto88@yahoo.com’);
NIM : 1000865262
Kelas : 06PGT
Maaf Pak, code yang di atas masih lupa di ganti no tlp, umur, dan emailnya..
ini yang benar Pak.. Terima kasih.
create table customer
(
idCustomer varchar2(10) PRIMARY KEY,
nama varchar2(50),
alamat varchar2(50),
telp varchar2(50),
umur numeric,
email varchar2(50) UNIQUE
);
insert into customer values(‘CS001′,’Anto’,'Jl. Sandang No.8′,’08194241095′,20,’anto88@yahoo.com’);
insert into customer values(‘CS002′,’Budi’,'Jl. Kijang No.8′,’08193454323′,22,’budi@yahoo.com’);
insert into customer values(‘CS003′,’Rika’,'Jl. Penghibur No.14′,’08194241095′,20,’rika@yahoo.com’);
insert into customer values(‘CS004′,’Andi’,'Jl. Somba Opu No.12′,’0819558736′,25,’andi83@yahoo.com’);
insert into customer values(‘CS005′,’Herwin’,'Jl. Pattimura No.10′,’0817345464′,18,’herwin@yahoo.com’);
insert into customer values(‘CS006′,’Andrew’,'Jl. Tulip No.9′,’08192347656′,24,’andrew@yahoo.com’);
insert into customer values(‘CS007′,’Renaldy’,'Jl. Katalia No.28′,’08191239870′,23,’renaldy@yahoo.com’);
insert into customer values(‘CS008′,’Harianto’,'Jl. Flamboyan No.48′,’08134567657′,21,’harianto@yahoo.com’);
insert into customer values(‘CS009′,’Andrey’,'Jl. Manggis No.7′,’08191234654′,22,’andrey@yahoo.com’);
insert into customer values(‘CS010′,’Rudy’,'Jl. U No.8′,’08190987456′,19,’rudy@yahoo.com’);
Nama : Rhio
NIM : 1000867942
kelas : 06PGT
CREATE TABLE customer
(
KdCust CHAR(5),
NmCust VARCHAR2(20),
KdJnsCust CHAR(5),
CONSTRAINT cust_pk PRIMARY KEY(KdCust),
CONSTRAINT jnsid_fk FOREIGN KEY (KdJnsCust) REFERENCES JnsCust(KdJnsCust)
);
INSERT INTO customer VALUES (‘C0001′,’Rhio’,'J0001′);
INSERT INTO customer VALUES (‘C0002′,’Erick’,'J0002′);
INSERT INTO customer VALUES (‘C0003′,’Tomy’,'J0001′);
INSERT INTO customer VALUES (‘C0004′,’Fendy’,'J0002′);
INSERT INTO customer VALUES (‘C0005′,’Windy’,'J0001′);
INSERT INTO customer VALUES (‘C0006′,’Mariana’,'J0002′);
INSERT INTO customer VALUES (‘C0007′,’Herman’,'J0002′);
INSERT INTO customer VALUES (‘C0008′,’Ricky’,'J0001′);
INSERT INTO customer VALUES (‘C0009′,’Daniel’,'J0002′);
INSERT INTO customer VALUES (‘C0010′,’Iman’,'J0001′);
1000863824/06PGT
CREATE TABLE MsCustomer
(
KdCust VARCHAR(5)
CONSTRAINT c_Customer_KdCust_nn NOT NULL
CONSTRAINT c_Customer_KdCust_pk PRIMARY KEY,
NamaCust VARCHAR (20)
CONSTRAINT c_Customer_NamaCust_nn NOT NULL,
Alamat VARCHAR(50)
CONSTRAINT c_Customer_Alamat_nn NOT NULL,
Telp VARCHAR(12)
CONSTRAINT c_Customer_Telp_nn NOT NULL,
)
INSERT INTO MsCustomer VALUES (‘C001′,’Ria’,'Jl.Mangga’,’081808552212′)
INSERT INTO MsCustomer VALUES (‘C002′,’Dini’,'Jl.Apel’,’081256721315′)
INSERT INTO MsCustomer VALUES (‘C003′,’Jun’,'Jl.Durian’,’081177895′)
INSERT INTO MsCustomer VALUES (‘C004′,’Septi’,'Jl.Salak’,’0817552413′)
INSERT INTO MsCustomer VALUES (‘C005′,’Rionald’,'Jl.Manggis’,’085602135524′)
INSERT INTO MsCustomer VALUES (‘C006′,’Frengky’,'Jl.Rambutan’,’08528825653′)
INSERT INTO MsCustomer VALUES (‘C007′,’Indra’,'Jl.Angsana’,’08567854213′)
INSERT INTO MsCustomer VALUES (‘C008′,’Abi’,'Jl.Taisir’,’08123456532)
INSERT INTO MsCustomer VALUES (‘C009′,’Betty’,'Jl.Delima’,’08114525698′)
INSERT INTO MsCustomer VALUES (‘C010′,’Helen’,'Jl.Belimbing’,’08135423691′)
CREATE TABLE MsCustomer(
KodeCustomer CHAR(5) PRIMARY KEY,
NamaCustomer VARCHAR (30) NOT NULL,
AlamatCustomer VARCHAR (100) NOT NULL,
TelpCustomer VARCHAR (20) NOT NULL
);
INSERT INTO MsCustomer VALUES (‘C001′, ‘Markus’, ‘Jl.Utara’, ’012345′);
INSERT INTO MsCustomer VALUES (‘C002′, ‘Venus’, ‘Jl.Timur’, ’123456′);
INSERT INTO MsCustomer VALUES (‘C003′, ‘Gaia’, ‘Jl.Barat’, ’234567′);
INSERT INTO MsCustomer VALUES (‘C004′, ‘Mars’, ‘Jl.Selatan’, ’345678′);
INSERT INTO MsCustomer VALUES (‘C005′, ‘Juptos’, ‘Jl.Tenggara’, ’456789′);
INSERT INTO MsCustomer VALUES (‘C006′, ‘Saturn’, ‘Jl.Barat Laut’, ’567890′);
INSERT INTO MsCustomer VALUES (‘C007′, ‘Neptune’, ‘Jl. Barat Daya’, ’678901′);
INSERT INTO MsCustomer VALUES (‘C008′, ‘Uran’, ‘Jl. Timur Laut’, ’789012′);
INSERT INTO MsCustomer VALUES (‘C009′, ‘Pluto’, ‘Jl. Atas’, ’890123′);
INSERT INTO MsCustomer VALUES (‘C010′, ‘Sedna’, ‘Jl. Bawah’, ’901234′);
1000843015
06 PGT
DDl
Create table MsCustomer
(
KdCustomer char(5) Primary key,
NamaCustomer varchar(25) not null,
AlamatCustomer varchar(50)
);
DML
insert into MsCustomer values (‘CT001′,’Reigor’,'Jl Raya Utara No 34′);
insert into MsCustomer values (‘CT002′,’Zeus’,'Jl Raya Selatan No 56′);
insert into MsCustomer values (‘CT003′,’Nortrom’,'Jl Raya Barat No 84′);
insert into MsCustomer values (‘CT004′,’Queen’,'Jl Raya Timur No 12′);
insert into MsCustomer values (‘CT005′,’Dagon’,'Jl Raya Asia No 77′);
insert into MsCustomer values (‘CT006′,’Spectre’,'Jl Raya Eropa No 49′);
insert into MsCustomer values (‘CT007′,’Ursa’,'Jl Raya Amrik No 99′);
insert into MsCustomer values (‘CT008′,’Warior’,'Jl Raya Ausie No 10′);
insert into MsCustomer values (‘CT009′,’walcotzx’,'Jl Raya Earth No 77′);
insert into MsCustomer values (‘CT010′,’Moonfag’,'Jl Raya africa No 112′);
Erico 1000835650
06PGT
3
—-
CREATE TABLE MsCustomer
(
kodeCustomer VARCHAR2(6) PRIMARY KEY,
namaCustomer VARCHAR2(20),
jenisCustomer VARCHAR2(10)
);
INSERT INTO MsCustomer VALUES(‘C0001′, ‘Erico’, ‘Mahasiswa’);
INSERT INTO MsCustomer VALUES(‘C0002′, ‘Pitong’, ‘Mahasiswa’);
INSERT INTO MsCustomer VALUES(‘C0003′, ‘Andrianto’, ‘Mahasiswa’);
INSERT INTO MsCustomer VALUES(‘C0004′, ‘Peter’, ‘Mahasiswa’);
INSERT INTO MsCustomer VALUES(‘C0005′, ‘Putu’, ‘Mahasiswa’);
INSERT INTO MsCustomer VALUES(‘C0006′, ‘PT. Merkuri’, ‘Perusahaan’);
INSERT INTO MsCustomer VALUES(‘C0007′, ‘PT. Semesta’, ‘Perusahaan’);
INSERT INTO MsCustomer VALUES(‘C0008′, ‘PT. Mars’, ‘Perusahaan’);
INSERT INTO MsCustomer VALUES(‘C0009′, ‘PT. Jupiter’, ‘Perusahaan’);
INSERT INTO MsCustomer VALUES(‘C0010′, ‘PT. Pluto’, ‘Perusahaan’);
NIM : 1000837284
Nama : Ivan
Kelas: 06PGT
create table msCust
(
kdCust char(5) primary key not null,
namaCust varchar(50) not null,
alamatCust varchar(50)
);
insert into msCust values(‘c0001′,’Mr. A’,'Jln. ABC’);
insert into msCust values(‘c0002′,’Mrs. B’,'Jln. DEF’);
insert into msCust values(‘c0003′,’Mrs. C’,'Jln. GHI’);
insert into msCust values(‘c0004′,’Mrs. D’,'Jln. JKL’);
insert into msCust values(‘c0005′,’Mr. E’,'Jln. MNO’);
insert into msCust values(‘c0006′,’Mr. F’,'Jln. PQR’);
insert into msCust values(‘c0007′,’Mr. G’,'Jln. STU’);
insert into msCust values(‘c0008′,’Mrs. H’,'Jln. VWX’);
insert into msCust values(‘c0009′,’Mr. I’,'Jln. YZA’);
insert into msCust values(‘c0010′,’Mrs. J’,'Jln. BCD’);
Denni Efendi
06PGT
1000835751
CREATE TABLE MsCustomer
(
KdCustomer VARCHAR2(10) NOT NULL,
Nama VARCHAR2(100) NOT NULL,
Telp NUMBER,
primary key(KdCustomer)
);
insert into MsCustomer values(‘C1′,’Budi’,’66659874′);
insert into MsCustomer values(‘C2′,’Rudi’,’65498712′);
insert into MsCustomer values(‘C3′,’Susan’,’08170965412′);
insert into MsCustomer values(‘C4′,’Susi’,’08889865352′);
insert into MsCustomer values(‘C5′,’Anto’,’08180236541′);
insert into MsCustomer values(‘C6′,’Dony’,’08886532145′);
insert into MsCustomer values(‘C7′,’Wira’,’0836598740′);
insert into MsCustomer values(‘C8′,’Hans’,’081798765423′);
insert into MsCustomer values(‘C9′,’Fandi’,’0856321654′);
insert into MsCustomer values(‘C10′,’Fredy’,’5449865′);
erfan melanaga (1000873503)
kelas: 06PGT
create table pelanggan
(
idPelanggan varchar2(20) PRIMARY KEY,
nm varchar2(20),
alamat varchar2(20),
telp varchar2(20),
umur numeric,
email varchar2(20) 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
(
KodeCustomer VARCHAR2(5) PRIMARY KEY NOT NULL,
NamaCustomer VARCHAR2(20),
AlamatCustomer VARCHAR2(50),
JenisCustomer VARCHAR2(20)
);
INSERT INTO MsCustomer VALUES(’C0001′,‘Anton’,‘Jl. Mawar’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0002′,‘Budi’,‘Jl. Anggrek’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0003′,‘Cici’,‘Jl. Melati’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0004′,‘Dedi’,‘Jl. Duku’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0005′,‘Eva’,‘Jl. Durian’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0006′,‘Fina’,‘Jl. Salak’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0007′,‘Gita’,‘Jl. Rambutan’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0008′,‘Hadi’,‘Jl. Mangga’,‘Perorangan’);
INSERT INTO MsCustomer VALUES(’C0009′,‘PT. Indah Selalu’,‘Jl. Jeruk’,‘Perusahaaan’);
INSERT INTO MsCustomer VALUES(’C0010′,‘PT. Jadi Makmur’, ‘Jl. Pepaya’,‘Perusahaan’);
100086454/06PGT
–Create Table–
CREATE TABLE MsCustomer(
KdCustomer varchar(5) primary key,
Name varchar(30),
Address varchar(50),
Phone varchar(15)
);
INSERT INTO MsCustomer values (’C0001′, ‘Marimas’, ‘Jl. jambesi’, ‘08183333333′);
INSERT INTO MsCustomer values (’C0002′, ‘Ajaibman’, ‘Jl. Panjang banget’, ‘0817232323′);
INSERT INTO MsCustomer values (’C0003′, ‘Sumarni’, ‘Jl. Manggis’, ‘0123545648′);
INSERT INTO MsCustomer values (’C0004′, ‘Budianduk’, ‘Jl. Untung ada budi’, ‘0879875642′);
INSERT INTO MsCustomer values (’C0005′, ‘Nani’, ‘Jl. 99 ’, ‘0789823295′);
INSERT INTO MsCustomer values (’C0006′, ‘Copo’, ‘Jl. Getdota ‘, ‘08992324567′);
INSERT INTO MsCustomer values (’C0007′, ‘Anabela’, ‘Jl. Maju Pantang′, ‘0878897566′);
INSERT INTO MsCustomer values (’C0008′, ‘Supandi’, ‘Jl. Mundur ah′, ‘0216534535′);
INSERT INTO MsCustomer values (’C0009′, ‘tazmania’, ‘Jl. Kebon utan′, ‘08178943352′);
INSERT INTO MsCustomer values (’C0010′, ‘Tinitoon’, ‘Jl. Sip de’, ‘08178945612′);
Lucyana
1000845866
o6 PGT
CREATE TABLE JenisCust
(
KdJenisCust CHAR(5) PRIMARY KEY,
NamaJenis varchar(20)
);
INSERT INTO JenisCust VALUES (’JC001′,’Home′);
INSERT INTO JenisCust VALUES (’JC002′,’Company′);
CREATE TABLE customer
(
KdCust CHAR(5),
NamaCust VARCHAR(20),
Alamat VARCHAR(100),
Telepon VARCHAR(20),
KdJenisCust CHAR(5),
CONSTRAINT cust_pk PRIMARY KEY(KdCust),
CONSTRAINT jenisid_fk FOREIGN KEY (KdJenisCust) REFERENCES JenisCust(KdJenisCust)
);
INSERT INTO customer VALUES (’CS001’,’Andi’ ,’JL Mawar no 13’,’02186763767’,’JC001’);
INSERT INTO customer VALUES (’CS002’,’Jessi’, ’JL Melati no 3’,’021862324267’,’JC002’);
INSERT INTO customer VALUES (’CS003’,’Ann’ ,’JL Anggrek no 1’,’0213913789767’,’JC001’);
INSERT INTO customer VALUES (’CS004’,’Kate’ ,’JL Jaya no 29’,’02186763234’,’JC002’);
INSERT INTO customer VALUES (’CS005’,’Emy’ ,’JL Salak no 46’,’02173863767’,’JC001’);
INSERT INTO customer VALUES (’CS006’,’Fany’ ,’JL Arjuna no 90’,’02187653767’,’JC002’);
INSERT INTO customer VALUES (’CS007’,’Hanna’ ,’JL Bali no 91’,’02186774567’,’JC001’);
INSERT INTO customer VALUES (’CS008’,’Jack’ ,’JL Kalimati no 3’,’02186763767’,’JC002’);
INSERT INTO customer VALUES (’CS009’,’Dave’ ,’JL Delima no 43’,’021913763767’,’JC001’);
INSERT INTO customer VALUES (’CS010’,’Keith’ ,’JL kenanga no 31’,’02190768967’,’JC002’);
Nama : Yusup Martinus Freddi K
Nim : 1000848073
Kelas : 06 PGT
CREATE TABLE MsCustomer
(
KdCustomer CHAR(30) NOT NULL,
NamaCustomer VARCHAR(50) NOT NULL,
AlamatCustomer VARCHAR(100) NOT NULL,
NoTelpCustomer CHAR(15),
PRIMARY KEY (KdCustomer)
);
INSERT INTO MsCustomer VALUES (‘MC001′,’Christiano’,'Jl. Kemanggisan no 45′,’0219414142′);
INSERT INTO MsCustomer VALUES (‘MC002′,’Ronaldo’,'Jl. Hajisenen no 5′,’0212351234′);
INSERT INTO MsCustomer VALUES (‘MC003′,’Lionel’,'Jl. Palmerah no 6′,’0212398400′);
INSERT INTO MsCustomer VALUES (‘MC004′,’Messi’,'Jl. Sudirman no 65′,’0212315678′);
INSERT INTO MsCustomer VALUES (‘MC005′,’Shieny’,'Jl. Jerukraya no 1′,’0212389123′);
INSERT INTO MsCustomer VALUES (‘MC006′,’Ferdinan’,'Jl. Ayani no 10′,’0213423466′);
INSERT INTO MsCustomer VALUES (‘MC007′,’Ryan’,'Jl. Mulyoharjo no 18′,’0214243562′);
INSERT INTO MsCustomer VALUES (‘MC008′,’Eli’,'Jl. Anggrek no 20′,’0212356722′);
Nama : Yusup Martinus Freddi K
Nim : 1000848073
Kelas : 06 PGT
CREATE TABLE MsCustomer
(
KdCustomer CHAR(30) NOT NULL,
NamaCustomer VARCHAR(50) NOT NULL,
AlamatCustomer VARCHAR(100) NOT NULL,
NoTelpCustomer CHAR(15),
PRIMARY KEY (KdCustomer)
);
INSERT INTO MsCustomer VALUES (’MC001′,’Christiano’,’Jl. Kemanggisan no 45′,’0219414142′);
INSERT INTO MsCustomer VALUES (’MC002′,’Ronaldo’,’Jl. Hajisenen no 5′,’0212351234′);
INSERT INTO MsCustomer VALUES (’MC003′,’Lionel’,’Jl. Palmerah no 6′,’0212398400′);
INSERT INTO MsCustomer VALUES (’MC004′,’Messi’,’Jl. Sudirman no 65′,’0212315678′);
INSERT INTO MsCustomer VALUES (’MC005′,’Shieny’,’Jl. Jerukraya no 1′,’0212389123′);
INSERT INTO MsCustomer VALUES (’MC006′,’Ferdinan’,’Jl. Ayani no 10′,’0213423466′);
INSERT INTO MsCustomer VALUES (’MC007′,’Ryan’,’Jl. Mulyoharjo no 18′,’0214243562′);
INSERT INTO MsCustomer VALUES (’MC008′,’Eli’,’Jl. Anggrek no 20′,’0212356722′);
INSERT INTO MsCustomer VALUES (’MC009′,’Lisa’,’Jl. U no 2′,’0214646532′);
INSERT INTO MsCustomer VALUES (’MC010′,’Yunita’,’Jl. Merkuri no 3′,’0213557554′);
CREATE TABEL MsCustomer{
KodeCustomer CHAR(5) PRIMARY KEY,
NamaCustomer VARCHAR(20) NOT NULL,
AlamatCustomer VARCHAR(20) NOT NULL,
TeleponCustomer VARCHAR(20) NOT NULL
};
INSERT INTO MsCustomer VALUES(‘C001′, ‘Ali’, ‘Jln Pasar No.1′, ’08111111111′);
INSERT INTO MsCustomer VALUES(‘C002′, ‘Babu’, ‘Jln Kebon Jeruk No.2′, ’08122222222′);
INSERT INTO MsCustomer VALUES(‘C003′, ‘Cammie’, ‘Jln Angkeh No.3′, ’08133333333′);
INSERT INTO MsCustomer VALUES(‘C004′, ‘Domo’, ‘Jln Kemanggisan No.4′, ’08566666666′);
INSERT INTO MsCustomer VALUES(‘C005′, ‘Emi’, ‘Jln Raya No.5′, ’08577777777′);
INSERT INTO MsCustomer VALUES(‘C006′, ‘Fanny’, ‘Jln Jeruk No.6′, ’08177777777′);
INSERT INTO MsCustomer VALUES(‘C007′, ‘Gosh’, ‘Jln Angrek No.7′, ’08188888888′);
INSERT INTO MsCustomer VALUES(‘C008′, ‘Harry’, ‘Jln Gereja No.8′, ’08199999999′);
INSERT INTO MsCustomer VALUES(‘C009′, ‘Ian’, ‘Jln Raya No.9′, ’08388888888′);
INSERT INTO MsCustomer VALUES(‘C010′, ‘James’, ‘Jln Kaki No.10′, ’08555555555′);
Heriyanto
1000836262
06PGT
Customer
create table Customer
(
CustomerID char(7) primary key,
CustomerName varchar(3),
CustomerEmail varchar(20),
CustomerSex varchar(10),
);
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’, ‘female’);
insert into Customer values (‘CS010′, ‘Jodi’, ‘j@yahoo.com’, ‘male’);
Nim:1000847101 / 06 PGT
CREATE TABLE Customer
(
KodeCust char(5) primary key,
NamaCust varchar(20)
);
insert into Customer values(’CS001′,’Abc’);
insert into Customer values(’CS002′,’def’);
insert into Customer values(’CS003′,’hij’);
insert into Customer values(’CS004′,’klm’);
insert into Customer values(’CS005′,’nop’);
insert into Customer values(’CS006′,’qrs’);
insert into Customer values(’CS007′,’tuv’);
insert into Customer values(’CS008′,’wxy’);
insert into Customer values(’CS009′,’zab’);
insert into Customer values(’CS010′,’cde’);
ups,
maap pak ada kesalahan, yang diatas pada field CustomerSex saya masih menambahkan tanda (,)
Customer
create table Customer
(
CustomerID char(7) primary key not null,
CustomerName varchar(3) not null,
CustomerEmail varchar(20) not null,
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’, ‘female’);
insert into Customer values (‘CS010′, ‘Jodi’, ‘j@yahoo.com’, ‘male’);
06PGT
1000836306
===========
CREATE TABLE Customer
(
CustomerID int NOT NULL,
LastName varchar(50) NOT NULL,
FirstName varchar(50) NOT NULL,
Address varchar(50) NOT NULL,
City varchar(50) NOT NULL,
Telp varchar(15) NOT NULL,
CustomerTypeID int NOT NULL,
CONSTRAINT customer_pk PRIMARY KEY (CustomerID),
CONSTRAINT fk_customer FOREIGN KEY (CustomerTypeID) REFERENCES CustomerType (CustomerTypeID)
)
CREATE SEQUENCE seq_customer
MINVALUE 001
START WITH 001
INCREMENT BY 1
NOCACHE
INSERT ALL
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval, ’Hermanto’,’Boomz’,’Jl. Palem′,’Jakarta’,’92145678′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval,’Ivan’,’Van’,’Jl.Kebon ′,’Jakarta’,’08561254255′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval,’Rahmania’,’Monica’,’Jl.Kebayoran ′,’Jakarta’,’081854736988′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval,’Ervin’,’Yulianto’,’Jl.Kemanggisan ′,’Jakarta’,’08187452689′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval,’Gustino’,’Moeljono’,’Jl. Theresia’ ,’Jakarta’,’08989184531′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval ,’Beny’,’Wirawan’,’Jl.Cempaka ′,’Jakarta’,’4263184′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval,’Connie’,’Jl.Taman′,’Jakarta’,’5679033′)
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval, ’Dewi’,’Kartika’,’Jl.Menteng ′,’Jakarta’,’08124750264′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval, ’Angela’,’Noviana’,’Jl.Jembatan′,’Jakarta’,’5687921′);
INTO Customer(CustomerID,FirstName,LastName,Address,City, Telp)
VALUES(‘C’+seq_customer.nextval, ’Edwardo’,’Yahya’,’Jl.Kampung′,’Jakarta’,’82503738′)
CREATE TABLE MsCustomer(
KdCustomer CHAR(6) PRIMARY KEY,
NmCustomer VARCHAR (25) NOT NULL,
TelpCustomer VARCHAR (15) NOT NULL,
AlamatCustomer VARCHAR (100) NOT NULL,
EmailCustomer VARCHAR (30)
);
INSERT INTO MsCustomer VALUES (’CST001′, ‘Rina’, ‘021-111111′, ‘Jln.A’, ‘a@gmail.com′);
INSERT INTO MsCustomer VALUES (’CST002′, ‘Rani’, ‘022-222222′, ‘Jln.B’, ‘b@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST003′, ‘Galz’, ’021-333333′, ‘Jln.C’, ‘c@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST004′, ‘Ran’, ’021-444444′, ‘Jln.D’, ‘d@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST005′, ‘Satsuki’, ’022-555555′, ‘Jln.E’, ‘e@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST006′, ‘Toma’, ’021-666666′, ‘Jln.F’, f@gmail.com‘);
INSERT INTO MsCustomer VALUES (’CST007′, ‘Katsu’, ’021-777777′, ‘Jln.G’, ‘g@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST008′, ‘Lin’, ’022-888888′, ‘Jln.H’, ‘h@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST009′, ‘Chen’, ’021-999999′, ‘Jln.I’, ‘i@gmail.com’);
INSERT INTO MsCustomer VALUES (’CST010′, ‘Zheng’, ’022-101010′, ‘Jln.J’, ‘j@gmail.com’);
1000879583 / 06 PGT
CREATE TABLE MsCustomer(
KdCustomer VARCHAR2(5) NOT NULL PRIMARY KEY,
NamaCustomer VARCHAR2 (20),
AlamatCustomer VARCHAR2 (100),
TelpCustomer VARCHAR (15)
);
INSERT INTO MsCustomer VALUES (’C001′, ‘Christina’, ‘Jl.Palmerah no.1’, ‘147258′);
INSERT INTO MsCustomer VALUES (’C002′, ‘Daniel’, ‘Jl.Palmerah no.2’, ‘472583′);
INSERT INTO MsCustomer VALUES (’C003′, ‘Matthew’, ‘Jl.Palmerah no.3’, ‘725836′);
INSERT INTO MsCustomer VALUES (’C004′, ‘Sammuel’, ‘Jl.Palmerah no.4’, ‘258369′);
INSERT INTO MsCustomer VALUES (’C005′, ‘Elia’, ‘Jl.Palmerah no.5’, ‘583691′);
INSERT INTO MsCustomer VALUES (’C006′, ‘Joshua’, ‘Jl.Palmerah no.6’, ‘369147′);
INSERT INTO MsCustomer VALUES (’C007′, ‘Esther’, ‘Jl.Palmerah no.7’, ‘691472′);
INSERT INTO MsCustomer VALUES (’C008′, ‘Michael’, ‘Jl.Palmerah no.8’, ‘914725′);
INSERT INTO MsCustomer VALUES (’C009′, ‘Timmotius’, ‘Jl.Palmerah no.9’, ‘789456′);
INSERT INTO MsCustomer VALUES (’C010′, ‘Yoan’, ‘Jl.Palmerah no.10’, ‘456123′);