Consider the relational database of Figure. Give a relational-algebra expression for each of the following queries: a.
Question:
Consider the relational database of Figure. Give a relational-algebra expression for each of the following queries:
a. Find the company with the most employees.
b. Find the company with the smallest payroll.
c. Find those companies whose employees earn a higher salary, on average, than the average salary at First BankCorporation.
Transcribed Image Text:
employee (person-name, street, city) works (person-name, company-name, salary) соmрany (companу-пamе, city) таnages (person-нате, тапager-nате)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (6 reviews)
a t companyname works t maxnumemployees Pcompanystrengthcompanynamenumemployees t IIcompanyname Pta...View the full answer
Answered By
ANDREW KIPRUTO
Academic Writing Expert
I have over 7 years of research and application experience. I am trained and licensed to provide expertise in IT information, computer sciences related topics and other units like chemistry, Business, law, biology, biochemistry, and genetics. I'm a network and IT admin with +8 years of experience in all kind of environments.
I can help you in the following areas:
Networking
- Ethernet, Wireless Airmax and 802.11, fiber networks on GPON/GEPON and WDM
- Protocols and IP Services: VLANs, LACP, ACLs, VPNs, OSPF, BGP, RADIUS, PPPoE, DNS, Proxies, SNMP
- Vendors: MikroTik, Ubiquiti, Cisco, Juniper, HP, Dell, DrayTek, SMC, Zyxel, Furukawa Electric, and many more
- Monitoring Systems: PRTG, Zabbix, Whatsup Gold, TheDude, RRDtoo
Always available for new projects! Contact me for any inquiries
4.30+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer Sciences questions
-
Consider the relational database of Figure. Give an expression in the relational algebra for each request: a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First...
-
Consider the relational database of Figure. Give an expression in SQL for each of the following queries. a. Modify the database so that Jones now lives in Newtown. b. Give all employees of First Bank...
-
Consider the relational database of Figure. Write a Datalog program for each of the following queries: a. Find all employees who work (directly or indirectly) under the manager Jones. b. Find all...
-
A. Determine the cost of the goods sold for the September 30 sale. B. Determine the inventory on September 30. Beginning inventory, purchases, and sales for an inventory item are as follows: 31 units...
-
Goose down is used in a wide variety of products, including jackets, bedding, and pillows. In recent years, the cost of down has been increasing. For example, in 2009, a pound of goose down sold for...
-
Give context-free grammars that generate the following languages. In all parts, the alphabet is {0,1}. Aa. {w| w contains at least three 1s} b. {w| w starts and ends with the same symbol} c. {w| the...
-
To what extent are the arguments for countries specialising and then trading with each other the same as those for individuals specialising in doing the jobs to which they are relatively well suited?
-
Baton Rouges Mt. Cedar Hospital is a large, private, 600- bed facility complete with laboratories, operating rooms, and X- ray equipment. In seeking to increase revenues, Mt. Cedars administration...
-
24. The Obama administration published the following graph in 2012. Explain why the following graph is misleading. Outline the changes needed to make the graph bias-free. [2 marks] Under President...
-
Compute a multicast spanning tree for router C in the following subnet for a group with members at routers A, B, C, D, E, F, I, and K.
-
Using the bank example, write relational-algebra queries to find the accounts held by more than two customers in the following ways: a. Using an aggregate function. b. Without using any aggregate...
-
List two reasons why we may choose to define a view.
-
A 5.0-kg rock and a 3.0 10-4-kg pebble are held near the surface of the earth. (a) Determine the magnitude of the gravitational force exerted on each by the earth. (b) Calculate the magnitude of the...
-
i) What do we mean by Pareto efficiency? ii) What is a market failure? iii) Have you ever encounter a situation where the allocation was not efficient? iv) Efficiency is not the same than equity....
-
A hanging mass m 1 = 0.50kg is attached by a light string that runs over a frictionless pulley to a mass m 2 = 1.50kg that is initially at rest on a frictionless table. Find the acceleration of m 2...
-
Many things happened after the end of the war between America and Great Britain. The British Prime Minister, Lord North, resigned in disgrace. Articles of Peace were signed between the two warring...
-
Suppose P1(Q) and P2(Q) are demand and supply curves, respectively, where P1(Q) = 200e^-0.01Q and P2(Q) = 20e^0.08Q and where price P is in dollars for a quantity Q. Suppose there is a quantity...
-
Choose a natural disaster that happened in the US. Whether it be Earthquake, Heatwave, Landslide, Tornado, or Wildfire that happened within the last 10 years. Research the natural disaster and answer...
-
What is an industry? Provide an example of an industry and several firms in it.
-
Swifty company is a publicly held corporation whose $1 par value stock is actively traded at $30 per share. The company issued 3400 shares of stock to acquire land recently advertised at $93000. When...
-
Consider the E(t) curve below. A graph is shown, with t (in minutes) on horizontal axis and E of t (minutes inverse) on vertical axis. A hemi (half) circular curve starts at the origin and ends at 2...
-
Why do cloud-computing services support traditional database systems best by using a virtual machine, instead of running directly on the service providers actual machine, assuming that data is on...
-
Why might a client choose to subscribe only to the basic infrastructure-as-aservice model rather than to the services offered by other cloud service models?
-
Some database operations such as joins can see a significant difference in speed when data (e.g., one of the relations involved in a join) fits in memory as compared to the situation where the data...
-
Yield to maturity The bond shown in the following table pays interest annually. (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a...
-
1. Given a function f(t) = t- t2 over the interval 0 t. (a) Sketch a graph for the above function in the interval -3 < t <3 (b) Determine half range cosine series expansion. (c) Hence deduce that, 1...
-
Consider the electric potential lines below. Identify a charge distribution that could cause these lines. Where is the voltage the greatest? Draw in the path that a positive test charge would take if...
Study smarter with the SolutionInn App