Docstoc

Data Dictionary - Courtney Kallemeres

Document Sample
Data Dictionary - Courtney Kallemeres Powered By Docstoc
					             Attribute               Entity   Key     Datatype   Length (Bytes)
TechID                   Tech                 PK        INT            4
First Name               Tech                       VARCHAR (20)      21
Last Name                Tech                       VARCHAR (20)       21
Certified                Tech                         Boolean          1

ShiftID                  Shift                PK        INT             4
Day                      Shift                         TINYINT          1
Evening                  Shift                         TINYINT          1
Midnight                 Shift                         TINYINT          1

ProblemID                Problem              PK        INT            4
Type                     Problem                    VARCHAR(25)        26
Date                     Problem                       Date             3
Active                   Problem                      Boolean           1
Second Echelon           Problem                      Boolean           1

DepartmentID             Department           PK        INT             4
Name                     Department                 VARCHAR (25)

InventoryID              Inventory            PK        INT             4
Type                     Inventory                  VARCHAR (50)       51
Serial Number            Inventory                    TINYINT          1
Quantity                 Inventory                    TINYINT          1

LocationID               Location             PK        INT             4
Building Name            Location                   VARCHAR(15)        16
Room Number              Location                     TINYINT          1

SupervisorID             Supervisor           PK        INT            4
First Name               Supervisor                 VARCHAR(20)        21
Last Name                Supervisor                 VARCHAR(20)        21

PositionID               Position                       INT            4
Type                     Position                   VARCHAR(10)        11
             Comments




FK in Tech




FK in Problem



FK in Department




FK in Inventory




FK in Tech




FK in Department
     Attribute                Entity            Key     Datatype    Length

TechID            Tech                     PK         INT                 4
EmployeeID        Tech                                VARCHAR(20)        21
Certified         Tech                                BOOLEAN             1

InventoryID       Inventory                PK         INT                 4
Item Type         Inventory                           VARCHAR(10)        11
Serial Number     Inventory                           INT                 4
LocationID        Inventory                FK         INT                 4
DepartmentID      Inventory                FK         INT                 4

LocationID        Location                 PK         INT                 4
Building          Location                            VARCHAR(12)        13
Room              Location                            TINYINT             1

EmployeeID        Employee                 PK         INT                 4
First Name        Employee                            VARCHAR(20)        21
Last Name         Employee                            VARCHAR(20)        21
DepartmentID      Employee                 FK         INT                 4
ShiftID           Employee                 FK         INT                 5
RankID            Employee                 FK         INT                 4

DepartmentID      Department               PK         INT                 4
Department Name   Department                          VARCHAR(25)        26

RankID            Rank                     PK         INT                 4
Type              Rank                                VARCHAR(10)        11

ProblemID         Problem                  PK         INT                 4
Type              Problem                             VARCHAR(25)        26
Date              Problem                             DATE                3
Closed Date       Problem                             DATE                3
Active            Problem                             BOOLEAN             1
Second Echelon    Problem                             BOOLEAN             1
DepartmentID      Problem                  FK         INT                 4
TechID            Problem                  FK         INT                 4
InventoryID       Problem                  FK         INT                 4
EmployeeID        Problem                  FK         INT                 4

ShiftID           Shift                    PK         INT                 4
Time              Shift                               VARCHAR(10)        11

PTJTID            ProblemTechJoinedTable   PK         INT                    4
TechID            ProblemTechJoinedTable   FK         INT                    4
ProblemID         ProblemTechJoinedTable   FK         INT                    5
    Comments

FK in Problem
PK in Employee




PK in Location
PK in Department




FK in Tech, FK in Problem


PK in Department
PK in Shift
PK in Rank

FK in Employee


FK in Employee




PK in Department
PK in Tech
PK in Inventory
PK in Employee

FK in Tech




PK in Tech
PK in Problem
Create Statement
CREATE TABLE Shift(ShiftID INT primary key not null auto_increment, Time VARCHAR(10))

 ShiftID      Time
1          Day
2          Evening
3          Midnight
ftID INT primary key not null auto_increment, Time VARCHAR(10))

                                           Insert Statements
           INSERT INTO Shift(ShiftID, Time) VALUES (NULL, 'Day');
           INSERT INTO Shift(ShiftID, Time) VALUES (NULL, 'Evening');
           INSERT INTO Shift(ShiftID, Time) VALUES (NULL, 'Midnight');
