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: 85% (7 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...
-
Chuck has 140 ft of fencing in which he wants to fence in two connecting, adjacent square pens with fencing between the two pens (see the figure). What will be the dimensions if the length of the...
-
Describe the various court rulings involving PPACA.
-
Consider the following time series data: Using the nave method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b....
-
What is a fair price of a 28-year semi-annual coupon bond, with a coupon rate of 5.15%, a face value of $1000, and a yield-to-maturity of 9.81%? What is the yield?
-
In preparing for next year, Tony Freedman has hired two employees to work on an hourly basis assisting with some troubleshooting and repair work. Assume the following details: a. The following...
-
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?
-
Anne is a reporter for Daily Business Journal, a print publication consulted by investors and other businesspersons. She often uses the Internet to conduct research for the articles that she writes...
-
Kashickey College, an institution considered to be governmental in nature, had the following events occur during the year: Tuition scholarships of $45,000 were granted during the year and $7,500 of...
-
When is fully reserving fund balance for inventory appropriate? Explain.
-
Loans to an Internal Service Fund from another fund are reported in the Internal Service Fund cash flow statement as a. cash flows from operating activities. b. cash flows from noncapital financing...
-
GAAP require the use of an Internal Service Fund for which of the following activities? a. Self-insurance. b. Central garage. c. Landfill operations. d. Warehouse facility. e. All of the above. f....
-
The earnings of an endowment (nonexpendable as to corpus) Trust Fund are used to support the operation of a not-for-profit museum, art gallery, and park complex. Should these earnings be accounted...
-
How would data be collected for each element, and how might management at JC Penney utilize that data to provide loyal customers with a very strong relationship with the firm?
-
1. What are some current issues facing Saudi Arabia? What is the climate for doing business in Saudi Arabia today? 2. Is it legal for Auger's firm to make a payment of $100,000 to help ensure this...
-
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...
-
What is one way in which a leader can apply the "Status" part of the SCARF model to trigger the "Reward" response?
-
Complete the table to assess risks and develop contingencies for resources you are planning for. Potential risks Planned Response Risk associated with the acquisition or implementation of the...
-
Assignment: persuasive essay for or against Andrew Jackson. In you essay answer the question "Was he a "people's president" or was he more like a king?" Documentary:...
Study smarter with the SolutionInn App