Consider the following bcnf schema and a portion of a simple corporate database (type
informat...
Engineering, 26.12.2019 22:31 jzoda7318
Consider the following bcnf schema and a portion of a simple corporate database (type
information is not relevant to this question and is omitted):
emp(eid, ename, addr, sal, age, yrs, deptid)
dept(did, dname, floor, budget)
suppose you know that the following queries are the six most common queries in the workload
for this corporation and that all six are roughly equivalent in frequency and importance:
list the id, name and address of employees in a user-specified age range
list the id, name and address of employees who work in the department with a userspecified department name
list the id and address of employees with a user- specified employee name
list the overall average salary for employees
list the average salary for employees of each age; that is, for each age in the database,
list the age and the corresponding average salary.
list all the department information, ordered by department floor numbers.
Answers: 2
Engineering, 04.07.2019 18:10
Steel is coated with a thin layer of ceramic to protect against corrosion. what do you expect to happen to the coating when the temperature of the steel is increased significantly? explain.
Answers: 1
Engineering, 04.07.2019 18:10
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
Engineering, 04.07.2019 18:10
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
Engineering, 04.07.2019 19:10
The sum of the normal stresses does not change as the stress state rotates through an angle. a)-trune b)- false
Answers: 2
Social Studies, 09.10.2019 16:30
Mathematics, 09.10.2019 16:30
Mathematics, 09.10.2019 16:30
English, 09.10.2019 16:30
Mathematics, 09.10.2019 16:30
Chemistry, 09.10.2019 16:30
English, 09.10.2019 16:30
Mathematics, 09.10.2019 16:30