/*
Just like the order in which tables and constraints must be created in a relational database, the tables must be populated in an sequence that insures primary key values exist before foreign key values will reference them. A table on the "one" side of a one-to-many relationship should have data inserted before inserting data in the table on the "many" side.
*/


/*  
Insert data into the TEAMS table
*/

INSERT INTO teams 
  (teamID, team_name, project)
  VALUES ('SWDES','Southwest Designers','Inventory tracking for tire company');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('SOFTCON','Software Consultants','Sales order processing for retail business');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('ITPROS','IT Professionals','Project management and activity tracking');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('TECHSO','Technology Solutions','Production management');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('DBMS','DBMS Associates','Art gallery inventory');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('SYSDES','System Designers','Work order processing for auto shop');

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('DEVELOP','Developers, Inc.',NULL);

INSERT INTO teams
  (teamID, team_name, project)
  VALUES ('DIGSOL','Digital Solutions',NULL);


/*  
Insert data into the STUDENTS table
*/

INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('akry','ADRIENNE','kry','ISYS','DEVELOP');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('bkry','BARBARA','kry','ISYS','ITPROS');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('bsmith','BOB','SMITH','ISYS','SYSDES');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('calvarez','CARLOS','ALVAREZ','ISYS','SYSDES');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('cmoya','CYNTHIA','moya','ISYS','TECHSO');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('csanchez','CARLA','SANCHEZ','ISYS',NULL);
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('doliver','DON','OLIVER','ISYS','SYSDES');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('kalt','KENNETH','ALT','ISYS','DEVELOP');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('lkomp','LANCE','KOMP','ISYS','ITPROS');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('sdavis','SARA','DAVIS','ISYS','ITPROS');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('wcronan','WALTER','CRONAN','ISYS','TECHSO');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('tdouglas','TWYLA','DOUGLAS','ISYS','TECHSO');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('troberts','TERRENCE','ROBERTS','ACCT',NULL)
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor,std_teamID)
  VALUES ('aagassi','ANDREW','aagassi','MKTG','ITPROS');
INSERT INTO students
  (stdid, stdfname, stdlname, stdmajor, std_teamID)
  VALUES ('rfederer','RYAN','rfederer','COMPSC','ITPROS');


/*  
Insert data into the EVAL_ITEMS table  
*/

INSERT INTO eval_items
 VALUES('RELIABLE','Reliably meets deadlines.');
INSERT INTO eval_items
 VALUES('CONTRIBUTE','Quality and amount of work done.');
INSERT INTO eval_items
 VALUES('INTERPERS','Works well with others.');



/*  
Insert data into the EVALUATIONS and EVAL_ITEMS_SCORES tables
*/



INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (200,'Fall',2009,'tdouglas','cmoya');
INSERT INTO eval_items_scores
  VALUES(200,'RELIABLE',80);
INSERT INTO eval_items_scores
  VALUES(200,'CONTRIBUTE',75);
INSERT INTO eval_items_scores
  VALUES(200,'INTERPERS',85);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (201,'Fall',2009,'tdouglas','wcronan');
INSERT INTO eval_items_scores
  VALUES(201,'RELIABLE',95);
INSERT INTO eval_items_scores
  VALUES(201,'CONTRIBUTE',95);
INSERT INTO eval_items_scores
  VALUES(201,'INTERPERS',100);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (202,'Spring',2009,'bkry','lkomp');
INSERT INTO eval_items_scores
  VALUES(202,'RELIABLE',85);
INSERT INTO eval_items_scores
  VALUES(202,'CONTRIBUTE',88);
INSERT INTO eval_items_scores
  VALUES(202,'INTERPERS',95);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (203,'Spring',2009,'bkry','sdavis');
INSERT INTO eval_items_scores
  VALUES(203,'RELIABLE',100);
INSERT INTO eval_items_scores
  VALUES(203,'CONTRIBUTE',100);
INSERT INTO eval_items_scores
  VALUES(203,'INTERPERS',100);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (205,'Fall',2009,'calvarez','bsmith');
INSERT INTO eval_items_scores
  VALUES(205,'RELIABLE',88);
INSERT INTO eval_items_scores
  VALUES(205,'CONTRIBUTE',90);
INSERT INTO eval_items_scores
  VALUES(205,'INTERPERS',95);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (206,'Fall',2009,'calvarez','doliver');
INSERT INTO eval_items_scores
  VALUES(206,'RELIABLE',85);
INSERT INTO eval_items_scores
  VALUES(206,'CONTRIBUTE',85);
INSERT INTO eval_items_scores
  VALUES(206,'INTERPERS',80);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (207,'Fall',2009,'wcronan','tdouglas');
INSERT INTO eval_items_scores
  VALUES(207,'RELIABLE',92);
INSERT INTO eval_items_scores
  VALUES(207,'CONTRIBUTE',98);
INSERT INTO eval_items_scores
  VALUES(207,'INTERPERS',90);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (210,'Fall',2009,'wcronan','cmoya');
INSERT INTO eval_items_scores
  VALUES(210,'RELIABLE',75);
INSERT INTO eval_items_scores
  VALUES(210,'CONTRIBUTE',80);
INSERT INTO eval_items_scores
  VALUES(210,'INTERPERS',70);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (211,'Fall',2009,'bsmith','doliver');
