Praktikum SBD 7c

Soal

Case

1.      Tampilkan EmployeeID, EmployeeName dimana Transaksi pada hari Kamis atau pada hari Jumat dan selisih  antara TransactionDate  dan ’15 January 2010’ kurang dari 8 hari.

(join, datename, weekday, datediff, day)

2.      Tampilkan MenuID, MenuName dan MenuType dimana MenuType merupakan ‘Food’ dan panjang MenuName merupakan angka ganjil.

(join, len)

3.      Tampilkan CustomerID, CustomerName, EmployeeName dimana email dari customer mengandung kata ‘yahoo’ dan selisih panjang EmployeeName dengan CustomerName kurang dari 3.      

(join, len, like)

4.      Tampilkan EmployeeID dan WorkDays (didapat dari jumlah Qty pangkat 3) dimana WorkDays lebih dari 30 digabung dengan CustomerID dan WorkDays (didapat dari jumlah hasil pembulatan akar pangkat dua dari Qty) dimana digit terakhir CustomerID di modulus 5 sama dengan 0.

(join, sum, power, union, group by, having, round, sqrt, right)

5.      Tampilkan CustomerID, CustomerName, TotalVisiting (didapat dari 2 digit terakhir TransactionID + bulan dari TransactionDate + 2 digit terakhir dari CustomerID + digit terakhir dari EmployeeID) dimana TotalVisiting dibagi dengan panjang CustomerName kurang dari 10 dan huruf ke-2 dari CustomerName berkisar antara ‘k’ hingga ‘p’.

(join, right, month, substring, like, len)

6.      Tampilkan MenuTypeID, MenuType, Price dimana MenuType merupakan ‘Beverage’ atau ‘Dessert’ dan Price di antara 5000 dan 12000 dan TransactionDate terjadi di antara tanggal 2 dan tanggal 6.

(join, like, between, day)

7.      Tampilkan TransactionID, MenuID, CustomerName dimana bulan TransactionDate terjadi pada bulan January, hasil dari 2 digit terakhir TransactionID dipangkatkan digit terakhir MenuID lebih dari 50 dan MenuName terdiri dari 3 kata atau lebih.

(join, datename, month, power, right, like)

8.      Tampilkan TransactionID, CustomerName, EmployeeName, TransactionDate dan Makanan Terjual (didapat dari banyaknya menu yang terjual) dimana CustomerName mengandung huruf ‘a’, EmployeeName mengandung huruf ‘o’ urutkan berdasarkan CustomerName. Tampilkan pula  jumlah dari Makanan Terjual.

(join, count, like, group by, order by, compute, sum)

9.      Berikan hak akses kepada salah satu teman anda untuk melakukan insert, update, delete pada tabel MsEmployee.

(grant)

10.  Cabutlah hak akses delete yang telah diberikan kepada teman anda pada tabel MsEmployee.

(revoke)

Jawab

--SOAL NO 1

select
    me.EmployeeID, EmployeeName
from
    MsEmployee me join TrHeaderTransaction th on me.EmployeeID = th.EmployeeID
    and (datename(weekday,TransactionDate) = 'Friday' or datename(weekday,TransactionDate) = 'Thursday')
    and datediff(day,TransactionDate,'2010-01-15') < 8

--SOAL NO 2

SELECT
    MenuID, MenuName, MenuType
FROM
    MsMenu mm join MsMenuType mt on mm.MenuTypeID = mt.menuTypeID
    and MenuType = 'Food'
    and len(MenuName) % 2 = 1

--SOAL NO 3

select
    mc.CustomerID, CustomerName, EmployeeName
FROM
    MsCustomer mc join TrHeaderTransaction th on mc.CustomerID = th.customerID
    join MsEmployee me on th.EmployeeID = me.EmployeeID
    and email like '%yahoo%'
    and len(EmployeeName) - len(CustomerName)  < 3

--SOAL NO 4

select
    me.EmployeeID, WorkDays = sum(power(Qty,3))
FROM
    MsEmployee me join TrHeaderTransaction th on me.EmployeeID = th.EmployeeID
    join TrDetailTransaction td on th.TransactionID = td.TransactionID
