Using database SHIPPING, which contains three tables: SHIP,…

Using database SHIPPING, which contains three tables: SHIP, SHIP_VOYAGE, and OWNER… which is the correct SELECT clause of a query that will retrieve the hull number, owner, and flag of each ship? Note: There are other records in the table(s) that are not represented here. The query must work no matter what records are in the table(s).

A two-stage, high-rate trickling filters treat 2.25 MGD of m…

A two-stage, high-rate trickling filters treat 2.25 MGD of municipal wastewater that has a BOD5 of 210 mg/L. The trickling filters are of equal diameter and depth and have equal recycle ratios. Other pertinent data for the facility are as follows: BOD5 applied to the trickling filter system: 158 mg/L after 25% of BOD5 removal in the primary clarification system Trickling filter diameter: 75 ft Trickling filter media depth: 6ft Required surface area of the two-stage trickling filter system: 4,418 ft2 (=0.1014 acres) Recycle ratio: 1.0 Using the NRC equations, determine the following parameters and solve the problems.   (4 pts) Determine the required volume of the two-stage trickling filter system (Unit: acre-ft). (4 pts) Determine organic mass loading to the two-stage trickling filter system (unit: lb BOD5/day). (4 pts) Determine trickling filter recycle factor (F). (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter is 68.4%, what is the BOD5 applied to the second-stage trickling filter ? (unit: lb/day) (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter is 68.4%, determine BOD5 removal efficiency (%) of the second-stage trickling filter. (Hint: V2 unit is acre-ft) (4 pts) If the BOD5 removal efficiency of the first-stage trickling filter and the second-stage trickling filter is 68.4% and 54.9%, respectively, what is the expected effluent BOD5 from the system (mg/L)?

A stabilization pond is to be designed for a community with…

A stabilization pond is to be designed for a community with a population of 3,000 people, to provide secondary treatment. Primary treatment of the wastewater is to be provided. Pertinent design data for the facility are as follows. Solve each problem to determine the design parameters. Raw wastewater flow rate: 90 gpcd Influent BOD5: 200 mg/L Primary clarifier BOD5 removal: 30% BOD5/Ultimate BOD: 70% of stabilization ponds in parallel: 2 Pond length to width ratio = 3:1 Pond depth: 5 feet Winter operating temperature: 45 °F (=5.56 °C) Algal toxicity factor (f) = 1 Sulfate concentration is less that 500 mg/L; so f´=1 Temperature coefficient (θ)= 1.07   (4 pts) Determine raw wastewater flow rate (Qww, unit: gpd). (Hint: unit is gpd, not MGD) (4 pts) Calculate primary clarifier effluent BOD5 (mg/L). (4 pts) Ultimate BOD (L0, unit: mg/L). (4 pts) Determine the total stabilization pond volume required (V, unit: ft3) (Hint: C=0.0047, show the total volume, not a single pond) (4 pts) Determine the total stabilization pond surface area (A) required (acres). (Hint: 1 acre = 43,560 ft2, show the total surface, not a single pond) (4 pts) Determine width (ft) of each pond in 5 ft increments. (Hint: each pond has identical width) (4 pts) If stabilization pond width:depth (W:D) ratio is suggested to be 48:1, determine the design depth (ft).