![Pearson eText for Modern Database Management -- Instant Access (Pearson+)](https://www.bartleby.com/isbn_cover_images/9780137305940/9780137305940_largeCoverImage.gif)
Concept explainers
Refer to Figure 4-5 0. For each of the following reports (with sample data), indicate any indexes that you feel would help the report run faster as well as the type of index:
a. State, by products (user-specified period)
State, by Products Report, January 1, 2018, to March 31, 2018
State |
Product Description |
Total Quantity Ordered |
CO |
8-Drawer Dresser |
1 |
CO |
Entertainment Center |
0 |
co |
Oak Computer Desk |
1 |
co |
Writer’s Desk |
2 |
NY |
Writer’s Desk |
1 |
VA |
Writer’s Desk |
5 |
b. Most frequently sold product finish in a user-specified month
Most Frequently Sold Product Finish Report, March 1, 2018, to March 31, 2018
Product Finish |
Units Sold |
Cherry |
13 |
c. All orders placed last month
Monthly Order Report, March 1, 2018, to March 31, 2018
Order Id |
Order Date |
Customer Id |
Customer Name |
19 |
3/5/18 |
4 |
Eastern Furniture |
Associated Order Details
Product Description | Quantity Ordered | Price | Extended Price |
Cherry End Table |
10 |
$75.00 |
$750.00 |
High Back Leather Chair |
5 |
$362.00 |
$1,810.00 |
Order Id | Order Date | Customer Ids | Customer Name |
24 |
3/10/18 |
1 |
Contemporary Casuals |
Associated Order Details
Product Description | Quantity Ordered | Price | Extended Price |
Bookcase |
4 |
$69.00 |
$276.00 |
d. Total products sold, by product line (user-specified period)
Products Sold by Product Line, March 1, 2018, to March 31, 2018
Product Line | Quantity Sold |
Basic |
200 |
Antique |
15 |
Modern |
10 |
Classical |
75 |
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 8 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
- Modify the CHARTER table to add the attributes shown in the following table. TABLE P8.37 ATTRIBUTES AND VALUES FOR PROBLEM 37 ATTRIBUTE NAME ATTRIBUTE DESCRIPTION ATTRIBUTE TYPE CHAR_WAIT_CHG Waiting charge for each model (copied from the MODEL table) Numeric CHAR_FLT_CHG_HR Flight charge per mile for each model (copied from the MODEL table using the MOD_CHG_MILE attribute) Numeric CHAR_FLT_CHG Flight charge (calculated by CHAR_HOURS_FLOWN CHAR_FLT_CHG_HR) Numeric CHAR_TAX_CHG CHAR_FLT_CHG tax rate (8%) Numeric CHAR_TOT_CHG CHAR_FLT_CHG + CHAR_TAX_CHG Numeric CHAR_PYMT Amount paid by customer Numeric CHAR_BALANCE Balance remaining after payment Numericarrow_forwardEnsure that the only legal values for the BDRMS column in the CONDO_UNIT table are 1, 2, or 3.arrow_forwardCreate a table named REP_CONTRACTS containing the columns listed in the following chart A composite PRIMARY KEY constraint including the Rep_ID, Store_ID, and Quarter columns should be assigned. In addition, FOREIGN KEY constraints should be assigned to both the Rep_ID and Store_ID columns.arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)