Create Statement
CREATE TABLE Problem(ProblemID INT primary key not null auto_increment, Type VARCHAR(25), Date Date, ClosedDate Date

Problem ID          Type             Date       ClosedDate    Active    Second Echelon
             Virus                 2009-11-17    9999-01-01      1              1
             Virus                 2009-11-23    2009-12-03      0              1
             Virus                 2009-07-26    2009-12-04      0              1
             Virus                 2009-11-01    2009-11-15      0              0
             Virus                 2009-11-01    2009-11-15      0              1
             Virus                 2009-11-24    2009-12-03      0              1
             Virus                 2009-12-04    9999-01-01      1              0
             Virus                 2009-12-04    9999-01-01      1              0
             Networking            2009-11-24    9999-01-01      1              1
             Networking            2009-11-01    2009-11-01      0              1
             Networking            2009-01-02    2009-03-03      0              1
             Networking            2009-11-17    9999-01-01      1              1
             Networking            2009-11-23    2009-12-03      0              1
             Networking            2009-07-26    2009-12-04      0              1
             Networking            2009-11-01    2009-11-15      0              0
             Networking            2009-11-01    2009-11-15      0              1
             Networking            2009-01-08    2009-02-09      0              1
             Networking            2009-01-09    2009-10-15      0              0
             Hardware              2009-01-10    2009-11-15      0              0
             Hardware              2009-01-11    9999-01-01      1              1
             Hardware              2009-01-12    2009-12-04      0              1
             Software              2009-11-17    9999-01-01      1              1
             Software              2009-01-14    9999-01-01      1              1
             Software              2009-10-15    9999-01-01      1              1
             Software              2009-01-16    9999-01-01      1              1
             Software              2009-01-17    9999-01-01      1              1
             Software              2009-01-18    2009-12-04      1              1
             Software              2009-01-19    9999-01-01      1              1
             Software              2009-01-20    9999-01-01      1              1
             Software              2009-10-21    2009-12-07      0              1
             Software              2009-01-22    9999-01-01      1              1
             Software              2009-02-23    9999-01-01      1              1
             Software              2009-12-04    9999-01-01      1              0
             Operating System      2009-01-25    2009-11-29      0              0
             Operating System      2009-01-12    2009-12-04      0              1
             Operating System      2009-12-04    9999-01-01      1              0
             Operating System      2009-12-04    9999-01-01      1              0
             Password              2009-09-27    2009-09-30      0              1
             Password              2009-01-12    2009-12-04      0              1
             Password              2009-12-04    9999-01-01      1              0
             Password              2009-01-22    9999-01-01      1              1
             Password              2009-02-23    9999-01-01      1              1
User Error   2009-11-11   2009-12-02       0     0
User Error   2009-08-12   2009-09-12       0     0
User Error   2009-11-03   9999-01-01       1     1
User Error   2009-12-04   9999-01-01       1     0




                                       Yes = 1
                                       No = 0
RCHAR(25), Date Date, ClosedDate Date, Active Boolean, SecondEchelon Boolean, DepartmentID INT, TechID INT, InventoryID INT, Emplo

            DepartmentID TechID Inventory ID            EmployeeID
                           3        5              38               1
                           1        9              55              57
                           2        9               9              77
                           2        7              50              91
                           1        8              16              24
                           4        8               2               9
                           3        3               3              39
                           3        5              53              74
                           3        2              55               2
                           1        9              10               8
                           2        5              62              40
                           2        5              14              90
                           3       10               5              90
                           2        5               7               5
                           2        5              39              49
                           3        7              58              85
                           4       10              41               8
                           3        2              50              22
                           2        5              27              84
                           2        1              55               3
                           2        6               5              53
                           3        5              50              22
                           2       10              55              56
                           3        6               8              46
                           3        5              44               2
                           1        6               3              63
                           1        5              55              58
                           1        6              31              69
                           3        5              58              10
                           1       10              36              45
                           1        5               5              68
                           3        7              30               4
                           3        7              29              75
                           2        9              11              22
                           2        3              55              55
                           4       10              18              41
                           3        7              45              81
                           2        7              35               6
                           3        4              17              60
                           3        3               2              57
                           2        7              23              24
                           1        9              16               7
1    9   36   73
3    5    5   35
2    9   20    9
1   10   55   90
ean, DepartmentID INT, TechID INT, InventoryID INT, EmployeeID INT);

                                                        Insert Statements
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
           INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