Group by
    me.EmployeeID
having
    sum(power(Qty,3)) > 30
UNION
select
    mc.CustomerID, WorkDays = sum(round(sqrt(Qty),0))
FROM
    MsCustomer mc join TrHeaderTransaction th on mc.CustomerID = th.CustomerID
    join TrDetailTransaction td on th.TransactionID = td.TransactionID
    and right(mc.CustomerID,1) % 5 = 0
group by
    mc.CustomerID

--SOAL NO 5

select
    mc.CustomerID, customerName,
    TotalVisiting = right(transactionID,2) + month(transactionDate) + right(mc.CustomerID,2) + right(me.employeeID,1)
from
    MsCustomer mc join TrHeaderTransaction th on mc.CustomerID = th.CustomerID
    join MsEmployee me on th.EmployeeID = me.employeeID
    and right(transactionID,2) + month(transactionDate) + right(mc.CustomerID,2) + right(me.employeeID,1) / len(CustomerName) < 10
    and substring(CustomerName,2,1) like '[k-p]'


--SOAL NO 6

select
    mt.MenuTypeID, MenuType, Price
from
    MsMenuType mt join MsMenu mm on mt.menuTypeID = mm.menuTypeID
    join TrDetailTransaction td on mm.MenuID = td.menuID
    join TrHeaderTransaction th on th.TransactionID = td.TransactionID
    and (MenuType like 'Dessert' or MenuType like 'Beverage')
    and price between 5000 and 12000
    and day(TransactionDate) between 2 and 6

--SOAL NO 7

select
    th.TransactionID, mm.MenuID, CustomerName
from
    MsCustomer mc join TrHeaderTransaction th on mc.CustomerID = th.CustomerID
    join TrDetailTransaction td on th.TransactionID = td.TransactionID
    join MsMenu mm on td.MenuID = mm.menuID
    and datename(month,TransactionDate) = 'January'
    and power(right(th.transactionID,2),right(mm.menuID,1)) > 50
    and MenuName like '% % %'

--SOAL NO 8

select
    th.TransactionID, CustomerName, EmployeeName, TransactionDate, [Makanan Terjual] = count(mm.menuID)
from
    MsCustomer mc join TrHeaderTransaction th on mc.CustomerID = th.CustomerID
    join MsEmployee me on th.EmployeeID = me.EmployeeID
    join TrDetailTransaction td on th.TransactionID = td.TransactionID
    join MsMenu mm on td.MenuID = mm.menuID
    and CustomerName like '%a%'
    and EmployeeName like '%o%'
group by
    th.TransactionID,
    CustomerName,
    EmployeeName,
    TransactionDate
order by
    customerName
compute sum(count(mm.menuID))

--SOAL NO 9

--JAWAB
grant insert, update, delete on MsEmployee to xxx

--SOAL NO 10

revoke delete on MsEmployee from xxx

Praktikum SBD 7b

/*****************************************************************
    soal 7
******************************************************************/
--1 tampilkan namakaryawan, tanggal sewa
select EmployeeName,convert(varchar(20),RentTime,103) as 'RentTime' from MsEmployee mk join RentalHeader th on mk.EmployeeCode = th.EmployeeCode
where day(RentTime)>20

--2  tampilkan namapelanggan,LicensePlate,RentTime dengan format dddd, dd MMM yyyy dimana RentTime dilakukan pada hari sabtu dan digit dari LicensePlate habis dibagi 5
select CustomerName,LicensePlate,datename(weekday,RentTime)+', '+convert(varchar(20),RentTime,6) as [Date] from MsCustomer mp join RentalHeader th on mp.CustomerCode=th.CustomerCode join RentalDetail td on td.TransactionCode=th.TransactionCode
where datename(weekday,RentTime)='Saturday'
and substring(LicensePlate,5,1)%5=0

--3 tampilkan TransactionCode,LicensePlate,durasi peminjaman mobil dalam satuan jam yang di dapat dari pengurangan RentTime dan ReturnTime
select th.TransactionCode,LicensePlate,cast(ceiling(cast(datediff(minute,RentTime,ReturnTime) as numeric)/60) as varchar(20))+' hour' as [Duration] from RentalHeader th join RentalDetail td on th.TransactionCode=td.TransactionCode

--4 tampilkan biaya peminjaman dan peminjam yang meminjam mobil tersebut dimana namapelanggan hanya terdiri dari 2 kata dan tampilkan total dari biaya transaksi tiap orang
select CustomerName,mm.LicensePlate,ceiling(cast(datediff(minute,RentTime,ReturnTime) as numeric)/60)*PricePerHour as [Fee]
from MsCustomer mp
join RentalHeader th on th.CustomerCode=mp.CustomerCode
join RentalDetail td on th.TransactionCode=td.TransactionCode
join MsCar mm on mm.LicensePlate=td.LicensePlate
join CarDetail mCarName on mCarName.CarCode=mm.CarCode
where CustomerName like '% %' and CustomerName not like '% % %'
order by CustomerName asc
compute sum(ceiling(cast(datediff(minute,RentTime,ReturnTime) as numeric)/60)*PricePerHour)
by CustomerName

--5 tampilkan TransactionCode, namapelanggan,namakaryawan di tambahkan kata 'Mr./Mrs. ' di depannya, tgl sewa dengan format tgl dd mmm yyyy dan total biaya dari transaksi tersebut
select th.TransactionCode,'Mr./Mrs. '+EmployeeName as [Employee's Name],'Mr./Mrs. '+CustomerName  as [Customer's Name],convert(varchar(20),RentTime,106) as [RentDate],
'Rp. '+cast(sum(ceiling(cast(datediff(minute,RentTime,ReturnTime) as numeric)/60)*PricePerHour)as varchar(20))+'.00' as [Total Fee]
from MsCustomer mp
join RentalHeader th on th.CustomerCode=mp.CustomerCode
join MsEmployee mk on mk.EmployeeCode=th.EmployeeCode
join RentalDetail td on th.TransactionCode=td.TransactionCode
join MsCar mm on mm.LicensePlate=td.LicensePlate
join CarDetail mCarName on mCarName.CarCode=mm.CarCode
group by th.TransactionCode,EmployeeName,CustomerName,RentTime
having sum(ceiling(cast(datediff(minute,RentTime,ReturnTime) as numeric)/60)*PricePerHour) between 1000000 and 1500000

--6
/*tampilkan nomor dari kodetransaksi,nama pertama pelanggan, kata kedua dari alamat, nomor telpon dgn format xxxx - xxxxxxxx
dimana pelanggan tersebut melakukan transaksi di antara tanggal 20-25
dan pelanggan tsb meminjam mobil lebih dari 2
dan nama pelanggan terdiri lebih dari 2 kata*/
select distinct cast(substring(td.TransactionCode,charindex('R',td.TransactionCode)+1,len(td.TransactionCode))as int)as[TransactionNumber],substring(CustomerName,1,charindex(' ',CustomerName)) as[FirstName],
substring(CustomerAddress,charindex(' ',CustomerAddress)+1,charindex(' ',substring(CustomerAddress,charindex(' ',CustomerAddress)+1,len(CustomerAddress)))-1) as [Address Name],
substring(CustomerPhone,1,4)+' - '+substring(CustomerPhone,5,len(CustomerPhone)) as [Phone Number]
from MsCustomer mp
join RentalHeader th on th.CustomerCode=mp.CustomerCode
join MsEmployee mk on mk.EmployeeCode=th.EmployeeCode
join RentalDetail td on th.TransactionCode=td.TransactionCode
where day(RentTime) between 20 and 25
and CustomerName like '% %'
group by CustomerName,CustomerAddress,CustomerPhone,td.TransactionCode
having count(td.LicensePlate)>2

--7  tampilkan nama pelanngan dimana huruf pertama pelanggan berada dia antara A-O, alamat pelanggan dari tabel MsCustomer dan gabungkan dengan nama karyawan,alamat karyawan, dimana karakter pertama alamat dari kata kedua berada di antara A-J
select CustomerName as [Name],CustomerAddress[Address] from MsCustomer
where CustomerName like '[A-O]%'
union all
select EmployeeName,EmployeeAddress from MsEmployee
where EmployeeAddress like '% [A-J]%'

--8 tampilkan CustomerCode , dan tanggal yang di dapat dari pengurangan tanggal hari ini dengan 10 dari tabel MsCustomer dan gabungkan dengan TransactionCode,tgl pengembalian dari tabel RentalDetail dimana nomor dari kodetransaksi adalah bilangan genap
select CustomerCode as [Code], convert(varchar(20),cast(datediff(day,right(CustomerCode,1)*10,getdate()) as datetime),106) as [Date] from MsCustomer
union all
select TransactionCode as [Code], convert(varchar(20),ReturnTime,106) as [Date] from RentalDetail
where right(TransactionCode,1)%2=0


--9 Berilah hak untuk insert, select, dan update tabel MsEmployee kesalah satu teman anda.
grant insert,select,update on MsEmployee to xxx

--10 Cabutlah hak akses yang sudah anda berikan kepada teman anda pada nomor sembilan tadi.
revoke insert,select,update on MsEmployee to xxx

Praktikum SBD 7a

 Soal

1.         Tampilkan CashierID, CashierName, CustomerName, dan CustomerAddress dimana CashierName diakhiri dengan huruf 'o' dan panjang CustomerAddress merupakan angka genap.

(join, like, len)

         

2.         Tampilkan CustomerID, CustomerName, dan CashierName dimana tanggal transaksi penjualan terjadi pada tanggal 1 dan selisih antara tanggal 1 Februari 2010 dan tanggal transaksi kurang dari 1 bulan.

(join, month, datediff, day)

       

3.         Tampilkan CashierID, CashierName, dan Bonus (didapat dari ‘Rp.’+ jumlah transaksi * 100000) dimana ProductCategory merupakan 'Motherboard' dan TransactionID diakhiri dengan angka 5.

(cast,count,join,group by, right)

       

4.         Tampilkan CashierId, CashierName, CashierChildren (didapat dari digit terakhir CashierID) IncomeTaxPercentage (didapat dari hasil pembulatan antara total Qty dikali 0.1) dimana DomainEmail Customer adalah 'qita.net' digabungkan dengan CashierId, CashierName, CashierChildren dan IncomeTaxPercentage dimana CashierTaxPercentage di antara 0 hingga 10.

(union, sum, round, substring, charindex, len, in, group by, having, join, right,between)

5.         Tampilkan ProductID, ProductName, CustomerName, dan CostumerAge (didapat dari digit terakhir ProductCategoryID + digit terakhir ProductID + digit terakhir CashierID * panjang CustomerName) dimana CustomerAge * 60 lebih besar dari tahun TransactionDate dan huruf ke-3 dari CustomerName berkisar antara 'r-t'.

(join, right, substring, like, len, year, cast)

       

6.         Tampilkan ProductID, ProductName, ProductPrice dimana CustomerName diakhiri huruf 'm' dan transaksi berlangsung antara bulan Januari sampai Maret 2010.

(join,in,month,like,between)

7.         Tampilkan ProductID, ProductName, CustomerName dimana transaksi terjadi pada bulan Mei dan dilayani oleh kasir yang memiliki nama mengandung huruf ‘a’

(join, datename,like, month, in)

8.         Tampilkan CashierID, CashierName, TanggalTransaksi, Average Sold Product (didapat dari rata-rata Qty) dimana NamaProductCategory adalah 'Motherboard' dan tanggal terjadinya transaksi berlangsung pada tanggal 3 dan diurutkan berdasarkan CashierName.

Tampilkan pula total dari Rata Rata Jual

(join, avg, like , group by, day, compute, sum, order by)

9.         Berikan hak akses kepada salah satu teman anda untuk melakukan insert, update, delete pada tabel MsProduct.

(grant)

10.     Cabutlah hak akses delete yang telah diberikan kepada teman anda pada tabel MsProduct.

        (revoke)

Jawab :

--1
select mcas.CashierID, CashierName, CustomerName,CustomerAddress
from MsCashier mcas
join TrHeaderSell ths on mcas.CashierID = ths.CashierID
join MsCustomer mcus on ths.CustomerID = mcus.CustomerID
where CashierName like '%o'
and len(CustomerAddress)%2 = 0

