A Guide to SQL, Eighth Edition
Solutions 1-1
Chapter 1: An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group Solutions Answers to Review Questions Due to the nature of the material in Chapter 1, there are no Review Questions.
Answers to Premiere Products Exercises 1. +---------------------------+ | CUSTOMER_NAME | +---------------------------+ | Al's Appliance and Sport | | Ferguson's | | The Everything Shop | | Lee's Sport and Appliance | | Deerfield's Four Seasons | | All Season | +---------------------------+
2.
+-----------+ | ORDER_NUM | +-----------+ | 21617 | | 21623 | +-----------+
3.
+----------+-------------+---------------+ | PART_NUM | DESCRIPTION | ON_HAND_VALUE | +----------+-------------+---------------+ | BV06 | Home Gym | 35772.75 | | KV29 | Treadmill | 12510.00 | +----------+-------------+---------------+
4.
+----------+----------------+ | PART_NUM | DESCRIPTION | +----------+----------------+ | AT94 | Iron | | DL71 | Cordless Drill | | FD21 | Stand Mixer | +----------+----------------+
5.
2
6.
+----------+-------------+-------+ | PART_NUM | DESCRIPTION | PRICE | +----------+-------------+-------+ | AT94 | Iron | 24.95 | +----------+-------------+-------+
7.
+-----------+------------+--------------+----------------------------+