# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

3 Pages

### hw4sol

Course: CS 235, Fall 2009
School: Concordia Chicago
Rating:

Word Count: 378

#### Document Preview

4 Assignment Problem Set 1.(a) UPDATE Ingredients SET quantity = 16 WHERE ingredient = butter AND quantity &gt; 16; (b) DELETE FROM Ingredients WHERE ingredient = pork AND food IN (SELECT food FROM Dish WHERE cuisine = Arab); (c) INSERT INTO ShoppingList SELECT d.cuisine, i.ingredient, SUM(i.quantity) FROM Dish d, Ingredient i WHERE d.food = i.food GROUP BY d.cuisine, i.ingredient; (d) 2.(a) SELECT * FROM...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Illinois >> Concordia Chicago >> CS 235

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
4 Assignment Problem Set 1.(a) UPDATE Ingredients SET quantity = 16 WHERE ingredient = butter AND quantity > 16; (b) DELETE FROM Ingredients WHERE ingredient = pork AND food IN (SELECT food FROM Dish WHERE cuisine = Arab); (c) INSERT INTO ShoppingList SELECT d.cuisine, i.ingredient, SUM(i.quantity) FROM Dish d, Ingredient i WHERE d.food = i.food GROUP BY d.cuisine, i.ingredient; (d) 2.(a) SELECT * FROM Employee E1 WHERE salary >= ALL (SELECT salary FROM Employee E2 WHERE E2.manager=E1.manager) OR salary <= ALL (SELECT salary FROM Employee E2 WHERE E2.manager=E1.manager); (b) SELECT location, AVG(salary) FROM Employee GROUP BY location; (c) SELECT manager FROM Employee E1 GROUP BY manager HAVING COUNT(DISTINCT location)>2; (d) SELECT manager, SUM(salary) FROM Employee GROUP BY manager; 3.(a) SELECT owner FROM Cars WHERE owner NOT IN (SELECT owner FROM Motorcycle); (b) SELECT owner, COUNT(*) FROM Cars GROUP BY owner; (c) INSERT INTO Ownership (SELECT c.owner, COUNT(DISTINCT c.license), COUNT(DISTINCT m.license) FROM Cars c, Motorcycle m WHERE c.owner=m.owner GROUP BY c.owner) UNION (SELECT c.owner, COUNT(*), 0 FROM Cars c WHERE c.owner NOT (SELECT IN owner FROM Motorcycle) GROUP BY c.owner) UNION (SELECT m.owner, 0, COUNT(*) FROM Motorcycle m WHERE m.owner NOT IN (SELECT owner FROM Cars) GROUP BY m.owner); 4.(a) SELECT course FROM Instructors WHERE instructor = Prof. Smith; (b) SELECT instructor, COUNT(*) FROM Instructors GROUP BY instructor; (c) SELECT instuctor, COUNT(DISTINCT course) FROM Instructors GROUP BY instructor; 5.(a) SELECT t.student FROM Transcript t, Instuctors i WHERE t.course = i.course AND t.quarter = i.quarter AND i.instructor = Prof. Smith; (b) SELECT student FROM Transcript t WHERE NOT EXISTS (SELECT course FROM Instructors WHERE instructor = Prof. Smith AND course NOT IN (SELECT course FROM Transcript WHER...

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Concordia Chicago - CS - 235
Solutions to Problem Set 5 Problem 1. CREATE TABLE Teams ( name CHAR(30) PRIMARY KEY, country CHAR(30), fanLevel CHAR(5) CHECK (fanLevel in (wild, timid), CHECK (country &lt;&gt; Brazil OR fanLevel = wild) ); CREATE TABLE Players ( name CHAR(30) PRIMARY KE
Concordia Chicago - CS - 235
CS 235 Midterm ExaminationThursday, November 1, 2001, 1:30-2:50pmDirectionsThe exam is open book/notes; any written material may be used. There are 7 questions in this exam plus one extra credit question. You have 80 minutes; there are 75 points +
Concordia Chicago - CS - 235
CMSC 235 Midterm SolutionsProblem 1: (a) The relational schema consists of the following 5 relations: A(a,b,c) B(c,d) C(e,f) S(c,e,f) T(a,c,e,f) (b) The following FDs hold: For A: ac b; For B: c d; For C: none; For S: c ef, ef c; For T ac ef; P
Concordia Chicago - CS - 235
Administrivia Two handouts today:CMSC 235: Introduction to DatabasesSvetlozar NestorovCourse details Course survey Latest info will always be online! Come to class! Ask questions! Give feedback! Have fun!12CMSC 235 Introduction to
Concordia Chicago - CS - 235
Announcements New (better?) room: Ryerson 251. Assignment 1 is out.Due next Thursday (Oct 4) in class. No late exemptions!Entity/Relationship ModelDiagrams to represent designs. Entity like object, = thing. Entity set like class = set of si
Lenoir-Rhyne - ITEM - 0010
TheUnderArmourmen'sShortBoxerJockiscutforacomfortablefitwithminimallegcoverage,offeringalightweightcompressionfit. Thebreathableventmeshperformancepouchgivesyousupportwithoutsacrificingcomfort.HeatGearfabrickeepsyoucool,dry,and comfortable. Features
Concordia Chicago - CS - 105
%!PS-Adobe-2.0 %Creator: dvipsk 5.58f Copyright 1986, 1994 Radical Eye Software %Pages: 17 %PageOrder: Ascend %BoundingBox: 0 0 612 792 %EndComments %DVIPSCommandLine: dvips -f %DVIPSParameters: dpi=300, comments removed %DVIPSSource: TeX output 1998
Pittsburgh - MATH - 1020
Arrington SampleMath 0120 Examination #3 Sample Solutions Name (Print) Signature TA (Circle one) Instructions: 1. Clearly print your name and PeopleSoft number and sign your name in the space above. 2. There are 8 problems, each worth the specified
Pittsburgh - MATH - 1020
Arrington SampleMath 0120 Examination #2 Sample Name (Print) Signature TA (Circle one) Instructions:1. Clearly print your name and PeopleSoft number and sign your name in the spacePeopleSoft # Score ..above. 2. There are 7 problems, each wor
CofC - RM - 205
SIGMA-ALDRICH MATERIAL SAFETY DATA SHEET Date Printed: 07/14/2006 Date Updated: 01/31/2006 Version 1.4 Section 1 - Product and Company Information Product Name Product Number Brand Company Address Technical Phone: Fax: Emergency Phone: 5,5'-DITHIO-BI
Concordia Chicago - CS - 101
Computer Science 101: Introduction to the World Wide Web Winter 2000Website: This course, being a web course, will rely heavily on web updates. There is a class website which you should check daily. You're responsible for the info there. http:/www.
UCLA - ATS - 9157033
clozapine (6931)alprazolam (1802)clomipramine (3121)diazepam (20652)uoxetine (7345)imipramine (11088)olanzapine (3549)paroxetine (3513)211 9306risperidone (4058)35 3704sertraline (2276)36 4579uvoxamine 45 7443 (1937)schizo
UCLA - ATS - 9157033
comorbid clomipramine &amp; schizophr. (3121) (557)uoxetine (7345)panic disorder (6323)stress disorder (6897)schizoaffective (2586)alprazolam (1802)clozapine (6931)diazepam (20652)imipramine (11088)633 10529239 4819579 87031018 93
Concordia Chicago - CS - 222
VeriWell Users Guide 3.0PreliminaryWellspring Solutions, Inc. 7 Tudor Dr, Suite 300 Salem, NH. 03079 (603) 898-1100 Fax: (603) 893-8058 info@wellspring.com http:/www.wellspring.comVeriWell Users Guide 3.0Copyright 1998 Wellspring Solutions, In
Pittsburgh - AEI - 9257
Wisconsin Milwaukee - LIB - 567
&quot;grea13031,30147,918,5713&quot;grea37052,12358,946,6130-shinin49750,53135,548,74432132214,57771,768,1501:39909,37526,603,187a26439,31629,576,896a42682,31629,603,917a56006,12673,589,875a56006,11466,603,896a34800,38706,589,917a^ou30150,
UCCS - CS - 526
IP Virtual Server version 1.2.1 (size=4096)Prot LocalAddress:Port Scheduler Flags -&gt; RemoteAddress:Port Forward Weight ActiveConn InActConnTCP 128.198.61.116:www rr -&gt; 128.198.61.57:www Route 1 0 4 -&gt; 12
UCCS - CS - 526
This is ApacheBench, Version 2.3 &lt;\$Revision: 655654 \$&gt;Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Licensed to The Apache Software Foundation, http:/www.apache.org/Benchmarking 128.198.61.116 (be patient)Server Softwa
UCCS - CS - 526
This is ApacheBench, Version 2.3 &lt;\$Revision: 655654 \$&gt;Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Licensed to The Apache Software Foundation, http:/www.apache.org/Benchmarking 128.198.61.41 (be patient)Server Softwar
UCCS - CS - 526
This is ApacheBench, Version 2.3 &lt;\$Revision: 655654 \$&gt;Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Licensed to The Apache Software Foundation, http:/www.apache.org/Benchmarking 128.198.61.42 (be patient)Server Softwar
Pittsburgh - IS - 1044
Types of Information Quantitative Continuous : speedometer Discrete Qualitative Status Warning RepresentationalTypes of Information (cont) Identification Alphanumeric/symbolic Time PhasedAbsolute judgment demo hereStimulus Response
UCCS - CS - 526
This is ApacheBench, Version 2.3 &lt;\$Revision: 655654 \$&gt;Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Licensed to The Apache Software Foundation, http:/www.apache.org/Benchmarking 128.198.61.57 (be patient)Server Softwar
UCCS - CS - 526
Eustace AsanghanwaCS 526 Homework #2 Responses to specific questions within homework exercise Notes: Homework site has been created and is located at http:/cs.uccs.edu/~easangha/cs526/HW/HW2/hw2.html. Details of homework execise activities is incl
UCCS - CS - 526
Eustace AsanghanwaCS 526 Homework #2 Responses to specific questions within homework exercise Notes: Homework site has been created and is located at http:/cs.uccs.edu/~easangha/cs526/HW/HW2/hw2.html. Details of homework execise activities is incl
UCCS - CS - 526
This is ApacheBench, Version 2.0.40-dev &lt;\$Revision: 1.146 \$&gt; apache-2.0Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Copyright 2006 The Apache Software Foundation, http:/www.apache.org/Benchmarking blanca.uccs.edu (be pat
UCCS - CS - 526
This is ApacheBench, Version 2.0.40-dev &lt;\$Revision: 1.146 \$&gt; apache-2.0Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Copyright 2006 The Apache Software Foundation, http:/www.apache.org/Benchmarking blanca.uccs.edu (be pat
UCCS - CS - 526
This is ApacheBench, Version 2.0.40-dev &lt;\$Revision: 1.146 \$&gt; apache-2.0Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Copyright 2006 The Apache Software Foundation, http:/www.apache.org/Benchmarking viva.uccs.edu (be patie
UCCS - CS - 526
This is ApacheBench, Version 2.0.40-dev &lt;\$Revision: 1.146 \$&gt; apache-2.0Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Copyright 2006 The Apache Software Foundation, http:/www.apache.org/Benchmarking windom.uccs.edu (be pat
UCCS - CS - 526
128.198.16.39 - - [15/Feb/2009:17:25:04 -0700] &quot;GET http:/blanca.uccs.edu:8414/ HTTP/1.1&quot; 304 -128.198.16.39 - - [15/Feb/2009:17:25:16 -0700] &quot;GET http:/shavano.uccs.edu:8414/ HTTP/1.1&quot; 304 -128.198.16.39 - - [15/Feb/2009:17:25:30 -0700] &quot;GET http:
UCCS - CS - 526
128.198.162.63 - - [15/Feb/2009:18:07:53 -0700] &quot;GET /eng/eng.html HTTP/1.1&quot; 200 112128.198.162.63 - - [15/Feb/2009:18:07:53 -0700] &quot;GET /favicon.ico HTTP/1.1&quot; 404 209128.198.162.63 - - [15/Feb/2009:18:08:13 -0700] &quot;GET /sales/sales.html HTTP/1.1&quot;
UCCS - CS - 526
This is ApacheBench, Version 2.0.40-dev &lt;\$Revision: 1.146 \$&gt; apache-2.0Copyright 1996 Adam Twiss, Zeus Technology Ltd, http:/www.zeustech.net/Copyright 2006 The Apache Software Foundation, http:/www.apache.org/Benchmarking www.uccs.edu (be patien
Wisconsin - ENGR - 340
Structural Deformation Demonstration Project CEE 340 Group No. 1 Names Group No. Names Nichols , Ryan 6 Christenson, Charles Hardin, Jan Driscoll, Kevin Griesbach, David Clayton, Adam Jensen, James Salerno, Jeff Rewey, Becky 7 Fredrickson, Marc Water
University of Florida - COT - 3100
Supplemental ExercisesHere are some review questions that you can work to help prepare for the exam. (1) Question 3 from the book, page 114. (2) Questions 16 and 17 from the book, on page 115. (2) Questions 26, 27, and 28 from the book, on page 116.
Clayton - PROJECT - 14848
Landmark Church of GodProject description and Scope By Tonya EthertonLandmark Church of God Presenter-Ellison Brannon Stewards-Ellison Brannon, RebeccaBrannon, Shelby Richardson Designers-Tonya EthertonLandmark Church of God Goals - To le
Clayton - PROJECT - 14848
Graphics Requirements The Landmark Church of God website will have several graphical requirements. The first one that will be met involves the logo for the church. It is a symbol of the cross with a sort of circle drawn around it. It will be reproduc
Wisconsin - ENGR - 310
8.4:The AV (atrioventricular) node delays the wave of excitation though the heart for about 0.1 s. This ensures that the atria will contract fully and empty maximal blood into the ventricles before the ventricles contract. If it wasnt there, not al
Pittsburgh - AEI - 10495
Pittsburgh - AEI - 7828
Cal Poly - INF - 6900
GRILLE D'VALUATIONNOM DE L'ORATEUR NOM DE L'OBSERVATEUR1 1 2 3 4 5 6 7TRS FAIBLE2 FAIBLE contact objectifs dfinitions rappel du plan simplicit pertinence porte de la voix dbit3 BONFORME4 TRS BON5 EXCELLENTINTRODUCTION annonc
Cal Poly - INF - 6900
IntroductionINF6900:Communicationscientifiqueettechnique hiver2003Pourquoicommuniquer?Lardactionscientifiqueestlarecherche scientifiquecequelecouproulestaugolf. Savoircommuniquerdefaonefficaceesttrs importantpourvotrecarrire(scientifiqueou tec
Cal Poly - INF - 6900
IntroductionINF6900: Communication scientifique et technique hiver 2003Pourquoi communiquer?La rdaction scientifique est la recherche scientifique ce que le coup roul est au golf.Savoir communiquer de faon efficace est trs important pour
Cal Poly - INF - 6900
%!PS-Adobe-3.0 %Pages: 3 0 %BoundingBox: 0 0 582 740 %HiResBoundingBox: 0.000000 0.000000 581.100000 739.895337 %. %Creator: GNU Ghostscript 707 (pswrite) %CreationDate: 2007/01/11 15:22:51 %DocumentData: Clean7Bit %LanguageLevel: 2 %EndComments %Beg
Cal Poly - INF - 6900
criture mathmatiqueINF6900: Communication scientifique et technique hiver 2003La place des mathmatiques Notre confiance en toute science est peu prs proportionnelle la quantit de mathmatiques quelle emploie. tre capable de formuler ses
Cal Poly - INF - 6900
criture mathmatiqueINF6900: Communication scientifique et technique hiver 2003La place des mathmatiques Notre confiance en toute science est peu prs proportionnelle la quantit de mathmatiques quelle emploie. tre capable de formuler ses
Cal Poly - INF - 6900
%!PS-Adobe-3.0 %Pages: 2 0 %BoundingBox: 0 0 573 736 %HiResBoundingBox: 0.000000 0.000000 572.000024 735.323535 %. %Creator: GNU Ghostscript 707 (pswrite) %CreationDate: 2007/01/11 15:22:53 %DocumentData: Clean7Bit %LanguageLevel: 2 %EndComments %Beg
Cal Poly - INF - 6900
CommunicationcriteINF6900:Communicationscientifiqueettechnique hiver2003Unpeud'histoire.Premierlivre:rcitduDlugevers4000av.J.C. Papyrus(2000av.J.C.),papier(150denotrere) Pressed'imprimerie(Gutenberg,1455) Premiresrevuesscientifiques(1655)
Cal Poly - INF - 6900
Communication criteINF6900: Communication scientifique et technique hiver 2003Un peu dhistoire.Premier livre: rcit du Dluge vers 4000 av. J.C.Papyrus (2000 av. J.C.), papier (150 de notre re)Presse dimprimerie (Gutenberg, 1455)Pre
Cal Poly - INF - 6900
Communication oraleINF6900: Communication scientifique et technique automne 2002Quel est lobjectif de ma prsentation?Une publicit pour larticleQui est mon auditeur cible?Comment sassurer de capter son attention?Quelle est la meill
Cal Poly - INF - 6900
Communication oraleINF6900: Communication scientifique et technique automne 2002Quel est lobjectif de ma prsentation?Une publicit pour larticleQui est mon auditeur cible?Comment sassurer de capter son attention?Quelle est la meill
Cal Poly - INF - 6900
%!PS-Adobe-3.0 %Pages: 4 0 %BoundingBox: 0 0 574 746 %HiResBoundingBox: 0.000000 0.000000 573.200000 745.495337 %. %Creator: GNU Ghostscript 707 (pswrite) %CreationDate: 2007/01/11 15:22:55 %DocumentData: Clean7Bit %LanguageLevel: 2 %EndComments %Beg
Cal Poly - INF - 6900
valuation critique par les pairsINF6900: Communication scientifique et technique automne 2002Pourquoi?Sceau de qualit scientifiquePour le lecteurPour votre institutionPour les organismes subventionnairesPrincipaux intervenants
Cal Poly - INF - 6900
valuation critique par les pairsINF6900: Communication scientifique et technique automne 2002Pourquoi?Sceau de qualit scientifiquePour le lecteurPour votre institutionPour les organismes subventionnairesPrincipaux intervenants
Cal Poly - INF - 6900
%!PS-Adobe-3.0 %Pages: 2 0 %BoundingBox: 0 0 573 734 %HiResBoundingBox: 0.000000 0.000000 572.200049 733.582788 %. %Creator: GNU Ghostscript 707 (pswrite) %CreationDate: 2007/01/11 15:22:50 %DocumentData: Clean7Bit %LanguageLevel: 2 %EndComments %Beg
Wisconsin - STAT - 371
STATISTICS 371Topics1. Condence Interval for (1 2 ) (Page 227) constructed as y t.025 SEy Analogously, a 95% condence interval for (1 2 ) is constructed as (1 y2 ) t.025 SE(1 y2 ) y y Apr-01-2009A 95% condence interval for the mean of
Pittsburgh - AEI - 10289
Pittsburgh - AEI - 8969
European Defence in the wake of the Lisbon TreatyEGMONT PAPER 21EUROPEAN DEFENCE IN THE WAKE OF THE LISBON TREATYBruno ANGELET &amp; Ioannis VRAILASMay 2008The Egmont Papers are published by Academia Press for Egmont The Royal Institute for Int
Pittsburgh - AEI - 4031
Pittsburgh - AEI - 1395
THE EUROPEAN COUNCILSTRASBOURG 9 DECEMBER 1989Documents in the dossier include:and December European Council, Strasbourg, Reproduced from the Bulletin of the European Communities , No. 12/1989E.C.Leaders Firmly Support Monetary Union , the
Stanford - HUMP - 1017
US District Court Civil Docket as of 07/13/2001 Retrieved from the court on Friday, August 04, 2006U.S. District Court District of Maryland (Baltimore)CIVIL DOCKET FOR CASE #: 1:01-cv-01703-WMNGaines v. Humphrey Hospitality, et al Assigned to: J
Stanford - MCK - 1004
m1 2 3 4KIRKLEY &amp; PAYNE, LLP DOROTHY YATES KIRKLEY (Pro Hac Vice App. To Follow) JULIE SCHWARTZ (Pro Hac Vice App. To Follow) 999 Peachtree St., NE Atlanta, GA 30309 Telephone: (404) 892-8781 Facsimile: (404) 892-3662 COOLEY GODWARD LLP PAUL A. R
Stanford - PUBS - 22395