1. create the following tables (considering that your company starts a new business of catering for universities) (70 points) campuses (campus_id, campus_name, street, city, state, zip, phone, campus_discount) positions (position_id, position, yearly_membership_fee) members (member_id, last_name, first_name, campus_address, campus_phone, campus_id, position_id, contract_duration) fk campus_id --> campus(campus_id) position_id --> positions(position_id) prices (food_item_type_id, meal_type, meal_price) food_items (food_item_id, food_item_name, food_item_type_id) fk food_item_type_id --> prices(food_item_type_id)

Consider a power plant with water as the working fluid that operates on an ideal rankine cycle. it has a net power output of 45mw. superheated steam enters the turbine at 7mpa and 500°c (h=3411.4 kj/kg; s=6.8 kj/kg k) and is cooled in the condenser at a pressure of 10 kpa by running cooling water from a lake through the tubes of the condenser at a rate of 2000 kg/s. (a) show the cycle on a t-s diagram (a right schematic is fine - you do not need to calculate the temperatures at each point); (b)-determine the work done by the turbine and the pump in kj/kg; (c)-the mass flow rate of water used by the power plant; (d)-the thermal efficiency of the cycle; (e)-the temperature rise of the cooling water. assume the cooling water is incompressible with cp 4.18 kj/kg°c.