Referring to Appendix A below, code a MySQL statement to display the item number and name for all items.  APPENDIX A – Table definitions and initializations -- MySQL script to initialize a MySQL database and four tables: --   customer, detail, item, salesorder -- DROP DATABASE IF EXISTS finaldb; CREATE DATABASE finaldb; USE finaldb; CREATE TABLE customer (   c_num    varchar(16),   c_name   varchar(128) ); CREATE TABLE detail (   d_onum      varchar(16),   d_inum      varchar(16),   d_qty      int ); CREATE TABLE item (   i_num    varchar(16),   i_name   varchar(128),   i_price  decimal(9,2),   i_qty    int ); CREATE TABLE salesorder (   s_num      varchar(16),   s_cnum     varchar(16),   s_date     date ); INSERT INTO customer VALUES   ('c101','Sam Paint'),   ('c102','Ramon Hardware'),   ('c103','Li Auto'); -- INSERT INTO detail VALUES   ('s201','i301',21),   ('s201','i302',22),   ('s202','i302',23),   ('s202','i303',24),   ('s203','i303',25),   ('s203','i304',26); -- INSERT INTO item VALUES   ('i301','Doormat',6.00,80),   ('i302','Carpet',16.00,81),   ('i303','Air conditioner',160.00,82),   ('i304','Microwave',60.00,83); -- INSERT INTO salesorder VALUES   ('s201','c101','2020-3-11'),   ('s202','c101','2020-3-12'),   ('s203','c102','2020-3-13'); -- -- end of script --

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

Referring to Appendix A below, code a MySQL statement to display the item number and name for all items.
 APPENDIX A – Table definitions and initializations

-- MySQL script to initialize a MySQL database and four tables:
--   customer, detail, item, salesorder
--
DROP DATABASE IF EXISTS finaldb;
CREATE DATABASE finaldb;
USE finaldb;
CREATE TABLE customer (
  c_num    varchar(16),
  c_name   varchar(128)
);
CREATE TABLE detail (
  d_onum      varchar(16),
  d_inum      varchar(16),
  d_qty      int
);
CREATE TABLE item (
  i_num    varchar(16),
  i_name   varchar(128),
  i_price  decimal(9,2),
  i_qty    int
);
CREATE TABLE salesorder (
  s_num      varchar(16),
  s_cnum     varchar(16),
  s_date     date
);
INSERT INTO customer VALUES
  ('c101','Sam Paint'),
  ('c102','Ramon Hardware'),
  ('c103','Li Auto');
--
INSERT INTO detail VALUES
  ('s201','i301',21),
  ('s201','i302',22),
  ('s202','i302',23),
  ('s202','i303',24),
  ('s203','i303',25),
  ('s203','i304',26);
--
INSERT INTO item VALUES
  ('i301','Doormat',6.00,80),
  ('i302','Carpet',16.00,81),
  ('i303','Air conditioner',160.00,82),
  ('i304','Microwave',60.00,83);
--
INSERT INTO salesorder VALUES
  ('s201','c101','2020-3-11'),
  ('s202','c101','2020-3-12'),
  ('s203','c102','2020-3-13');
--
-- end of script
--

Expert Solution
steps

Step by step

Solved in 5 steps with 5 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.
Similar questions
  • SEE MORE QUESTIONS
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