Comp_Data_1_Part3

Hello everyone. This is the third part of our company database. We are still inserting values into the tables.

-----branch_supplier
INSERT INTO branch_supplier VALUES(2, 'Hammer Mill', 'Paper');
INSERT INTO branch_supplier VALUES(2, 'Uni-ball', 'Writing Utensils');
INSERT INTO branch_supplier VALUES(3, 'Patriot Paper', 'Paper');
INSERT INTO branch_supplier VALUES(2, 'J.T. Forms & Labels', 'Custom Forms');
INSERT INTO branch_supplier VALUES(3, 'Uni-ball', 'Writing Utensils');
INSERT INTO branch_supplier VALUES(3, 'Hammer Mill', 'Paper');
INSERT INTO branch_supplier VALUES(3, 'Stamford Lables', 'Custom Forms');

----- client
INSERT INTO client VALUES(400, 'Dunmore Highschool', 2);
INSERT INTO client VALUES(401, 'Lackawana Country', 2);
INSERT INTO client VALUES(402, 'FedEx', 3);
INSERT INTO client VALUES(403, 'John Daly Law, LLC', 3);
INSERT INTO client VALUES(404, 'Scranton Whitepages', 2);
INSERT INTO client VALUES(405, 'Times Newspaper', 3);
INSERT INTO client VALUES(406, 'FedEx', 2);


------works_with
INSERT INTO works_with VALUES(105, 400, 55000);
INSERT INTO works_with VALUES(102, 401, 267000);
INSERT INTO works_with VALUES(108, 402, 22500);
INSERT INTO works_with VALUES(107, 403, 5000);
INSERT INTO works_with VALUES(108, 403, 12000);
INSERT INTO works_with VALUES(105, 404, 33000);
INSERT INTO works_with VALUES(107, 405, 26000);
INSERT INTO works_with VALUES(102, 406, 15000);
INSERT INTO works_with VALUES(105, 406, 130000);


#####The branch_supplier table looks like-

branch_id	  supplier_name	          supply_type
2	          Hammer Mill	            Paper
2	          J.T. Forms & Labels	    Custom Forms
2	          Uni-ball	              Writing Utensils
3	          Hammer Mill	            Paper
3	          Patriot Paper	          Paper
3	          Stamford Lables	        Custom Forms
3	          Uni-ball	              Writing Utensils


#####The client table looks like-

client_id	  client_name	              branch_id
400	        Dunmore Highschool	      2
401	        Lackawana Country	        2
402	        FedEx	                    3
403	        John Daly Law, LLC	      3
404	        Scranton Whitepages	      2
405	        Times Newspaper	          3
406	        FedEx	                    2


#####The works_with table looks like-

emp_id	client_id	  total_sales
102	    401	        267000
102	    406	        15000
105	    400	        55000
105	    404	        33000
105	    406	        130000
107	    403	        5000
107	    405	        26000
108	    402	        22500
108	    403	        12000


###### You can run the following commands and see each of our five tables for our database.

SELECT * FROM employee;
SELECT * FROM branch;
SELECT * FROM branch_supplier;
SELECT * FROM client;
SELECT * FROM works_with;