An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group Solutions
Essay by samsimon • May 3, 2016 • Coursework • 5,166 Words (21 Pages) • 1,413 Views
Essay Preview: An Introduction to Premiere Products, Henry Books, and Alexamara Marina Group Solutions
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.
+-----------+------------+--------------+----------------------------+
| ORDER_NUM | ORDER_DATE | CUSTOMER_NUM | CUSTOMER_NAME |
+-----------+------------+--------------+----------------------------+
| 21608 | 2010-10-20 | 148 | Al's Appliance and Sport |
| 21610 | 2010-10-20 | 356 | Ferguson's |
| 21613 | 2010-10-21 | 408 | The Everything Shop |
| 21614 | 2010-10-21 | 282 | Brookings Direct |
| 21617 | 2010-10-23 | 608 | Johnson's Department Store |
| 21619 | 2010-10-23 | 148 | Al's Appliance and Sport |
| 21623 | 2010-10-23 | 608 | Johnson's Department Store |
+-----------+------------+--------------+----------------------------+
8.
+-----------+--------------+---------------------+
| ORDER_NUM | CUSTOMER_NUM | CUSTOMER_NAME |
+-----------+--------------+---------------------+
| 21613 | 408 | The Everything Shop |
| 21614 | 282 | Brookings Direct |
+-----------+--------------+---------------------+
9.
+---------+------------+-----------+
| REP_NUM | FIRST_NAME | LAST_NAME |
+---------+------------+-----------+
| 35 | Richard | Hull |
| 65 | Juan | Perez |
+---------+------------+-----------+
10.
+-----------+----------+-------------+-------+
| ORDER_NUM | PART_NUM | DESCRIPTION | CLASS |
+-----------+----------+-------------+-------+
| 21613 | KL62 | Dryer | AP |
| 21614 | KT03 | Dishwasher | AP |
+-----------+----------+-------------+-------+
Answers to Henry Books Exercises
1.
+--------------------------+
| PUBLISHER_NAME |
+--------------------------+
| Arcade Publishing |
| Back Bay Books |
| Fawcett Books |
| Farrar Straus and Giroux |
| HarperCollins Publishers |
| Jove Publications |
| Lb Books |
| Penguin USA |
| Plume |
| Putnam Publishing Group |
| Random House |
| Schoken Books |
| Scribner |
| Simon and Schuster |
| Scholastic Trade |
| Tor Books |
| Thames and Hudson |
| Vintage Books |
| W.W. Norton |
+--------------------------+
2.
+-----------------+
| BRANCH_NAME |
+-----------------+
| Henry Downtown |
| Henry Brentwood |
| Henry Eastshore |
+-----------------+
3.
+-----------+------------------------+
| BOOK_CODE | TITLE |
+-----------+------------------------+
| 0200 | The Stranger |
| 138X | Beloved |
| 2766 | Of Mice and Men |
| 3743 | Nine Stories |
| 5790 | Catch-22 |
| 6128 | Jazz |
| 6908 | Franny and Zooey |
| 7405 | East of Eden |
| 7559 | The Fall |
| 9627 | Song of Solomon |
...
...