Tugas PBD Praktikum Pertemuan ke 4

Nama : Hanif fayad zabihullah

kelas : IF19D

Npm; 19312122 

                                 Query Database Praktikum Minggu ke2 pertemuan ke 4  Select

create database PBD_HanifFz

create table pelanggan(

KodePelanggan char(5) primary key,

NamaPleanggan varchar(25) not null,

AlamatPelanggan varchar(50) not null

)

insert into pelanggan (KodePelanggan, NamaPleanggan, AlamatPelanggan)

values

('P0090','Dhani','Bandar Lampung'),

('P0091','Ahmad','Lampung selatan'),

('P0092','Ali','Lampung timur')

SELECT * FROM pelanggan

update pelanggan

SET NamaPleanggan = 'Doni'

where KodePelanggan = 'P0090'

update pelanggan

SET NamaPleanggan = 'adi', AlamatPelanggan =' Bandar lampung'

where KodePelanggan = 'P0092'

delete from pelanggan where KodePelanggan='P0091'

insert into pelanggan values

('P0001','Aditya','Bandar lampung'),

('P0002','nandi','lampung barat'),

('P0003','indrajat','lampung selatan'),

('P0004','ali','bandar lampung'),

('P0005','agung','lampung selatan'),

('P0006','dedi','lampung selatan'),

('P0007','rhendy','lampung selatan'),

('P0008','lulus','lampung timur'),

('P0009','alipi','bandar lampung'),

('P0010','indra','bandar lampung'),

('P0011','wigo','bandar lampung'),

('P0012','andika','bandar lampung'),

('P0013','alfian','bandar lampung'),

('P0014','fahmi','lampung barat'),

('P0015','afrand','bandar lampung'),

('P0016','ebi','bandar lampung'),

('P0017','agung','bandar lampung'),

('P0018','indra','bandar lampung'),

('P0019','Yuda','bandar lampung'),

('P0020','arsy','lampung timur'),

('P0021','nurman','lampung selatan'),

('P0022','yogi','bandar lampung'),

('P0023','apriyani','bandar lampung'),

('P0024','latiful','bandar lampung'),

('P0025','bima','lampung barat'),

('P0026','bagas','bandar lampung '),

('P0027','aska','bandar lampung '),

('P0028','alfian','bandar lampung '),

('P0029','kevin','bandar lampung '),

('P0030','jala','lampung timur '),

('P0031','apry','lampung timur'),

('P0032','grenci','bandar lampung '),

('P0033','niko','bandar lampung '),

('P0034','rindu','lampung barat');

create table barang(

KodeBarang char(5) primary key,

NamaBarang varchar(25) not null,

HargaBarang int not null,

StokBarang int not null,

Satuan varchar(15) not null

)

create table kwitansi(

NomorKwitansi char(5) primary key,

TanggalKwitansi date not null,

KodePelanggan char(5) not null,

foreign key (KodePelanggan) references pelanggan(KodePelanggan));

create table detail_kwitansi (

NomorKwitansi char(5) not null foreign key references kwitansi(NomorKwitansi),

KodeBarang char(5) not null foreign key references barang(KodeBarang),jumlahjjual int not null)

BULK INSERT barang

From 'D:\Appl\data_barang.csv'

with

(

FIRSTROW =2,

FIELDTERMINATOR=',',

ROWTERMINATOR ='\n'

)

GO

select * from pelanggan

select NamaPleanggan, AlamatPelanggan from pelanggan;

select AlamatPelanggan from pelanggan;

select * from pelanggan where AlamatPelanggan='bandar lampung';

select * from pelanggan where NamaPleanggan like 'a%';

select * from pelanggan where NamaPleanggan like '%i' 

and AlamatPelanggan = 'bandar lampung';