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...
-
A 30-year maturity bond making annual coupon payments with a coupon rate of 15.5% has duration of 9.96 years. The bond currently sells at a yield to maturity of 10%. Required: a. Find the current...
-
A four-stroke, four-cylinder spark ignition engine has the following data : Piston diameter \(=100 \mathrm{~mm} ;\) Engine runs at a speed of \(800 \mathrm{rpm}\); Length of stroke \(=200...
-
Refer to the Buena School District bus data. a. Conduct a test of hypothesis to reveal whether the mean maintenance cost is equal for each of the bus manufacturers. Use the .01 significance level. b....
-
Two Firefighter/Paramedics who work on opposite shifts have an ongoing personality conflict. One of the paramedics Bill Jones (a 40 year old Army veteran) has come to the supervisor on several...
-
In the investment world, commodities are typically pretty boring. From livestock to grains to steel and other metals, commodities have their ups and downs. But long term, the world will always need...
-
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?
-
A 1.00-g sample of radioactive thorium-228 decays via - decay, and 75 counts are recorded in one day by a detector that has 10.0% efficiency (that is, 10.0% of all events that occur are recorded by...
-
Identify the different sources and types of risks along the supply chain.
-
Which of the following would be a reason a business is structured as a C corporation? a. The corporation can use personal assets of its shareholders to satisfy any business liabilities. b. The...
-
Identify the various documents that are typically associated with an international shipment.
-
What is the amount of net new financing needed for Global?
-
Employment at will is a legal doctrine that states that a. an employee must agree to be terminated. b. an employer can fire an employee at any time for any reason. c. employees are independent...
-
Heat is generated in a spherical fuel element according to the relationship where qÌ is the volumetric heat-generation rate, kW/m 3 , and r o is the radius of the sphere. Develop the equation...
-
Do public and private companies follow the same set of accounting rules? Explain.
-
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...
-
Athens Gas Station has figured out the weekly demand distribution for their gas sales. Each gallon of gas sold at the pump results in a profit of 10 cents/gallon and any lost sales results in a cost...
-
1. The maximum pressure an eardrum can withstand without rupturing is Pmax = 3.0102 Pa. Assume a sound is made at that pressure. If the density of air is, p=1.20 kg/m, and the speed of sound is 340...
-
52. A wave is sent down a string with a linear mass density of 1.600 x 10-4 kg/m. The wavefunction that describes this wave is: y(x,t) = (0.021 m)*sin{(2.00 rad/m)*x + (30.0 rad/s)*t} What is the...
Study smarter with the SolutionInn App