In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the
Question:
Figure 2-1
Transcribed Image Text:
Rep RepNum LastName FirstName Street Campos Gradey Tian State PostalCode Commission Rate City Rafael 724 Vinca Dr. Grove CA $23,457.50 $41,317.00 $27,789.25 $0.00 15 90092 0.06 Megan Hui 632 Liatris St. Fullton CA 30 90085 0.08 1785 Tyler Ave. 267 Oakley St. Northfield Congaree CA 90098 45 0.06 0.06 Sefton Janet CA 60 90097 Customer Creditlimit RepNum $7,500.00 15 CustomerNum CustomerName Street State PostalCode Balance $1,210.25 City Fullton Toys Galore 28 Laketon St. CA 126 90085 Brookings Direct 452 Columbus Dr. Grove CA 90092 $575.00 $10,000.00 30 260 The Everything Shop Johnson's Department Store 342 Magee St. Congaree CA $2,345.75 $7,500.00 45 334 90097 124 Main St. Northfield CA 90098 $879.25 $7,500.00 30 386 Grove Historical 3456 Central Ave. Fullton CA $345.00 $5,000.00 45 440 90085 Museum Store $5,000.00 15 Cards and More 167 Hale St. Mesa CA $5,025.75 502 90104 Almondton 3345 Devon Ave. Almondton CA $3,456.75 $15,000.00 45 586 90125 General Store Cricket Gift Shop 372 Oxford St. Grove CA 90092 $7,500.00 30 $10,000.00 15 665 $678.90 $4,234.60 12 Rising Sun Ave. Congaree Cress Store CA 713 90097 Unique Gifts 786 Passmore St. Northfield CA $124.75 $7,500.00 45 796 90098 Kline's 945 Gilham St. Mesa CA $2,475.99 $15,000.00 30 824 90104 All Season Gifts 382 Wildwood Ave. Fullton CA 90085 $935.75 $7,500.00 15 893 OrderLine Orders OrderNum OrderDate OrderNum ItemNum NumOrdered QuotedPrice CustomerNum 10/12/2015 51608 CD33 $86.99 51608 126 10/12/2015 $10.95 51610 334 KL78 51610 25 $13.99 10/13/2015 386 TR40 51613 51610 10 $104.95 10/13/2015 DL51 51614 260 51613 FD11 $124.95 10/15/2015 51614 51617 586 $115.99 10/15/2015 NL89 51619 126 51617 4. $116.95 51623 10/15/2015 TW35 586 51617 $121.95 10/16/2015 FD11 51625 796 51619 $29.95 $36.95 S13.10 DR67 51623 51623 FH24 12 KD34 51623 10 $45.79 MT03 51625 Item OnHand Category Storehouse Price ItemNum Description Patience 9 GME АН74 $22.99 BR23 Skittles 21 GME $29.99 Wood Block Set (48 piece) 36 TOY 12 TOY CD33 $89.49 DL51 Classic Railway Set $107.95 DR67 Giant Star Brain Teaser 24 PZL $31.95 DW23 Mancala 40 GME $50.00 FD11 Rocking Horse 8 TOY 65 PZL. $124.95 FH24 Puzzle Gift Set $38.95 Cribbage St Pentominoes Brain Teaser $75.00 KAI2 56 GME KD34 60 PZL $14.95 KL78 Pick Up Sticks 110 GME $10.95 МТОЗ Zauberkasten Brain Teaser $45.79 45 PZL Wood Block Set (62 piece) NL89 $119.75 32 TOY Tic Tac Toe Fire Engine TR40 75 GME $13.99 TW35 30 TOY $118.95
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 87% (8 reviews)
The Cartesian p...View the full answer
Answered By
JAPHETH KOGEI
Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are:
Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking,
So, I look forward to helping you solve your academic problem.
I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs.
I travel three times a year either to the USA, Europe and around Africa.
As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc).
So, I look forward to tutoring you. I believe that it will be exciting to meet them.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Question Posted:
Students also viewed these Computer science questions
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database...
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results. 1. List the...
-
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...
-
What is the output of the following? A. 1223445 B. 2445 C. 22445 D. 223445 E. 2233445 F. None of the above. public class InitOrder { } {System.out.print("1"); } static System.out.print("2"); } public...
-
Prepare a context diagram and a Level 0 DFD for each of the following situations. a. Prepare and file a tax return with the tax owed to the Internal Revenue Service. b. A customer pays an invoice...
-
In your community, some employers maintain stable workforces at all costs, and others furlough and recall workers seemingly at the drop of a hat. What are the differences in markets, management,...
-
Why should companies use project cash flow rather than accounting income when finding the NPV of a project? AppendixLO1
-
An investor requires a return of 12 percent. A stock sells for $25, it pays a dividend of $1, and the dividends compound annually at 7 percent. Will this investor find the stock attractive? What is...
-
No explanation needed. Just answer is ok. Thanks. Banana Inc. has the following on its balance sheet on December 31, 2021: Preferred Shares, $.40, cumulative, 50,000 issued and outstanding $100,000...
-
Acme Manufacturing currently employs 13 people in its receiving department. Each receiving dock clerk earns $50,000 per year. Each employee can unload up to 200 pallets of inventory per day. It...
-
Which node of the B-tree index contains ROWIDs? a. Branch blocks b. Root block c. Leaf blocks d. None of the above because the primary key is used to identify rows.
-
In Example 23 on page 58, would you get the same result if you performed the PROJECT command before the JOIN command? Why or why not?
-
Describe an experience in which retrieval cues led you to remember something. This experience could include things like returning to a place where your memory was initially formed, being somewhere...
-
firm c has net income of 45,360 , asset turnover of 1.4 and roi 12.6% calculate firms margin,sales and average total assets
-
A poll of 1065 Americans showed that 47.2% of the respondents prefer to watch the news rather than read or listen to it. Use those results with a 0.10 significance level to test the claim that fewer...
-
Garcia Industries uses a cost system that carries direct materials inventory at a standard cost. The controller has established these standards for the cost of one unit: Standard Quantity X Standard...
-
Express the confidence interval 0.255 0.046 in the form of p-E
-
5 28 its Jay Oullette, CEO of Bumper to Bumper Incorporated, anticipates that his company's year-end balance sheet will show current assets of $12,801 and current liabilities of $7,540. Oullette has...
-
In each case, determine the moment about point O. (a) (b) -3m- 500 N 5 |--1m- T 1 m
-
How is use of the word consistent helpful in fraud reports?
-
Consider a Student table containing StudentNum, StudentName, students StudentMajor, students AdvisorNum, students AdvisorName, students AdvisorOfficeNum, students AdvisorPhone, students NumCredits,...
-
Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an...
-
Again, using your knowledge of the college environment, determine the functional or multivalued dependencies that exist in the following table. After determining the functional dependencies, convert...
-
Smile Company makes baked goods. The budgeted sales are $620,000, budgeted variable costs are $260,400, and budgeted fixed costs are $237,800. What is the budgeted operating income?
-
Analysis of a replacement project At times firms will need to decide if they want to continue to use their current equipment or replace the equipment with newer equipment. In this case, the company...
-
Required information Skip to question [ The following information applies to the questions displayed below. ] Forten Company's current year income statement, comparative balance sheets, and...
Study smarter with the SolutionInn App