--2
select mcus.CustomerID, CustomerName, CashierName
from MsCustomer mcus
join TrHeaderSell ths on mcus.CustomerID = ths.CustomerID
join MsCashier mcas on ths.CashierID = mcas.CashierID
where day(TransactionDate) = 1 and
datediff(month,'2/1/2010',TransactionDate) < 1

--3
select mcas.CashierID,CashierName, 'Rp. ' + cast(count(ths.TransactionID)*100000 as varchar) as 'Bonus'
from MsCashier mcas
join TrHeaderSell ths on ths.CashierID = mcas.CashierID
join TrDetailSell tds on tds.TransactionID = ths.TransactionID
join MsProduct mpro on mpro.ProductID = tds.ProductID
join MsProductCategory mpc on mpc.ProductCategoryID = mpro.ProductCategoryID
where ProductCategory = 'MotherBoard' and right(ths.transactionID,1)=5
group by mcas.CashierID,CashierName

--4
select mcas.CashierID, CashierName, right(mcas.CashierID,1) as CashierChildren,
round(sum(qty*0.1),0) as IncomeTaxPercentage from MsCashier mcas
join TrHeaderSell ths on mcas.CashierId = ths.CashierId
join TrDetailSell tds on tds.TransactionID = ths.TransactionID
where
    customerId in
    (
        select customerID from MsCustomer cus
        where substring(CustomerEmail,charIndex('@',CustomerEmail)+1,len(customeremail)) = 'qita.net'
    )
group by mcas.CashierID, CashierName, right(mcas.CashierID,1)

union

select mcas.CashierId, CashierName, right(mcas.CashierID,1)  as CashierChildren,
round(sum(qty*0.1),0) as CashierTaxPercentage
from MsCashier mcas
join TrHeaderSell ths on ths.CashierID = mcas.CashierID
join TrDetailSell tds on tds.TransactionID = ths.TransactionID

group by mcas.CashierId, CashierName, right(mcas.CashierID,1)
having sum(round(qty*0.1,0))  between 0 and 10

--5
select mpro.ProductID, ProductName, CustomerName, cast(right(mpro.ProductCategoryID,1) + right(mpro.ProductID,1)
+ right(ths.CashierID,1) * len(CustomerName) as varchar) +' years' as 'CustomerAge'
from MsCustomer mcus
join TrHeaderSell ths on mcus.CustomerID = ths.CustomerID
join TrDetailSell tds on ths.TransactionID = tds.TransactionID
join MsProduct mpro on tds.ProductID = mpro.ProductID
join MsProductCategory mpc on mpro.ProductCategoryID = mpc.ProductCategoryID
where right(mpro.ProductCategoryID,1) + right(mpro.ProductID,1) + right(ths.CashierID,1) * len(CustomerName) * 60 < year(TransactionDate)
and substring(CustomerName,3,1) like '[r-t]'

--6
select msp.ProductID, ProductName, ProductPrice from MsProduct msp
join TrDetailSell tdp on msp.ProductID = tdp.ProductID
where TransactionID in
(
    select TransactionID from TrHeaderSell thp
    where thp.TransactionID = tdp.TransactionID
    and month(TransactionDate) between 1 and 3
    and CustomerID in
    (
        select CustomerID from MsCustomer msk
        where msk.CustomerID = thp.CustomerID
        and CustomerName like '%m'
    )
)

--7
select msp.ProductID, ProductName, CustomerName
from MsProduct msp
join TrDetailSell tdp on msp.ProductID = tdp.ProductID
join TrHeaderSell thp on tdp.TransactionID = thp.TransactionID
join MsCustomer msk on thp.CustomerID = msk.CustomerID
where datename(month,TransactionDate) = 'May'
and CashierID in
(
    select CashierID from MsCashier Ms
    where Ms.CashierID = Thp.CashierID and    CashierName like '%a%'
)
--8
select msk.CashierID, CashierName, TransactionDate, avg(Qty) as [Average of Sold Product] from
MsCashier msk
join TrHeaderSell thp on msk.CashierID = thp.CashierID
join TrDetailSell tdp on thp.TransactionID = tdp.TransactionID
join MsProduct msp on tdp.ProductID = msp.ProductID
join MsProductCategory mjp on msp.ProductCategoryID = mjp.ProductCategoryID
where ProductCategory like 'Motherboard'
and day(TransactionDate) = 3
group by msk.CashierID, CashierName, TransactionDate
order by CashierName
compute sum(avg(Qty))

--9
grant insert,update,delete
on Product
to xxxxxx (disesuaikan)

--10
revoke delete
on Product
from xxxxxxx (disesuaikan)
 

 

--untuk membuat tabel
create table MsCashier
(
    CashierID char(6) primary key not null,
    CashierName varchar(45),
    CashierPhone varchar(14),
    CashierAddress varchar(50),
    constraint cons1 check( len(CashierID) = 6 ),
    constraint cons2 check( CashierID like 'KK[0-9][0-9][0-9][0-9]' ),   
)

create table MsCustomer
(
    CustomerID char(6) primary key not null,
    CustomerName varchar(50),
    CustomerAddress varchar(50),
    CustomerPhone varchar(14),
    CustomerEmail varchar(35),
    constraint cons3 check ( len(CustomerID) = 6 ),
    constraint cons4 check ( CustomerID like 'KKN[0-9][0-9][0-9]' ),   
)

create table MsProductCategory
(
    ProductCategoryID char(6) primary key not null,
    ProductCategory varchar(45),
    constraint cons7 check ( len(ProductCategoryID) = 6 ),
    constraint cons8 check ( ProductCategoryID like 'JPR[0-9][0-9][0-9]' ),   
)

create table MsProduct
(
    ProductID char(6) primary key not null,
    ProductName varchar(40),
    ProductPrice numeric,
    ProductCategoryID char(6),
    constraint cons5 check ( len(ProductID) = 6 ),
    constraint cons6 check ( ProductID like 'PRO[0-9][0-9][0-9]' ),
    Foreign key(ProductCategoryID) references MsProductCategory on update cascade on delete cascade
)

create table TrHeaderSell
(
    TransactionID char(6) primary key not null,
    TransactionDate datetime not null,
    CustomerID char(6) not null,
    CashierID char(6) not null,   
    constraint cons9 check ( len(TransactionID) = 6 ),
    constraint cons10 check ( TransactionID like 'TR[0-9][0-9][0-9][0-9]'),  
    Foreign key(CustomerID) references MsCustomer on update cascade on delete cascade,
    Foreign key(CashierID) references MsCashier on update cascade on delete cascade
)


create table TrDetailSell
(   
    TransactionID char(6) not null,
    ProductID char(6) not null,
    Qty numeric,
    primary key (TransactionID, ProductID),
    Foreign key(TransactionID) references TrHeaderSell on update cascade on delete cascade,
    Foreign key(ProductID) references MsProduct on update cascade on delete cascade
)


--menghapus tabel
--master
drop table MsCashier
drop table MsCustomer
drop table MsProduct
drop table MsProductCategory

--transaction
drop table TrHeaderSell
drop table TrDetailSell


--menampilkan semua tabel
sp_tables

--menampilkan isi table

select *  from MsCashier
select *  from MsCustomer
select *  from MsProduct
select *  from MsProductCategory
select *  from TrHeaderSell
select *  from TrDetailSell



--MsCashier

insert into MsCashier values('KK0001','Niko Setiono','021-56057557','Jl. Tmn Teratai 3 E6/11, Tangerang')
insert into MsCashier values('KK0002','Christine','021-56776699','Jl. H Ungar Lr. Mursala No. 69, Tanjungpinang')
insert into MsCashier values('KK0003','Albertus Agung','021-56928153','THB A1 No.2')
insert into MsCashier values('KK0004','Monika Leslivania','021-56537784','Jl. Jend Sudirman No. 96, Medan')
insert into MsCashier values('KK0005','Novi Trisjaniar','021-56606693','Jl. A.Yani No. 12, Sanggau')
insert into MsCashier values('KK0006','Devina Purwito','021-56551736','Jl. Ade Irma Suryani No. 8, Pontianak')

