Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
6 rows selected. Problem 5: Determine the output SQL> select from drive: SOL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME - ---- CONTACT STADR CITY ST ZIP DATEFST YRGOAL --- --------------- ------------ ---------- ---------- 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 -- - - - ----- -- -- ------. ------------ 400 Half Way 11111 Stephen Daniels 123 Elm St John Smith Seekonk MA 02345 03-JUL-98 500 Robert Doe 12121 Jennifer Ames Susan Jones SOL> desc donori Name 24 Benefit St Providence RI 02045 24-MAY-97 400 Null? Туре ----- -- -- 24 Benefit St Providence RI 02045 03-JAN-98 22222 Carl Hersey Susan Jonea VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) IDNO NAME STADR VARCHAR2 (10) VARCHAR2 (2) VARCHAR2 (5) DATE NUMBER (7,2) VARCHAR2 (12) CITY IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE -- --- - ZIP ----- ----- ---- - - CONTACT DATEFST YRGOAL CONTACT ---------- 21 Main St 23456 Susan Ash Amy Costa Fall River MA 02720 04-MAR-92 100 33333 Nancy Taylor John Adams SQL> desc donation: Name 26 Oak St Fall River MA 02720 04-MAR-92 150 Null? Туре ----- VARCHAR2 (5) VARCHAR2 (3) ---- IDNO DRIVENO 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa CONTDATE DATE CONTAMT NUMBER (6,2) 6 rowa selected. SOL> desc drive: SOL> select * from donation: Name Null? Туре IDNO DRI CONTDATE -----. DRIVENO ------ ----- CONTAMT VARCHAR2 (3) VARCHAR2 (15) VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) ----- --- ------- -- -- 11111 100 07-JAN-99 25 DRIVENAME 12121 200 23-FEB-99 23456 100 03-MAR-99 40 20 10 DRIVECHAIR LASTYEAR 33333 300 10-MAR-99 THISYEAR 11111 200 12-FEB-98 12121 200 27-MAY-98 100 120 SQL> select name, VEgsoal, SantamtE 2 from donor, donation 3 where donOEidng - donation.idno and sontamt > XEL9al/12; What output would be produced?

6 rows selected. Problem 5: Determine the output SQL> select from drive: SOL> select * from donor: DRI DRIVENAME DRIVECHAIR LASTYEAR THISYEAR IDNO NAME - ---- CONTACT STADR CITY ST ZIP DATEFST YRGOAL --- --------------- ------------ ---------- ---------- 100 Kids Shelter 200 Animal Home 300 Health Aid Ann Smith Linda Grant David Ross 10000 5000 7000 -- - - - ----- -- -- ------. ------------ 400 Half Way 11111 Stephen Daniels 123 Elm St John Smith Seekonk MA 02345 03-JUL-98 500 Robert Doe 12121 Jennifer Ames Susan Jones SOL> desc donori Name 24 Benefit St Providence RI 02045 24-MAY-97 400 Null? Туре ----- -- -- 24 Benefit St Providence RI 02045 03-JAN-98 22222 Carl Hersey Susan Jonea VARCHAR2 (5) VARCHAR2 (15) VARCHAR2 (15) IDNO NAME STADR VARCHAR2 (10) VARCHAR2 (2) VARCHAR2 (5) DATE NUMBER (7,2) VARCHAR2 (12) CITY IDNO NAME STADR CITY ST ZIP DATEFST YRGOAL STATE -- --- - ZIP ----- ----- ---- - - CONTACT DATEFST YRGOAL CONTACT ---------- 21 Main St 23456 Susan Ash Amy Costa Fall River MA 02720 04-MAR-92 100 33333 Nancy Taylor John Adams SQL> desc donation: Name 26 Oak St Fall River MA 02720 04-MAR-92 150 Null? Туре ----- VARCHAR2 (5) VARCHAR2 (3) ---- IDNO DRIVENO 34567 Robert Brooks 36 Pine St Fall River MA 02720 04-APR-98 50 Amy Costa CONTDATE DATE CONTAMT NUMBER (6,2) 6 rowa selected. SOL> desc drive: SOL> select * from donation: Name Null? Туре IDNO DRI CONTDATE -----. DRIVENO ------ ----- CONTAMT VARCHAR2 (3) VARCHAR2 (15) VARCHAR2 (12) NUMBER (8, 2) NUMBER (8, 2) ----- --- ------- -- -- 11111 100 07-JAN-99 25 DRIVENAME 12121 200 23-FEB-99 23456 100 03-MAR-99 40 20 10 DRIVECHAIR LASTYEAR 33333 300 10-MAR-99 THISYEAR 11111 200 12-FEB-98 12121 200 27-MAY-98 100 120 SQL> select name, VEgsoal, SantamtE 2 from donor, donation 3 where donOEidng - donation.idno and sontamt > XEL9al/12; What output would be produced?

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Need tutoring