INSERT INTO Problem(ProblemID, Type, Date, ClosedDate, Active, SecondEchelon, DepartmentID, TechID, InventoryID, Emplo
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-11-17','2009-11-17',1,1,3,5,38,1);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-11-23','2009-11-23',0,1,1,9,55,57);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-07-26','2009-07-26',0,1,2,9,9,77);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-11-01','2009-11-01',0,0,2,7,50,91);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-11-01','2009-11-01',0,1,1,8,16,24);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-11-24','2009-11-24',0,1,4,8,2,9);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-12-04','2009-12-04',1,0,3,3,3,39);
hID, InventoryID, EmployeeID) VALUES (NULL,'Virus','2009-12-04','2009-12-04',1,0,3,5,53,74);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-24','2009-11-24',1,1,3,2,55,2);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-01','2009-11-01',0,1,1,9,10,8);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-01-02','2009-01-02',0,1,2,5,62,40);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-17','2009-11-17',1,1,2,5,14,90);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-23','2009-11-23',0,1,3,10,5,90);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-07-26','2009-07-26',0,1,2,5,7,5);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-01','2009-11-01',0,0,2,5,39,49);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-11-01','2009-11-01',0,1,3,7,58,85);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-01-08','2009-01-08',0,1,4,10,41,8);
hID, InventoryID, EmployeeID) VALUES (NULL,'Networking','2009-01-09','2009-01-09',0,0,3,2,50,22);
hID, InventoryID, EmployeeID) VALUES (NULL,'Hardware','2009-01-10','2009-01-10',0,0,2,5,27,84);
hID, InventoryID, EmployeeID) VALUES (NULL,'Hardware','2009-01-11','2009-01-11',1,1,2,1,55,3);
hID, InventoryID, EmployeeID) VALUES (NULL,'Hardware','2009-01-12','2009-01-12',0,1,2,6,5,53);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-11-17','2009-11-17',1,1,3,5,50,22);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-14','2009-01-14',1,1,2,10,55,56);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-10-15','2009-10-15',1,1,3,6,8,46);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-16','2009-01-16',1,1,3,5,44,2);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-17','2009-01-17',1,1,1,6,3,63);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-18','2009-01-18',1,1,1,5,55,58);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-19','2009-01-19',1,1,1,6,31,69);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-20','2009-01-20',1,1,3,5,58,10);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-10-21','2009-10-21',0,1,1,10,36,45);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-01-22','2009-01-22',1,1,1,5,5,68);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-02-23','2009-02-23',1,1,3,7,30,4);
hID, InventoryID, EmployeeID) VALUES (NULL,'Software','2009-12-04','2009-12-04',1,0,3,7,29,75);
hID, InventoryID, EmployeeID) VALUES (NULL,'Operating System','2009-01-25','2009-01-25',0,0,2,9,11,22);
hID, InventoryID, EmployeeID) VALUES (NULL,'Operating System','2009-01-12','2009-01-12',0,1,2,3,55,55);
hID, InventoryID, EmployeeID) VALUES (NULL,'Operating System','2009-12-04','2009-12-04',1,0,4,10,18,41);
hID, InventoryID, EmployeeID) VALUES (NULL,'Operating System','2009-12-04','2009-12-04',1,0,3,7,45,81);
hID, InventoryID, EmployeeID) VALUES (NULL,'Password','2009-09-27','2009-09-27',0,1,2,7,35,6);
hID, InventoryID, EmployeeID) VALUES (NULL,'Password','2009-01-12','2009-01-12',0,1,3,4,17,60);
hID, InventoryID, EmployeeID) VALUES (NULL,'Password','2009-12-04','2009-12-04',1,0,3,3,2,57);
hID, InventoryID, EmployeeID) VALUES (NULL,'Password','2009-01-22','2009-01-22',1,1,2,7,23,24);
hID, InventoryID, EmployeeID) VALUES (NULL,'Password','2009-02-23','2009-02-23',1,1,1,9,16,7);
hID, InventoryID, EmployeeID) VALUES (NULL,'User Error','2009-11-11','2009-11-11',0,0,1,9,36,73);
hID, InventoryID, EmployeeID) VALUES (NULL,'User Error','2009-08-12','2009-08-12',0,0,3,5,5,35);
hID, InventoryID, EmployeeID) VALUES (NULL,'User Error','2009-11-03','2009-11-03',1,1,2,9,20,9);
hID, InventoryID, EmployeeID) VALUES (NULL,'User Error','2009-12-04','2009-12-04',1,0,1,10,55,90);
2);
5);
41);
1);
Create Statement
CREATE TABLE Rank(PositionID INT primary key not null auto_increment, Position VARCHAR(10));

    RankID      Type
1            Supervisor
2            Manager
3            Worker
onID INT primary key not null auto_increment, Position VARCHAR(10));

                                                        Insert Statements
           INSERT INTO Rank(RankID, Position) VALUES (NULL, 'Supervisor');
           INSERT INTO Rank(RankID, Position) VALUES (NULL, 'Manager');
           INSERT INTO Rank(RankID, Position) VALUES (NULL, 'Worker');