INSERT INTO eval_items_scores
  VALUES(211,'RELIABLE',90);
INSERT INTO eval_items_scores
  VALUES(211,'CONTRIBUTE',92);
INSERT INTO eval_items_scores
  VALUES(211,'INTERPERS',95);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (212,'Fall',2009,'doliver','calvarez');
INSERT INTO eval_items_scores
  VALUES(212,'RELIABLE',75);
INSERT INTO eval_items_scores
  VALUES(212,'CONTRIBUTE',70);
INSERT INTO eval_items_scores
  VALUES(212,'INTERPERS',70);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (215,'Fall',2009,'bsmith','calvarez');
INSERT INTO eval_items_scores
  VALUES(215,'RELIABLE',85);
INSERT INTO eval_items_scores
  VALUES(215,'CONTRIBUTE',95);
INSERT INTO eval_items_scores
  VALUES(215,'INTERPERS',90);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (216,'Spring',2009,'lkomp','bkry');
INSERT INTO eval_items_scores
  VALUES(216,'RELIABLE',70);
INSERT INTO eval_items_scores
  VALUES(216,'CONTRIBUTE',80);
INSERT INTO eval_items_scores
  VALUES(216,'INTERPERS',85);


INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (218,'Spring',2009,'lkomp','sdavis');
INSERT INTO eval_items_scores
  VALUES(218,'RELIABLE',95);
INSERT INTO eval_items_scores
  VALUES(218,'CONTRIBUTE',95);
INSERT INTO eval_items_scores
  VALUES(218,'INTERPERS',95);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (219,'Spring',2009,'akry','kalt');
INSERT INTO eval_items_scores
  VALUES(219,'RELIABLE',98);
INSERT INTO eval_items_scores
  VALUES(219,'CONTRIBUTE',90);
INSERT INTO eval_items_scores
  VALUES(219,'INTERPERS',95);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (220,'Spring',2009,'kalt','akry');
INSERT INTO eval_items_scores
  VALUES(220,'RELIABLE',100);
INSERT INTO eval_items_scores
  VALUES(220,'CONTRIBUTE',90);
INSERT INTO eval_items_scores
  VALUES(220,'INTERPERS',90);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (224,'Fall',2009,'doliver','bsmith');
INSERT INTO eval_items_scores
  VALUES(224,'RELIABLE',70);
INSERT INTO eval_items_scores
  VALUES(224,'CONTRIBUTE',66);
INSERT INTO eval_items_scores
  VALUES(224,'INTERPERS',70);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (225,'Spring',2009,'sdavis','lkomp');
INSERT INTO eval_items_scores
  VALUES(225,'RELIABLE',80);
INSERT INTO eval_items_scores
  VALUES(225,'CONTRIBUTE',80);
INSERT INTO eval_items_scores
  VALUES(225,'INTERPERS',80);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (226,'Spring',2009,'sdavis','bkry');
INSERT INTO eval_items_scores
  VALUES(226,'RELIABLE',90);
INSERT INTO eval_items_scores
  VALUES(226,'CONTRIBUTE',90);
INSERT INTO eval_items_scores
  VALUES(226,'INTERPERS',90);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (227,'Fall',2009,'cmoya','wcronan');
INSERT INTO eval_items_scores
  VALUES(227,'RELIABLE',90);
INSERT INTO eval_items_scores
  VALUES(227,'CONTRIBUTE',92);
INSERT INTO eval_items_scores
  VALUES(227,'INTERPERS',95);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (228,'Fall',2009,'cmoya','tdouglas');
INSERT INTO eval_items_scores
  VALUES(228,'RELIABLE',90);
INSERT INTO eval_items_scores
  VALUES(228,'CONTRIBUTE',98);
INSERT INTO eval_items_scores
  VALUES(228,'INTERPERS',90);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (230,'Spring',2009,'aagassi','bkry');
INSERT INTO eval_items_scores
  VALUES(230,'RELIABLE',78);
INSERT INTO eval_items_scores
  VALUES(230,'CONTRIBUTE',70);
INSERT INTO eval_items_scores
  VALUES(230,'INTERPERS',75);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (232,'Spring',2009,'aagassi','lkomp');
INSERT INTO eval_items_scores
  VALUES(232,'RELIABLE',90);
INSERT INTO eval_items_scores
  VALUES(232,'CONTRIBUTE',95);
INSERT INTO eval_items_scores
  VALUES(232,'INTERPERS',90);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (233,'Spring',2009,'aagassi','rfederer');
INSERT INTO eval_items_scores
  VALUES(233,'RELIABLE',75);
INSERT INTO eval_items_scores
  VALUES(233,'CONTRIBUTE',80);
INSERT INTO eval_items_scores
  VALUES(233,'INTERPERS',90);

INSERT INTO evaluations
  (eval_id, evalsemester, evalyear, evaluatorID, evaluateeID)
  VALUES (235,'Spring',2009,'bkry','rfederer');
INSERT INTO eval_items_scores
  VALUES(235,'RELIABLE',85);
INSERT INTO eval_items_scores
  VALUES(235,'CONTRIBUTE',90);
INSERT INTO eval_items_scores
  VALUES(235,'INTERPERS',95);