# Database Output Analysis: Problem 5 ## Objective Determine the output from a series of SQL queries run on a database containing donor, donation, and drive information. ## Database Tables ### Table: Donor - **Columns:** - `IDNO`: Varchar, 5 characters - `NAME`: Varchar, 15 characters - `STADR`: Varchar, 15 characters (Street Address) - `CITY`: Varchar, 10 characters - `STATE`: Varchar, 2 characters - `ZIP`: Varchar, 5 characters - `DATEFST`: Date (Date of First Donation) - `YRGOAL`: Number(7,2) (Yearly Goal) - `CONTACT`: Varchar, 12 characters - **Data Sample:** - Stephen Daniels, ID: 11111, Year Goal: 500 - Jennifer Ames, ID: 12121, Year Goal: 400 - Carl Hersey, ID: 22222, Year Goal: 300 ### Table: Donation - **Columns:** - `IDNO`: Varchar, 5 characters - `DRIVENO`: Varchar, 3 characters - `CONTDTE`: Date (Contribution Date) - `CONTAMT`: Number(6,2) (Contribution Amount) - **Data Sample:** - ID: 11111, Date: 07-JAN-95, Amount: 25 - ID: 12121, Date: 23-FEB-99, Amount: 40 - ID: 23456, Date: 10-MAR-99, Amount: 10 ### Table: Drive - **Columns:** - `DRIVENO`: Varchar, 3 characters - `DRIVENAME`: Varchar, 15 characters - `DRIVECHAIR`: Varchar, 12 characters - `LASTYEAR`: Number, 9 digits - `THISYEAR`: Number, 9 digits - **Data Sample:** - Drive Name: Kids Shelter, Chair: Ann Smith, Last Year: 10000 - Drive Name: Animal Home, Chair: Linda Grant, Last Year: 5000 ## SQL Query and Task The SQL query examines donors
Transcribed Image Text:# Database Output Analysis: Problem 5 ## Objective Determine the output from a series of SQL queries run on a database containing donor, donation, and drive information. ## Database Tables ### Table: Donor - **Columns:** - `IDNO`: Varchar, 5 characters - `NAME`: Varchar, 15 characters - `STADR`: Varchar, 15 characters (Street Address) - `CITY`: Varchar, 10 characters - `STATE`: Varchar, 2 characters - `ZIP`: Varchar, 5 characters - `DATEFST`: Date (Date of First Donation) - `YRGOAL`: Number(7,2) (Yearly Goal) - `CONTACT`: Varchar, 12 characters - **Data Sample:** - Stephen Daniels, ID: 11111, Year Goal: 500 - Jennifer Ames, ID: 12121, Year Goal: 400 - Carl Hersey, ID: 22222, Year Goal: 300 ### Table: Donation - **Columns:** - `IDNO`: Varchar, 5 characters - `DRIVENO`: Varchar, 3 characters - `CONTDTE`: Date (Contribution Date) - `CONTAMT`: Number(6,2) (Contribution Amount) - **Data Sample:** - ID: 11111, Date: 07-JAN-95, Amount: 25 - ID: 12121, Date: 23-FEB-99, Amount: 40 - ID: 23456, Date: 10-MAR-99, Amount: 10 ### Table: Drive - **Columns:** - `DRIVENO`: Varchar, 3 characters - `DRIVENAME`: Varchar, 15 characters - `DRIVECHAIR`: Varchar, 12 characters - `LASTYEAR`: Number, 9 digits - `THISYEAR`: Number, 9 digits - **Data Sample:** - Drive Name: Kids Shelter, Chair: Ann Smith, Last Year: 10000 - Drive Name: Animal Home, Chair: Linda Grant, Last Year: 5000 ## SQL Query and Task The SQL query examines donors
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS