|
<< Click to Display Table of Contents >> BDE Employee sample |
  
|
|
<< Click to Display Table of Contents >> BDE Employee sample |
|
/* Create and populate the BDE table Employee */
/* Date format 'MM/dd/yyyy' compliant with standard BDE US date format */
CREATE TABLE Employee
(
EmpNo DECIMAL(4,0)
, LastName VARCHAR(20)
, FirstName VARCHAR(15)
, PhoneExt VARCHAR(4)
, HireDate DATE
, Salary DECIMAL(10,4)
, PRIMARY KEY ("Employee"."EmpNo")
);
CREATE INDEX ByName ON Employee (LastName,FirstName); /* << Do NOT use with dBASE */
INSERT INTO Employee VALUES ("2","Nelson","Roberto","250","12/28/1988","40000");
INSERT INTO Employee VALUES ("4","Young","Bruce","233","12/28/1988","55500");
INSERT INTO Employee VALUES ("5","Lambert","Kim","22","02/06/1989","25000");
INSERT INTO Employee VALUES ("8","Johnson","Leslie","410","04/05/1989","25050");
INSERT INTO Employee VALUES ("9","Forest","Phil","229","04/17/1989","25050");
INSERT INTO Employee VALUES ("11","Weston","K. J.","34","01/17/1990","33292.9375");
INSERT INTO Employee VALUES ("12","Lee","Terri","256","05/01/1990","45332");
INSERT INTO Employee VALUES ("14","Hall","Stewart","227","06/04/1990","34482.625");
INSERT INTO Employee VALUES ("15","Young","Katherine","231","06/14/1990","24400");
INSERT INTO Employee VALUES ("20","Papadopoulos","Chris","887","01/01/1990","25050");
INSERT INTO Employee VALUES ("24","Fisher","Pete","888","09/12/1990","23040");
INSERT INTO Employee VALUES ("28","Bennet","Ann","5","02/01/1991","34482.8");
INSERT INTO Employee VALUES ("29","De Souza","Roger","288","02/18/1991","25500");
INSERT INTO Employee VALUES ("34","Baldwin","Janet","2","03/21/1991","23300");
INSERT INTO Employee VALUES ("36","Reeves","Roger","6","04/25/1991","33620");
INSERT INTO Employee VALUES ("37","Stansbury","Willie","7","04/25/1991","39224");
INSERT INTO Employee VALUES ("44","Phong","Leslie","216","06/03/1991","40350");
INSERT INTO Employee VALUES ("45","Ramanathan","Ashok","209","08/01/1991","33292.94");
INSERT INTO Employee VALUES ("46","Steadman","Walter","210","08/09/1991","19599");
INSERT INTO Employee VALUES ("52","Nordstrom","Carol","420","10/02/1991","4500");
INSERT INTO Employee VALUES ("61","Leung","Luke","3","02/18/1992","34500");
INSERT INTO Employee VALUES ("65","O'Brien","Sue Anne","877","03/23/1992","31275");
INSERT INTO Employee VALUES ("71","Burbank","Jennifer M.","289","04/15/1992","45332");
INSERT INTO Employee VALUES ("72","Sutherland","Claudia","","04/20/1992","35699");
INSERT INTO Employee VALUES ("83","Bishop","Dana","290","06/01/1992","45000");
INSERT INTO Employee VALUES ("85","MacDonald","Mary S.","477","06/01/1992","35699");
INSERT INTO Employee VALUES ("94","Williams","Randy","892","08/08/1992","28900");
INSERT INTO Employee VALUES ("105","Bender","Oliver H.","255","10/08/1992","36799");
INSERT INTO Employee VALUES ("107","Cook","Kevin","894","02/01/1993","35500");
INSERT INTO Employee VALUES ("109","Brown","Kelly","202","02/04/1993","27000");
INSERT INTO Employee VALUES ("110","Ichida","Yuki","22","02/04/1993","25689");
INSERT INTO Employee VALUES ("113","Page","Mary","845","04/12/1993","48000");
INSERT INTO Employee VALUES ("114","Parker","Bill","247","06/01/1993","35000");
INSERT INTO Employee VALUES ("118","Yamamoto","Takashi","23","07/01/1993","32500");
INSERT INTO Employee VALUES ("121","Ferrari","Roberto","1","07/12/1993","40500");
INSERT INTO Employee VALUES ("127","Yanowski","Michael","492","08/09/1993","44000");
INSERT INTO Employee VALUES ("134","Glon","Jacques","","08/23/1993","24855");
INSERT INTO Employee VALUES ("136","Johnson","Scott","265","09/13/1993","30588.99");
INSERT INTO Employee VALUES ("138","Green","T.J.","218","11/01/1993","36000");
INSERT INTO Employee VALUES ("141","Osborne","Pierre","","01/03/1994","35600");
INSERT INTO Employee VALUES ("144","Montgomery","John","820","03/30/1994","35699");
INSERT INTO Employee VALUES ("145","Guckenheimer","Mark","221","05/02/1994","32000");
__________________________