Consider the following three tables, primary and foreign keys. Table Name Salespeople Attribute Name Employee Number...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the following three tables, primary and foreign keys. Table Name Salespeople Attribute Name Employee Number Name Job Title Address Phone Number YearsInPosition Table Name Product Description Attribute Name Product Number ProductName ProductPrice Table Name SalesOrder Attribute Name Sales Order Number Product Number Employee Number SalesOrder Date C. Type Number Character Character Character Character Number Develop the following queries: Type Number Character Number Type Number Number Number Date Assume that you draw up a new sales order for each product sold. a. All the Sales People with more than five years in position. b. All the Products that cost more than $50. Key Type Primary Key Key Type Primary Key Primary Key Foreign Key Foreign Key Key Type e. Total Revenue sold by Sales People less than 3 years in the position. All the Sales Orders sold by Sales People less than 3 years in the position. d. All the Product Names sold by Sales People more than 5 years in the position. Consider the following three tables, primary and foreign keys. Table Name Salespeople Attribute Name Employee Number Name Job Title Address Phone Number YearsInPosition Table Name Product Description Attribute Name Product Number ProductName ProductPrice Table Name SalesOrder Attribute Name Sales Order Number Product Number Employee Number SalesOrder Date C. Type Number Character Character Character Character Number Develop the following queries: Type Number Character Number Type Number Number Number Date Assume that you draw up a new sales order for each product sold. a. All the Sales People with more than five years in position. b. All the Products that cost more than $50. Key Type Primary Key Key Type Primary Key Primary Key Foreign Key Foreign Key Key Type e. Total Revenue sold by Sales People less than 3 years in the position. All the Sales Orders sold by Sales People less than 3 years in the position. d. All the Product Names sold by Sales People more than 5 years in the position.
Expert Answer:
Answer rating: 100% (QA)
The image provides information about three database tables SalesPeople ProductDescription and SalesOrder It also lists the attributes data types and i... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
A stock is currently priced at $39.3. Its dividend is expected to grow at a rate of 5.9% per year indefinitely. The stock's required return is 8.4%. The stock's predicted price 7 years from now, P7,...
-
The Atlantic division operates as a profit centre. It reports the following for the year. _________________________________________Budgeted Actual...
-
When should a business consider buying key person life insurance?
-
The force exerted by expanding gases is what propels a shell out of a gun barrel. Suppose a force that has an average magnitude \(F\) propels the shell so that it has a speed \(v\) at the instant it...
-
The number of students enrolled at Spring Valley Elementary has been steadily increasing over the past five years. The school board would like to forecast enrollment for years 6 and 7 in order to...
-
Discuss the seven {7} domains of a typical IT infrastructure. Address these questions: What components are unique to each domain? For example, the User Domain focuses on people, whereas the...
-
Question 11 The condensed financial statements of the Estee Lauder Companies, Inc. for the years ended June 30, 2020, and 2019 are presented below. Estee Lauder Companies, Inc. Balance Sheet June 30...
-
Learning Objective 1.1: Explain how to organize effective teams? Learning Objective 2.1: Apply strategies for addressing conflict. Learning Objective 3.1: Describe strategies used to build consensus...
-
You work for a 38firm whose home currency is the Euro (EUR) and that is considering a foreign investment. The investment yields expected after-tax Swiss Franc (SFR) cash flows (in millions) as...
-
What are your groups desired benefits, as decided by our Benefits Committee Group What were some considerations when drafting the plan? What are some possible challenges and benefits of designing a...
-
1. Discuss the importance of assigning passwords and rights to users of an electronic health record (EHR) system. 2. Explain why it is important to lock an EHR system when not actively working with...
-
Explain how the Donabedian Model, Total Quality Management, and Andersen's Model of Healthcare Utilization will act as a filtering tool to select appropriate sources regarding access to maternal...
-
A boy walks 4.0m East and 3.0 m North. What is his resultant displacement vector? 5.0 m, 37 deg N of E 5.0 m, 37 deg E of N 5.0 m , 37 deg N of W 5.0 m, 37 deg w of N
-
Write the binomial probability in words. Then, use a continuity correction to convert the binomial probability to a normal distribution probability. P(x 110)
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Robert Ramos (age 36) is a single taxpayer, living at 8765 Bay Dr., Monterey, CA 93940. His Social Security number is 976-23-5132. Robert's earnings and income tax withholding as the manager of a...
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
Why is the analyzing step of the process crucial to the success of a MedImmune proposal? In the discussion, draw students attention to the intersection of medical, legal, and social issues. Why is...
-
How does the Clinical Trial Application guide described in the example make the composing process for a new document easier? How is it informed by the evaluation process? What metaphors or analogies...
-
What are the advantages and disadvantages of the following other options: making an announcement on the companys internal website, sending a memo to each employee, sending an email to each employee,...
Study smarter with the SolutionInn App