Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
I am working on Task 4. Task 4: Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Here is my query... CREATE TABLE STATS DISPLAY_OWNER; SELECT I_OWNER_NUM, I_FIRST_NAME, I_LAST_NAME; INSERT INTO OWENR VALUES ('AK102', 'Ceyda', Aksoy); Error...   Expected Results... I_OWNER_NUM I_FIRST_NAME I_LAST_NAME AK102 Ceyda Aksoy

I am working on Task 4. Task 4: Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter). Here is my query... CREATE TABLE STATS DISPLAY_OWNER; SELECT I_OWNER_NUM, I_FIRST_NAME, I_LAST_NAME; INSERT INTO OWENR VALUES ('AK102', 'Ceyda', Aksoy); Error...   Expected Results... I_OWNER_NUM I_FIRST_NAME I_LAST_NAME AK102 Ceyda Aksoy

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

I am working on Task 4.

Task 4: Create the DISPLAY_OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I_OWNER_NUM (provided as a parameter).

Here is my query...

CREATE TABLE STATS DISPLAY_OWNER;
SELECT I_OWNER_NUM, I_FIRST_NAME, I_LAST_NAME;
INSERT INTO OWENR VALUES ('AK102', 'Ceyda', Aksoy);

Error...

 

Expected Results...

I_OWNER_NUM I_FIRST_NAME I_LAST_NAME
AK102 Ceyda

Aksoy

 

 
This table is designed to catalog owner information with specifics about their personal and contact details. Below is a transcription and detailed breakdown of the table contents suitable for inclusion on an educational website. ### Owner Information Table | OWNER_NUM | LAST_NAME | FIRST_NAME | ADDRESS | CITY | STATE | ZIP_CODE | |-----------|-------------|------------|----------------------|------------|-------|----------| | AK102 | Aksoy | Ceyda | 411 Griffin Rd. | Seattle | WA | 98131 | | BI109 | Bianchi | Nicole | 7990 Willow Dr. | New York | NY | 10005 | | BU106 | Burke | Ernest | 613 Old Pleasant St. | Twin Falls | ID | 83303 | | CO103 | Cole | Meerab | 9486 Circle Ave. | Olympia | WA | 98506 | | JO110 | Jones | Ammarah | 730 Military Ave. | Seattle | WA | 98126 | | KO104 | Kowalczyk | Jakub | 7431 S. Bishop St. | Bellingham | WA | 98226 | | LO108 | Lopez | Janine | 9856 Pumpkin Hill Ln.| Everett | WA | 98213 | | MO100 | Moore | Elle-May | 8006 W. Newport Ave. | Reno | NV | 89508 | | PA101 | Patel | Makesh | 7337 Sheffield St. | Seattle | WA | 98119 | | RE107 | Redman | Seth | 7681 Fordham St. | Seattle | WA | 98119 | | SI105 | Sims | Haydon | 527 Primrose Rd. | Portland | OR | 97203 | ### Table Breakdown: - **OWNER_NUM**: This column lists a unique identification code assigned to each owner. - **LAST_NAME**: The surname of the owner. - **FIRST_NAME**: The given name of the owner. - **ADDRESS**: The residential address of the owner. - **CITY**: The city where the owner resides. - **STATE**
Transcribed Image Text:This table is designed to catalog owner information with specifics about their personal and contact details. Below is a transcription and detailed breakdown of the table contents suitable for inclusion on an educational website. ### Owner Information Table | OWNER_NUM | LAST_NAME | FIRST_NAME | ADDRESS | CITY | STATE | ZIP_CODE | |-----------|-------------|------------|----------------------|------------|-------|----------| | AK102 | Aksoy | Ceyda | 411 Griffin Rd. | Seattle | WA | 98131 | | BI109 | Bianchi | Nicole | 7990 Willow Dr. | New York | NY | 10005 | | BU106 | Burke | Ernest | 613 Old Pleasant St. | Twin Falls | ID | 83303 | | CO103 | Cole | Meerab | 9486 Circle Ave. | Olympia | WA | 98506 | | JO110 | Jones | Ammarah | 730 Military Ave. | Seattle | WA | 98126 | | KO104 | Kowalczyk | Jakub | 7431 S. Bishop St. | Bellingham | WA | 98226 | | LO108 | Lopez | Janine | 9856 Pumpkin Hill Ln.| Everett | WA | 98213 | | MO100 | Moore | Elle-May | 8006 W. Newport Ave. | Reno | NV | 89508 | | PA101 | Patel | Makesh | 7337 Sheffield St. | Seattle | WA | 98119 | | RE107 | Redman | Seth | 7681 Fordham St. | Seattle | WA | 98119 | | SI105 | Sims | Haydon | 527 Primrose Rd. | Portland | OR | 97203 | ### Table Breakdown: - **OWNER_NUM**: This column lists a unique identification code assigned to each owner. - **LAST_NAME**: The surname of the owner. - **FIRST_NAME**: The given name of the owner. - **ADDRESS**: The residential address of the owner. - **CITY**: The city where the owner resides. - **STATE**
Expert 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