Engineering, 23.10.2019 17:30 loveagirl111puppy

Based on the relational model you created for question 1, provide relational algebra statements that would return the results for the following queries. a. find banks that have more than 100 branches. b. find customers whose savings accounts have an interest rate over 2%. return the names of both types of customers. c. find the names of companies who owns a checking account that has more than $100,000 balance. d. find the names of the customers who are persons and have a loan with insurance. e. the derived attribute shared shows the number of owners an account has. for each account, return the account number (acct-no) and the value of the shared attribute.

Answers: 1

Show answers

Other questions on the subject: Engineering

Engineering, 04.07.2019 18:10, anna22684

Water at 70°f and streams enter the mixing chamber at the same mass flow rate, determine the temperature and the quality of the exiting stream. 0 psia is heated in a chamber by mixing it with saturated water vapor at 20 psia. if both streams enters the mixing chamber at the same mass flow rate, determine the temperature and the quality of the existing system.

Answers: 2

continue

Engineering, 04.07.2019 18:10, lillygrl100

For the closed feedwater heater below, feedwater enters state 3 at a pressure of 2000 psia and temperature of 420 °f at a rate of ix10 ibhr. the feedwat extracted steam enters state 1 at a pressure of 1000 psia and enthalpy of 1500 btu/lbm. the extracted er leaves at an enthalpy of 528.7 btu/lbm steam leaves as a saturated liquid. (16) a) determine the mass flow rate of the extraction steam used to heat the feedwater (10) b) determine the terminal temperature difference of the closed feedwater heater

Answers: 3

continue

Engineering, 04.07.2019 18:10, genyjoannerubiera

Assuming compressible flow of air and that the measurements are done at flagstaff a pitot static tube that gives the difference of total and static pressure measures 0.35 m of mercury. what is the velocity of air? assume the temperature to be 300k. (submit your excel or matlab calculation sheet)

Answers: 1

continue

Engineering, 04.07.2019 18:10, oshawn108

Ahot wire operates at a temperature of 200°c while the air temperature is 20°c. the hot wire element is a tungsten wire of 5 um diameter and 2 mm in length. plot using excel current, heat transfer and heat generated by the wire for air velocity varying from 1-10 m/s in steps of lm/s? matlab the sensor voltage output, resistance, or assume nu 0.989 re033pr13 take air properties at tr (200°c20°c)/2 = 110°c properties of tungsten: c 0.13 kj/kg. k 3 p 19250 kg/m k (thermal conductivity) = 174 w/m. k

Answers: 2

continue

You know the right answer?

Based on the relational model you created for question 1, provide relational algebra statements that...