Query Design

Query Design - William Carter INFO209 501 Query Design and...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
William Carter INFO209 - 501 Query Design and Results Query 1: Query1 Department Department ID Criminal Law d-18 Environmental Law d-13 Human Resources Law d-15 Intellectual Property Law d-16 International Law d-17 Internet Law d-14 Personal Injury Law d-11 Tax Law d-12 05/11/2009
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
William Carter INFO209 - 501 Query 2: Query2 Client Name Address City State Zip Code Walton, Maria 1602 Lake View Drive College Station TX 77843-8901 Walton, Ben 5678 Mount Airy Navasota TX 77812-0123 Williams, Geraldine 1414 Rocky Road Bryan TX 77805-5678 Washington, George 5678 Mount Vernon Snook TX 77755-2345 Webster, Daniel 13579 Spelling Bee Waco TX 77123-2345 05/11/2009
Background image of page 2
William Carter INFO209 - 501 Query 3: Query3 Client Name Lawyer Name Office Date Time Fee Asimov, Isaac Roosevelt, Franklin College Station 01/07/2005 1:00 PM $15,000.00 Bradley, Omar Smith, John College Station 01/15/2005 10:00 AM $19,999.99 Bumstead, Dagwood Brown, Pam College Station 01/15/2005 11:00 AM $15,500.00 Bunker, Edith Clark, John Houston 01/07/2005 2:00 PM $19,500.00 Bunker, Edith Thomas, Doleres Houston 01/30/2006 9:30 AM $25,500.00 Clinton, William Haag, Stephen Houston 01/30/2006 10:30 AM $45,000.00 Dossett, Anthony Brown, Pam College Station 12/17/2003 10:00 AM $20,000.00 Drucker, Peter Roosevelt, Franklin College Station 01/05/2005 10:00 AM $20,000.00 Drucker, Peter Gates, Bill College Station 04/30/2004 10:00 AM $12,000.00 Einstein, Albert Jones, Michael Waco 01/25/2005 10:00 AM $19,000.00 Jefferson, Thomas Gates, Bill College Station 01/18/2005 2:00 PM $18,000.00 MacArthur, Arthur Bunker, Archie College Station 01/08/2005 2:00 PM $19,500.00 Munoz, Jose Jones, Michael Waco 02/15/2004 4:00 PM $30,000.00 Patton, George Clark, John Houston 01/16/2005 11:00 AM $16,000.00 Roosevelt, Theodore Roosevelt, Franklin College Station 01/17/2005 1:00 PM $17,000.00 05/11/2009
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
William Carter INFO209 - 501 Query3 Client Name Lawyer Name Office Date Time Fee Roosevelt, Theodore Bunker, Archie College Station 01/05/2005 11:00 AM $18,500.00 Shapiro, Susan Smith, John College Station 01/24/2004 9:00 AM $24,000.00 Shapiro, Susan Michaels, William Houston 05/31/2004 11:00 AM $9,000.00 Shapiro, Susan Gates, Robert Waco 01/15/2006 9:00 AM $14,000.00 Walton, Ben Thomas, Rosario College Station 01/08/2005 3:00 PM $20,500.00 Walton, Maria Smith, John College Station 03/07/2004 11:00 AM $10,500.00 Washington, George Gates, Bill College Station 01/16/2005 1:00 PM $16,500.00 Washington, George Smith, John College Station 01/06/2005 1:00 PM $17,500.00 Webster, Daniel Gates, Bill College Station 01/06/2005 11:00 AM $10,000.00 Williams, Geraldine Brown, Pam College Station 12/17/2003 2:00 PM $15,500.00 05/11/2009
Background image of page 4
William Carter INFO209 - 501 Query 4: Query4 Lawyer Department Office Salary Bonus Pam Brown Internet Law College Station $100,000.00 $20,000.00 John Smith Environmental Law College Station $100,000.00 $20,000.00 Rosario Thomas Tax Law College Station $95,000.00 $19,000.00 Archie Bunker Human Resources Law
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '07
  • Ammons
  • Law, Theodore Roosevelt, Year of birth missing, Members of the United Kingdom Parliament for English constituencies, English footballers, Houston Houston Houston Houston College Station Houston Houston Houston Houston College Station Houston Houston Houston Houston College Station Houston Houston Houston College Station Houston College Station Houston Houston Houston Houston College Station

{[ snackBarMessage ]}

Page1 / 14

Query Design - William Carter INFO209 501 Query Design and...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online