Relational algebra expressions for names of salespeople

Assignment Help Database Management System

Reference no: EM1347705

Q1) Illustrate relational algebra expressions for

a. names of all salespeople
b. names of all salespeople having ORDER row
c. names of salespeople not having ORDER row
d. names of salespeople having order with Abernathy Construction
e. salaries of salespeople having order with Abernathy Construction
f. city of all CUSTOMERS having order with salesperson Jones
g. names of all sales people with the names of customers who have ordered from them. Include salespeople who have no orders.

Name Salary
Abel 120,000
Baker 42,000
Jones 36,000
Murphy 50,000
Zenith 118,000
Kobad 34,000
(SALESPEOPLE)

Number CustName SalespersonName Amount
100 Abernathy Construction Zenith 560
200 Abernathy Construction Jones 1800
300 Manchester Lumber Abel 480
400 Amalgamated Housing Abel 2500
500 Abernathy Construction Murphy 6000
600 Tri-city Builders Abel 700
700 Manchester Lumber Jones 150
(ORDER)

Name City IndustryType
Abernathy Construction Willow B
Manchester Lumber Manchester F
Tri-city Builders Memphis B
Amalgmated Housing Memphis B
(CUSTOMER)

Reference no: EM1347705

Questions Cloud

Compute the required monthly payment : Suppose Mr. Johnson wants to buy a new home at Sugar Land in June 2010. The sale price of the home is $580,000. He considers paying 20 percent down payments. Compute the required monthly payment.

Incentive plan, hiring and training staff : Explain how do you ensure that the new staff gets the appropriate training and How would you ensure that the new staff meets company standards after their training?

Flexible budget analysis and strategic-budget analysis : Why might managers find out a flexible budget analysis more informative than the strategic-budget analysis? Describe your rationale. How might a manager gain insight in the causes of the flexible-budget variance for direct materials?

Illustrate what is likely post- merger bargaining outcome : Suppose the two newspapers merge. Illustrate what is the likely post- merger bargaining outcome.

Relational algebra expressions for names of salespeople : Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

How does consumer behavior influence purchase categories : How does consumer behavior influence purchase categories and explain what factors and relationships can motivate buying decisions, and why

Llustrate what are the quantities produced before and after : llustrate what are the quantities produced before and after the tax was imposed.

Determine the interest expense : Determine the interest expense that Rainey Corporation will show with respect to these bonds in income statement for the fiscal year ended September 30, 2010, suppose amortized premium is $67,000.

Define the radius of curvature of the mirror : How much work is completed by the Moon's gravitational field as a 915kg meteor comes in from outer space and impacts on the Moon's surface.

User Account

All Pages