--MsCustomer
insert into MsCustomer values('KKN001','Fransisca Theresia','Apart. Gading Mediterania CC / 31A / P','08159145050','invisible_kid@hotmail.com')
insert into MsCustomer values('KKN002','Fendy Willyam','Jl. Kebon Jeruk Raya no. 9 Kemanggisan Jakbar','081808215249','ee_uze@yahoo.com')
insert into MsCustomer values('KKN003','Garry Bernardy','Jl. Studio No.41 Kemanggisan ','08126586154','lius_hunt@hotmail.com')
insert into MsCustomer values('KKN004','Hardi Chandra','Lembang Baru II A / 3 Ciledug - Tangerang','08128268897','med_inez@yahoo.com')
insert into MsCustomer values('KKN005','Hendra Kurniawan','Tmn. Aries E 20 / 35 Jakbar','081316210220','nmbee_09@yahoo.com')
insert into MsCustomer values('KKN006','Heru Prasetia','Kebon Jeruk Raya no.9','08170692570','arcadia_boyz@yahoo.com')
insert into MsCustomer values('KKN007','Mariana','Jl. Keluarga no.30 B','08567745789','mr.henry@programmer.net')
insert into MsCustomer values('KKN008','Henry Chong','Gg. Harun 2 Kemanggisan Pulo','08568742515','leonheart@qita.net')
insert into MsCustomer values('KKN009','Fredy','Jl. Pluit Karang Elok J5 no 3 muara Karang Jakut ','08561772223','fredy_fe@yahoo.com')

--MsProductCategory

insert into MsProductCategory values('JPR001','Motherboard')
insert into MsProductCategory values('JPR002','Harddisk External')
insert into MsProductCategory values('JPR003','Monitor')


--MsProduct

insert into MsProduct values('PRO001','INTEL CORE 2 DUO 2.33 GHz (E6550) Tray',1593330,'JPR001')
insert into MsProduct values('PRO002','INTEL QUADCORE 2.4 GHz(Q6600) BOX',2560380,'JPR001')
insert into MsProduct values('PRO003','INTEL QUADCORE 2.66 GHz(Q6700) BOX',5111550,'JPR001')
insert into MsProduct values('PRO004','250 GB SEAGATE IDE RESMI',746010,'JPR002')
insert into MsProduct values('PRO005','320 GB SEAGATE SATA RESMI',939420,'JPR002')
insert into MsProduct values('PRO006','500 GB SEAGATE SATA RESMI',1630170,'JPR002')
insert into MsProduct values('PRO007','MONITOR SAMSUNG 15" 591S',773640,'JPR003')
insert into MsProduct values('PRO008','MONITOR SAMSUNG 17" 793 BLACK',828900,'JPR003')
insert into MsProduct values('PRO009','MONITOR SAMSUNG 17" FLAT 793MG',1031520,'JPR003')


--TrHeaderSell

insert into TrHeaderSell values('TR0001','2/1/2010','KKN004','KK0004')
insert into TrHeaderSell values('TR0002','2/1/2010','KKN001','KK0004')
insert into TrHeaderSell values('TR0003','2/3/2010','KKN003','KK0001')
insert into TrHeaderSell values('TR0004','2/3/2010','KKN002','KK0001')
insert into TrHeaderSell values('TR0005','2/3/2010','KKN006','KK0003')
insert into TrHeaderSell values('TR0006','2/3/2010','KKN002','KK0005')
insert into TrHeaderSell values('TR0007','2/3/2010','KKN009','KK0002')
insert into TrHeaderSell values('TR0008','2/3/2010','KKN003','KK0003')
insert into TrHeaderSell values('TR0009','2/20/2010','KKN005','KK0001')
insert into TrHeaderSell values('TR0010','2/20/2010','KKN002','KK0001')
insert into TrHeaderSell values('TR0011','2/20/2010','KKN003','KK0004')
insert into TrHeaderSell values('TR0012','2/20/2010','KKN007','KK0001')
insert into TrHeaderSell values('TR0013','2/20/2010','KKN004','KK0003')
insert into TrHeaderSell values('TR0014','2/20/2010','KKN002','KK0006')
insert into TrHeaderSell values('TR0015','2/20/2010','KKN001','KK0004')
insert into TrHeaderSell values('TR0016','2/23/2010','KKN008','KK0004')
insert into TrHeaderSell values('TR0017','5/1/2010','KKN008','KK0004')
insert into TrHeaderSell values('TR0018','5/1/2010','KKN002','KK0005')
insert into TrHeaderSell values('TR0019','5/1/2010','KKN003','KK0003')
insert into TrHeaderSell values('TR0020','5/1/2010','KKN001','KK0001')

--TrDetailSell

insert into TrDetailSell values('TR0001','PRO008',79)
insert into TrDetailSell values('TR0002','PRO008',84)
insert into TrDetailSell values('TR0003','PRO006',13)
insert into TrDetailSell values('TR0004','PRO009',96)
insert into TrDetailSell values('TR0005','PRO002',94)
insert into TrDetailSell values('TR0006','PRO003',32)
insert into TrDetailSell values('TR0007','PRO002',1)
insert into TrDetailSell values('TR0008','PRO002',7)
insert into TrDetailSell values('TR0009','PRO007',76)
insert into TrDetailSell values('TR0010','PRO002',30)
insert into TrDetailSell values('TR0011','PRO006',87)
insert into TrDetailSell values('TR0012','PRO008',43)
insert into TrDetailSell values('TR0013','PRO008',47)
insert into TrDetailSell values('TR0014','PRO008',3)
insert into TrDetailSell values('TR0015','PRO003',85)
insert into TrDetailSell values('TR0016','PRO001',15)
insert into TrDetailSell values('TR0017','PRO006',95)
insert into TrDetailSell values('TR0018','PRO006',3)
insert into TrDetailSell values('TR0019','PRO009',77)
insert into TrDetailSell values('TR0020','PRO006',24)


delete  from MsCashier
delete  from MsCustomer
delete  from MsProduct
delete  from MsProductCategory
delete  from TrHeaderSell
delete  from TrDetailSell

select *  from MsCashier
select *  from MsCustomer
select *  from MsProduct
select *  from MsProductCategory
select *  from TrHeaderSell
select *  from TrDetailSell

Cara Unblock Youtube

1. download ultrasurf di http://ultrasurf.us/
2. buka softwre tersebut
3.buka mozila lalu buka bagian atas Tools>Options...>Advanced>Network Tab>Settings
4. Select Manual Proxy Configuration 
    HTTP Proxy: 127.0.0.1 Port: 9666 (Default Proxy)
   Tekan OK.

Selesai ^^. Semoga bermanfaat.

How to Recover Formatted Pics From an XD Card

Instructions

1. • 1

     Stop using the card as soon as you realize you have deleted the images. While you cannot see the pictures on the card, they are still there. Memory cards retain the images until they are replaced with a new picture.

   • 2

     Download a free trial or freeware program like "Recover My Files" or "Disc Doctors" or "Card Recovery" to your computer. Open the program after it has been downloaded.

   • 3

     Insert the XD card into your computer's XD card reader or use an external memory card reader if your computer doesn't have a built-in reader. You can also connect your digital camera using a USB cable to achieve the same results. Wait for a moment for your computer to recognize that you have attached a card to it.

   • 4

     Click "Scan Files" in the recovery program and allow the program to scan your card. Once the scan is completed, a new window will appear containing the images that were formatted.

   • 5

     Select the images you want to save and save them to a new folder on your computer.

source : How to Recover Formatted Pics From an XD Card | eHow.com http://www.ehow.com/how_7429367_recover-formatted-pics-xd-card.html#ixzz1roNaylK6

How to Initialize a Fuji SD Memory Card

Instructions

1. • 1

     Insert the Fuji SD card into your computer's card reader.

   • 2

     Click the "Start" button (or the "Windows" logo in Vista or Windows 7). Click "My Computer" or "Computer."

   • 3

     Find your Fujifilm SD card under "Devices With Removable Storage" and right-click on it. Select "Format."

   • 4

     Choose "FAT" under "File System" for SD cards 2GB and under or "FAT32" for cards 4GB or larger. Click "Start." When the formatting process is complete, your Fuji SD card will be initialized.

source : http://www.ehow.com/how_6939829_initialize-fuji-sd-memory-card.html