Piece of Code: Master SalesPerson

56 Comments on Piece of Code: Master SalesPerson

• « Previous
• 1
• 2

1. F.Melissa says:

   June 13, 2009 at 8:05 pm

   CREATE TABLE SalesPerson {
   KdSales VARCHAR(5) PRIMARY KEY,
   NameSales CHAR(50) NOT NULL ,
   AddSales CHAR(60)NOT NULL,
   PhoneSales CHAR(20) NOT NULL,
   };
   Insert Into SalesPerson VALUES (’SP001′, ‘Steve’, ‘Jl Udara no 3’, ‘089924444048′);
   Insert Into SalesPerson VALUES (’SP002′, ‘Samuel’, ‘Jl Kopi no 40’, ‘0818267323244′);
   Insert Into SalesPerson VALUES (’SP003′, ‘Tenny’, ‘Jl Sinar no 26’, ‘99846500′);

   F.Melissa Luis
   1000843154
   06PBT
2. vania - 06 PBT - 1000842731 - oracle says:

   June 13, 2009 at 11:00 pm

   CREATE TABLE MsSalesPerson (
   KdSales VARCHAR(5)PRIMARY KEY,
   NamaSales VARCHAR (25) NOT NULL,
   Telp VARCHAR (12) NOT NULL,
   Email VARCHAR (25)
   );
   INSERT INTO MsCustomer VALUES (‘S0001′,’Sally’,’08988789456′,’sally@mail.com’);
   INSERT INTO MsCustomer VALUES (‘S0002′,’Lorenzo’,’081319878455′,’lorenzo@mail.com’);
   INSERT INTO MsCustomer VALUES (‘S0003′,’Proney’,’08785456987′,’proney@mail.com’);
3. Desy Ayu Puspita says:

   June 14, 2009 at 8:03 pm

   Desy Ayu Puspita /06PGT/1000885200

   CREATE TABLE MsSalesPerson (
   KdsalesPerson VARCHAR(5) NOT NULL PRIMARY KEY,
   NamaSalesPerson VARHCHAR(30),
   AlamatSalesPerson VARCHAR(100),
   TelpSalesPerson VARCHAR(12),
   );

   INSERT INTO MsSalesPerson VALUES (’S001′,’Abi’, ‘Jl. Anggur no. 1′,0215308211);
   INSERT INTO MsSalesPerson VALUES (’S002′,’Abu’, ‘Jl. Jeruk no. 2′,0215432166);
   INSERT INTO MsSalesPerson VALUES (’S003′,’Aki’, ‘Jl. Mangga no. 3′,021654344);
4. Ora Cell 06PBT says:

   June 14, 2009 at 9:44 pm

   CREATE TABLE SalesPerson (
   KdSales VARCHAR2(5) NOT NULL,
   NmSales VARCHAR(50) NOT NULL ,
   AlamatSales VARCHAR(200),
   TelpSales INT(30),
   PRIMARY KEY (”KdSales”)
   )

   Insert Into SalesPerson VALUES (’KSP001′, ‘Pieter’, ‘Jl. jalan01’, ‘654633397′);
   Insert Into SalesPerson VALUES (’KSP002′, ‘Ganteng’, ‘Jl. jalan02’, ‘4222894′);
   Insert Into SalesPerson VALUES (’KSP003′, ‘Lho’, ‘Jl. jalan02’, ‘14123472′);
5. Kelompok SQL 06PBT says:

   June 14, 2009 at 10:22 pm

   Kelompok SQL 06PBT

   CREATE TABLE Sales
   {
   Kdsales VARCHAR(5) NOT NULL,
   NamaSales VARHCHAR(25) NOT NULL,
   AlamatSales VARCHAR(50) NOT NULL,
   PRIMARY KEY (Kdsales)
   constraint Sales check (len(KdBoneka) = 5),
   constraint Sales2 check (KdBoneka like ‘KS[0-9][0-9][0-9]‘)
   };

   INSERT INTO MsSales VALUES (’KS001′,’Awan’, ‘Jl. Syadan no 5′);
   INSERT INTO MsSales VALUES (’KS002′,’Deki’, ‘Jl. Angrek no 5′);
   INSERT INTO MsSales VALUES (’KS003′,’Peter’, ‘Jl. U no 5′);
6. Desy Ayu Puspita says:

   July 9, 2009 at 10:30 am

   DESY AYU P /1000885200/06PGT
   create table SalesPerson (
   KdSalesPerson varchar(8) primary key,
   NamaSalesPerson varchar(30),
   AlamatSalesPerson varchar(50)
   )

   INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson) VALUES (SP0001,’Hardi’ ,’Tomang’)
   INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson)) VALUES (SP0002,’Sri’,’Pondok Gede’)
   INSERT INTO SalesPerson (KdSalesPerson,NamaSalesPerson,AlamatSalesPerson)) VALUES (SP0003,’Nur’,’Cilandak’);

• « Previous
• 1
• 2