Create Statement
CREATE TABLE Department(DepartmentID INT primary key not null auto_increment, DepartmentName VARCHAR(25));

 Department ID      Department Name
1                Administration
2                Sales
3                Shipping And Recieving
4                HelpDesk
primary key not null auto_increment, DepartmentName VARCHAR(25));

                                                     Insert Statements
          INSERT INTO Department(DepartmentID, DepartmentName) VALUES (NULL, 'Administration');
          INSERT INTO Department(DepartmentID, DepartmentName) VALUES (NULL, 'Sales');
          INSERT INTO Department(DepartmentID, DepartmentName) VALUES (NULL, 'ShippingAndRecieving');
          INSERT INTO Department(DepartmentID, DepartmentName) VALUES (NULL, 'HelpDesk');
 Create Statement
CREATE TABLE Inventory(InventoryID INT primary key not null auto_increment, ItemType VARCHAR(10), SerialNumber INT, Lo

    Inventory ID        ItemType      Serial Number    LocationID    DepartmentID
         1           Computer               104              8              3
         2           Computer               105              7              3
         3           Computer               106              8              4
         4           Computer               107              3              1
         5           Computer               108              1              3
         6           Computer               109              9              4
         7           Computer               110              4              1
         8           Computer               111              4              1
         9           Computer               112              9              4
         10          Computer               113              1              1
         11          Computer               114              9              2
         12          Computer               115             11              2
         13          Computer               116             10              4
         14          Computer               117              1              1
         15          Computer               118             12              3
         16          Computer               119              8              1
         17          Computer               120              9              3
         18          Computer               121              6              3
         19          Computer               122              8              2
         20          Computer               123             12              3
         21          Computer               124              1              2
         22          Computer               125              3              4
         23          Computer               126              7              2
         24          Computer               127              7              1
         25          Computer               128              9              2
         26          Computer               129              9              1
         27          Computer               130              7              2
         28          Computer               131             11              2
         29          Computer               132              7              2
         30          Computer               133             10              4
         31          Computer               134              1              1
         32          Computer               135              2              2
         33          Computer               136              9              2
         34          Computer               137             11              2
         35          Computer               138              7              3
         36          Computer               139              5              3
         37          Computer               140              1              3
         38          Computer               141              3              1
         39          Computer               142             11              1
         40          Computer               143              3              2
         41          Computer               144              1              3
         42          Computer               145              1              1
43   Computer     146     9   4
44   Computer     147     9   2
45   Computer     148     5   2
46   Computer     149    10   2
47   Computer     150     3   2
48   Computer     151     2   4
49   Computer     152     1   2
50   Computer     153    11   1

51   Server       1001   11   2
52   Server       1002    2   2

53   Cell Phone   3500   4    1
54   Cell Phone   3600   8    3
55   Cell Phone   3700   6    4
56   Cell Phone   3800   7    2
57   Cell Phone   3900   8    2

58   Projector    4000   12   1
59   Projector    4001    2   4

60   Printer      500     8   3
61   Printer      501     2   4
62   Printer      502    11   2
ARCHAR(10), SerialNumber INT, LocationID INT, DepartmentID INT);

                                                       Insert Statements
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '104', '8
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '105', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '106', '8
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '107', '3
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '108', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '109', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '110', '4
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '111', '4
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '112', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '113', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '114', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '115', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '116', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '117', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '118', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '119', '8
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '120', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '121', '6
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '122', '8
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '123', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '124', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '125', '3
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '126', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '127', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '128', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '129', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '130', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '131', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '132', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '133', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '134', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '135', '2
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '136', '9
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '137', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '138', '7
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '139', '5
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '140', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '141', '3
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '142', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '143', '3
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '144', '1
           INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '145', '1
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '146', '9
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '147', '9
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '148', '5
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '149', '1
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '150', '3
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '151', '2
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '152', '1
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Computer', '153', '1

INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Server', '1001', '11'
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Server', '1002', '2', '

INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Cell Phone', '3500',
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Cell Phone', '3600',
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Cell Phone', '3700',
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Cell Phone', '3800',
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Cell Phone', '3900',

INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Projector', '4000', '1
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Projector', '4001', '2

INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Printer', '500', '8', '3
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Printer', '501', '2', '4
INSERT INTO Inventory(InventoryID, ItemType, SerialNumber, LocationID, DepartmentID) VALUES (NULL, 'Printer', '502', '11',
 LL, 'Computer', '104', '8', '3');
 LL, 'Computer', '105', '7', '3');
 LL, 'Computer', '106', '8', '4');
 LL, 'Computer', '107', '3', '1');
 LL, 'Computer', '108', '1', '3');
 LL, 'Computer', '109', '9', '4');
 LL, 'Computer', '110', '4', '1');
 LL, 'Computer', '111', '4', '1');
 LL, 'Computer', '112', '9', '4');
 LL, 'Computer', '113', '1', '1');
 LL, 'Computer', '114', '9', '2');
 LL, 'Computer', '115', '11', '2');
 LL, 'Computer', '116', '10', '4');
 LL, 'Computer', '117', '1', '1');
 LL, 'Computer', '118', '12', '3');
ULL, 'Computer', '119', '8', '1');
ULL, 'Computer', '120', '9', '3');
ULL, 'Computer', '121', '6', '3');
ULL, 'Computer', '122', '8', '2');
ULL, 'Computer', '123', '12', '3');
 LL, 'Computer', '124', '1', '2');
 LL, 'Computer', '125', '3', '4');
 LL, 'Computer', '126', '7', '2');
 LL, 'Computer', '127', '7', '1');
 LL, 'Computer', '128', '9', '2');
 LL, 'Computer', '129', '9', '1');
 LL, 'Computer', '130', '7', '2');
 LL, 'Computer', '131', '11', '2');
 LL, 'Computer', '132', '7', '2');
 LL, 'Computer', '133', '10', '43');
 LL, 'Computer', '134', '1', '1');
 LL, 'Computer', '135', '2', '2');
 LL, 'Computer', '136', '9', '2');
 LL, 'Computer', '137', '11', '2');
 LL, 'Computer', '138', '7', '3');
 LL, 'Computer', '139', '5', '3');
 LL, 'Computer', '140', '1', '3');
 LL, 'Computer', '141', '3', '1');
 LL, 'Computer', '142', '11', '1');
 LL, 'Computer', '143', '3', '2');
 LL, 'Computer', '144', '1', '3');
 LL, 'Computer', '145', '1', '1');
LL, 'Computer', '146', '9', '4');
LL, 'Computer', '147', '9', '2');
LL, 'Computer', '148', '5', '2');
LL, 'Computer', '149', '10', '2');
LL, 'Computer', '150', '3', '2');
LL, 'Computer', '151', '2', '4');
LL, 'Computer', '152', '1', '2');
LL, 'Computer', '153', '11', '1');

LL, 'Server', '1001', '11', '2');
LL, 'Server', '1002', '2', '2');

LL, 'Cell Phone', '3500', '4', '1');
LL, 'Cell Phone', '3600', '8', '3');
LL, 'Cell Phone', '3700', '6', '4');
LL, 'Cell Phone', '3800', '7', '2');
LL, 'Cell Phone', '3900', '8', '2');

LL, 'Projector', '4000', '12', '21');
LL, 'Projector', '4001', '2', '4');

LL, 'Printer', '500', '8', '3');
LL, 'Printer', '501', '2', '4');
LL, 'Printer', '502', '11', '2');
Create Statement
CREATE TABLE Location(LocationID INT primary key not null auto_increment, Building VARCHAR(15), Room TINYINT);

Location ID        Building       Room
1             Castle            1
2             Castle            2
3             Castle            3
4             Castle            4
5             Buy More          10
6             Buy More          11
7             Buy More          12
8             Buy More          13
9             Orange Orange     20
10            Orange Orange     21
11            Orange Orange     22
12            Orange Orange     23
y key not null auto_increment, Building VARCHAR(15), Room TINYINT);

                                                 Insert Statements
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Castle', 1);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Castle', 2);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Castle', 3);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Castle', 4);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Buy More', 10);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Buy More', 11);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Buy More', 12);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Buy More', 13);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Orange Orange', 20);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Orange Orange', 21);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Orange Orange', 22);
           INSERT INTO Location (LocationID, Building, Room) VALUES (NULL, 'Orange Orange', 23);
Create Statement
CREATE TABLE Employee(EmployeeID INT primary key not null auto_increment, FirstName VARCHAR(20), LastName VARCHA

EmployeeID     First Name    Last Name       DepartmentID    PositionID ShiftID
1             Julia         Ling         3                  3           1
2             Vik           Sahay        2                  3           1
3             Scott         Krinsky      2                  3           1
4             Mark          Lawrence     1                  2           1
5             Zachary       Levi         1                  2           2
6             Yvonne        Strahovski   1                  3           2
7             Adam          Baldwin      1                  3           2
8             Joshua        Gomez        3                  3           2
9             Sarah         Landcaster   2                  2           3
10            Ryan          McPartlin    2                  3           3
11            Anna          Wu           4                  3           1
12            Lester        Patel        4                  3           1
13            Jeff          Barnes       4                  3           1
14            Michael       Tucker       4                  2           1
15            Chuck         Bartowski    4                  2           2
16            Sarah         Walker       4                  3           2
17            John          Casey        4                  3           2
18            Morgan        Grimes       4                  3           2
19            Ellie         Woodcomb     4                  2           3
20            Devon         Woodcomb     4                  3           3
21            Dianne        Beckman      1                  1           3
22            Bonita        Friedericy   1                  1           2
23            Emmett        Millbarge    3                  3           3
24            Carina        Hansen       2                  3           1
25            Jethro        Gibbs        1                  1           2
26            Anthony       DiNozzo      2                  2           3
27            Timothy       McGee        2                  2           1
28            Ziva          David        3                  2           2
29            Donald        Mallard      1                  3           2
30            Abby          Sciuto       3                  2           1
31            Jimmy         Palmer       3                  2           1
32            Jenny         Sheppard     1                  2           1
33            Leon          Vance        1                  2           1
34            Aaron         Hotchner     2                  1           3
35            Derek         Morgan       3                  2           3
36            Spencer       Reid         3                  2           2
37            Jennifer      Jareau       3                  2           3
38            Penelope      Garcia       3                  2           2
39            Emily         Prentiss     1                  3           3
40            David         Rossi        1                  2           1
41   Noah         Bennet       3   2   2
42   Clare        Bennet       2   2   2
43   Peter        Petrelli     1   2   3
44   Hiro         Nakamura     3   2   2
45   Nathan       Petrelli     2   2   1
46   Mohinder     Suresh       1   3   2
47   Ando         Masahashi    1   3   3
48   Matt         Parkman      1   3   2
49   Gabriel      Gray         1   3   3
50   Niki         Sanders      2   2   1
51   Angela       Petrelli     3   3   1
52   Sandra       Bennet       1   2   1
53   Micah        Sanders      2   3   3
54   Cal          Lightman     1   2   3
55   Gillian      Foster       1   2   3
56   Eli          Loker        1   3   3
57   Ria          Torres       3   2   1
58   Emily        Lightman     2   2   2
59   Ben          Reynolds     2   3   1
60   Temperance   Brennan      1   3   2
61   Seeley       Booth        3   3   2
62   Angela       Montengro    2   3   1
63   Jack         Hodgins      2   2   2
64   Camille      Saroyan      1   3   1
65   Lance        Sweets       3   3   3
66   Charlie      Eppes        2   2   2
67   Don          Eppes        1   1   3
68   Alan         Eppes        1   2   1
69   David        Sinclair     2   2   3
70   Amita        Ramanujan    2   3   1
71   Larry        Fleinhardt   2   3   3
72   Colby        Granger      2   2   3
73   Megan        Reeves       2   2   2
74   Liz          Warner       3   3   3
75   Mac          Taylor       3   3   2
76   Stella       Bonasera     3   3   1
77   Danny        Messer       2   2   1
78   Sheldon      Hawkes       2   3   2
79   Don          Flack        2   3   3
80   Lindsay      Monroe       2   3   2
81   Sid          Hammerback   1   3   3
82   Adam         Ross         2   3   1
83   Ethan        Hunt         1   3   2
84   James        Bond         3   3   3
85    Laura     Croft      2   3   1
86    Jack      Traven     1   2   1
87    Ben       Gates      1   2   2
88    Abigail   Chase      3   3   3
89    Riley     Poole      1   2   2
90    Jack      Hall       2   2   3
91    Laura     Hall       3   2   1
92    Sam       Hall       1   3   1
93    Lisa      Reisert    1   2   1
94    Jackson   Rippner    2   3   2
95    Joe       Reisert    3   2   2
96    Jason     Bourne     1   3   1
97    Jerry     Shaw       2   2   2
98    Chris     Fedak      3   3   1
99    Josh      Schwartz   1   3   2
100   Captain   Awesome    1   1   1
VARCHAR(20), LastName VARCHAR(20), DepartmentID INT, PositionID INT, ShiftID INT);

                                                       Insert Statements
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Julia','Ling',3,3,
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Vik','Sahay',2,3
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Scott','Krinsky'
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Mark','Lawrenc
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Zachary','Levi',
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Yvonne','Straho
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Adam','Baldwin
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Joshua','Gomez
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sarah','Landcas
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ryan','McPartli
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Anna','Wu',4,3
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Lester','Patel',4
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jeff','Barnes',4,
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Michael','Tucke
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Chuck','Bartow
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sarah','Walker'
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'John','Casey',4
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Morgan','Grime
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ellie','Woodcom
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Devon','Woodc
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Dianne','Beckm
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Bonita','Frieder
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Emmett','Millb
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Carina','Hansen
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jethro','Gibbs',
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Anthony','DiNo
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Timothy','McG
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ziva','David',3,2
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Donald','Mallar
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Abby','Sciuto',3
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jimmy','Palmer
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jenny','Sheppa
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Leon','Vance',1
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Aaron','Hotchn
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Derek','Morgan
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Spencer','Reid'
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jennifer','Jarea
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Penelope','Gar
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Emily','Prentiss
           INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'David','Rossi',1
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Noah','Bennet'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Clare','Bennet'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Peter','Petrelli'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Hiro','Nakamur
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Nathan','Petrel
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Mohinder','Sur
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ando','Masaha
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Matt','Parkman
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Gabriel','Gray',
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Niki','Sanders',
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Angela','Petrell
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sandra','Benne
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Micah','Sander
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Cal','Lightman'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Gillian','Foster'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Eli','Loker',1,3,3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ria','Torres',3,2
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Emily','Lightma
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ben','Reynolds
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Temperance','B
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Seeley','Booth'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Angela','Monte
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jack','Hodgins',
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Camille','Saroy
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Lance','Sweets
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Charlie','Eppes
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Don','Eppes',1,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Alan','Eppes',1,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'David','Sinclair'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Amita','Raman
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Larry','Fleinhar
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Colby','Granger
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Megan','Reeve
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Liz','Warner',3,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Mac','Taylor',3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Stella','Bonaser
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Danny','Messe
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sheldon','Hawk
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Don','Flack',2,3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Lindsay','Monr
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sid','Hammerb
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Adam','Ross',2,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ethan','Hunt',1
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'James','Bond',3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Laura','Croft',2
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jack','Traven',1
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Ben','Gates',1,2
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Abigail','Chase'
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Riley','Poole',1
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jack','Hall',2,2,3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Laura','Hall',3,2
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Sam','Hall',1,3,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Lisa','Reisert',1
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jackson','Rippn
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Joe','Reisert',3,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jason ','Bourne
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Jerry','Shaw',2,
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Chris','Fedak',3
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Josh','Schwartz
INSERT INTO Employee(EmployeeID, FirstName, LastName, DepartmentID, PositionID, ShiftID) VALUES (NULL,'Captain','Awes
S (NULL,'Julia','Ling',3,3,1);
S (NULL,'Vik','Sahay',2,3,1);
S (NULL,'Scott','Krinsky',2,3,1);
S (NULL,'Mark','Lawrence',1,2,1);
S (NULL,'Zachary','Levi',1,2,2);
S (NULL,'Yvonne','Strahovski',1,3,2);
S (NULL,'Adam','Baldwin',1,3,2);
S (NULL,'Joshua','Gomez',3,3,2);
S (NULL,'Sarah','Landcaster',2,2,3);
S (NULL,'Ryan','McPartlin',2,3,3);
S (NULL,'Anna','Wu',4,3,1);
S (NULL,'Lester','Patel',4,3,1);
S (NULL,'Jeff','Barnes',4,3,1);
S (NULL,'Michael','Tucker',4,2,1);
S (NULL,'Chuck','Bartowski',4,2,2);
S (NULL,'Sarah','Walker',4,3,2);
S (NULL,'John','Casey',4,3,2);
S (NULL,'Morgan','Grimes',4,3,2);
S (NULL,'Ellie','Woodcomb',4,2,3);
S (NULL,'Devon','Woodcomb',4,3,3);
S (NULL,'Dianne','Beckman',1,1,3);
S (NULL,'Bonita','Friedericy',1,1,2);
S (NULL,'Emmett','Millbarge',3,3,3);
S (NULL,'Carina','Hansen',2,3,1);
S (NULL,'Jethro','Gibbs',1,1,2);
S (NULL,'Anthony','DiNozzo',2,2,3);
S (NULL,'Timothy','McGee',2,2,1);
S (NULL,'Ziva','David',3,2,2);
S (NULL,'Donald','Mallard',1,3,2);
S (NULL,'Abby','Sciuto',3,2,1);
S (NULL,'Jimmy','Palmer',3,2,1);
S (NULL,'Jenny','Sheppard',1,2,1);
S (NULL,'Leon','Vance',1,2,1);
S (NULL,'Aaron','Hotchner',2,1,3);
S (NULL,'Derek','Morgan',3,2,3);
S (NULL,'Spencer','Reid',3,2,2);
S (NULL,'Jennifer','Jareau',3,2,3);
S (NULL,'Penelope','Garcia',3,2,2);
S (NULL,'Emily','Prentiss',1,3,3);
S (NULL,'David','Rossi',1,2,1);
S (NULL,'Noah','Bennet',3,2,2);
S (NULL,'Clare','Bennet',2,2,2);
S (NULL,'Peter','Petrelli',1,2,3);
S (NULL,'Hiro','Nakamura',3,2,2);
S (NULL,'Nathan','Petrelli',2,2,1);
S (NULL,'Mohinder','Suresh',1,3,2);
S (NULL,'Ando','Masahashi',1,3,3);
S (NULL,'Matt','Parkman',1,3,2);
S (NULL,'Gabriel','Gray',1,3,3);
S (NULL,'Niki','Sanders',2,2,1);
S (NULL,'Angela','Petrelli',3,3,1);
S (NULL,'Sandra','Bennet',1,2,1);
S (NULL,'Micah','Sanders',2,3,3);
S (NULL,'Cal','Lightman',1,2,3);
S (NULL,'Gillian','Foster',1,2,3);
S (NULL,'Eli','Loker',1,3,3);
S (NULL,'Ria','Torres',3,2,1);
S (NULL,'Emily','Lightman',2,2,2);
S (NULL,'Ben','Reynolds',2,3,1);
S (NULL,'Temperance','Brennan',1,3,2);
S (NULL,'Seeley','Booth',3,3,2);
S (NULL,'Angela','Montengro',2,3,1);
S (NULL,'Jack','Hodgins',2,2,2);
S (NULL,'Camille','Saroyan',1,3,1);
S (NULL,'Lance','Sweets',3,3,3);
S (NULL,'Charlie','Eppes',2,2,2);
S (NULL,'Don','Eppes',1,1,3);
S (NULL,'Alan','Eppes',1,2,1);
S (NULL,'David','Sinclair',2,2,3);
S (NULL,'Amita','Ramanujan',2,3,1);
S (NULL,'Larry','Fleinhardt',2,3,3);
S (NULL,'Colby','Granger',2,2,3);
S (NULL,'Megan','Reeves',2,2,2);
S (NULL,'Liz','Warner',3,3,3);
S (NULL,'Mac','Taylor',3,3,2);
S (NULL,'Stella','Bonasera',3,3,1);
S (NULL,'Danny','Messer',2,2,1);
S (NULL,'Sheldon','Hawkes',2,3,2);
S (NULL,'Don','Flack',2,3,3);
S (NULL,'Lindsay','Monroe',2,3,2);
S (NULL,'Sid','Hammerback',1,3,3);
S (NULL,'Adam','Ross',2,3,1);
S (NULL,'Ethan','Hunt',1,3,2);
S (NULL,'James','Bond',3,3,3);
S (NULL,'Laura','Croft',2,3,1);
S (NULL,'Jack','Traven',1,2,1);
S (NULL,'Ben','Gates',1,2,2);
S (NULL,'Abigail','Chase',3,3,3);
S (NULL,'Riley','Poole',1,2,2);
S (NULL,'Jack','Hall',2,2,3);
S (NULL,'Laura','Hall',3,2,1);
S (NULL,'Sam','Hall',1,3,1);
S (NULL,'Lisa','Reisert',1,2,1);
S (NULL,'Jackson','Rippner',2,3,2);
S (NULL,'Joe','Reisert',3,2,2);
S (NULL,'Jason ','Bourne',1,3,1);
S (NULL,'Jerry','Shaw',2,2,2);
S (NULL,'Chris','Fedak',3,3,1);
S (NULL,'Josh','Schwartz',1,3,2);
S (NULL,'Captain','Awesome',1,1,1);
Create Statement
CREATE TABLE Tech(TechID INT primary key not null auto_increment, Certified Boolean, EmployeeID INT);

    TechID    Certified EmployeeID
1            Yes (Y)    11
2            Yes      12
3            Yes      13
4            No (N)   14
5            Yes      15
6            Yes      16
7            Yes      17
8            No       18
9            No       19
10           No       20
INT primary key not null auto_increment, Certified Boolean, EmployeeID INT);

                                              Insert Statements
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '11');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '12');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '13');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '0', '14');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '15');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '16');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '1', '17');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '0', '18');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '0', '19');
           INSERT INTO Tech(TechID, Certified, EmployeeID) VALUES (NULL, '0', '20');

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:12/2/2011
language:English
pages:39