using oracle

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

using oracle

**Using Oracle: A Guide to SQL Queries**

*Objective:* Write a SQL query to display the item name, price, and company name of all the products.

**Tables Overview**

1. **company_mast**
   - **Columns:**
     - `COM_ID`: Company ID
     - `COM_NAME`: Company Name
   - **Sample Data:**
     - 11: Samsung
     - 12: iBall
     - 13: Epson
     - 14: Zebronics
     - 15: Asus
     - 16: Frontech

2. **item_mast**
   - **Columns:**
     - `PRO_ID`: Product ID
     - `PRO_NAME`: Product Name
     - `PRO_PRICE`: Product Price
     - `PRO_COM`: Product Company ID (links to `COM_ID` in `company_mast`)
   - **Sample Data:**
     - 101: Mother Board, 3200.00, 15
     - 102: Key Board, 450.00, 16
     - 103: ZIP drive, 250.00, 14
     - 104: Speaker, 550.00, 13
     - 105: Monitor, 5000.00, 11

3. **emp_department**
   - **Columns:**
     - `DPT_CODE`: Department Code
     - `DPT_NAME`: Department Name
     - `DPT ALLOTMENT`: Department Allotment
   - **Sample Data:**
     - 57: IT, 65000
     - 63: Finance, 15000
     - 47: HR, 240000

4. **emp_details**
   - **Columns:**
     - `EMP_IDNO`: Employee ID Number
     - `EMP_FNAME`: Employee First Name
     - `EMP_LNAME`: Employee Last Name
     - `EMP_DEPT`: Employee Department Code (links to `DPT_CODE` in `emp_department`)
   - **Sample Data:**
     - 127323: Michale, Robbin, 57
     - 526689: Carlos, Snares, 63
     - 843795: Enric, Dosio, 57

**Contextual Explanation**

This document demonstrates how to retrieve linked data from multiple tables within a database using SQL in Oracle.
Transcribed Image Text:**Using Oracle: A Guide to SQL Queries** *Objective:* Write a SQL query to display the item name, price, and company name of all the products. **Tables Overview** 1. **company_mast** - **Columns:** - `COM_ID`: Company ID - `COM_NAME`: Company Name - **Sample Data:** - 11: Samsung - 12: iBall - 13: Epson - 14: Zebronics - 15: Asus - 16: Frontech 2. **item_mast** - **Columns:** - `PRO_ID`: Product ID - `PRO_NAME`: Product Name - `PRO_PRICE`: Product Price - `PRO_COM`: Product Company ID (links to `COM_ID` in `company_mast`) - **Sample Data:** - 101: Mother Board, 3200.00, 15 - 102: Key Board, 450.00, 16 - 103: ZIP drive, 250.00, 14 - 104: Speaker, 550.00, 13 - 105: Monitor, 5000.00, 11 3. **emp_department** - **Columns:** - `DPT_CODE`: Department Code - `DPT_NAME`: Department Name - `DPT ALLOTMENT`: Department Allotment - **Sample Data:** - 57: IT, 65000 - 63: Finance, 15000 - 47: HR, 240000 4. **emp_details** - **Columns:** - `EMP_IDNO`: Employee ID Number - `EMP_FNAME`: Employee First Name - `EMP_LNAME`: Employee Last Name - `EMP_DEPT`: Employee Department Code (links to `DPT_CODE` in `emp_department`) - **Sample Data:** - 127323: Michale, Robbin, 57 - 526689: Carlos, Snares, 63 - 843795: Enric, Dosio, 57 **Contextual Explanation** This document demonstrates how to retrieve linked data from multiple tables within a database using SQL in Oracle.
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Database Environment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education