Question 3 (40 points) Consider a gym that has multiple type…
Question 3 (40 points) Consider a gym that has multiple types of exercise spaces (identified by SpaceID). Each of these spaces has at each point in time one manager (identified with SpaceManagerID), and you can assume that the gym is not tracking past or future manager appointments. The gym keeps track of each visit by a specific client (identified by a ClientID) to a specific exercise space. The gym captures both the start time/date and end time/date every time a client uses a space; in addition, the gym records the numeric rating and written comments by clients regarding each visit. A client to visit the gym needs a client pass (identified by ClientPassID with attributes for price, pass type, and start and end dates). The gym currently records all visit information in a spreadsheet as follows: ClientID, ClientLName, ClientFName, ClientDOB, ClientPassID, ClientPassPrice, ClientPassType, ClientPassStartDate, ClientPassEndDate, SpaceID, SpaceName, SpaceOpeningTime, SpaceClosingTime, SpaceManagerID, SpaceManagerLName, SpaceManagerFName, SpaceVisitStartDateTime SpaceVisitRating, SpaceVisitComment Provide the 1nf, 2nf and 3nf relations to help implement a database to manage the gym.
Read DetailsA client is on a sliding scale for insulin dosages q6h. The…
A client is on a sliding scale for insulin dosages q6h. The order is for Humulin Regular U-100 subcutaneous q6h as follows See the control sheet Blood Glucose Level (mg per dL) Regular Insulin Less than 70 Call the healthcare provider 201-250 4 units 251-300 6 units 301-350 8 units 351-400 10 units Greater than 400 Call the healthcare provider At 8:00 AM the client’s blood sugar is 384 mg/dL. How much insulin will the nurse administer? __[BLANK-1]_____ units At 2:00 PM the client’s blood sugar is 310 mg/dL. How much insulin will the nurse administer? __[BLANK-2]_____ units Enter the number(s) only in the blank.
Read DetailsA client weighs 210 lbs. Heparin IV infusion} Heparin sodium…
A client weighs 210 lbs. Heparin IV infusion} Heparin sodium 25,000 units in 1,000 ml of 0.9% normal saline. The order is to give a bolus with heparin sodium 80 units/kg, then initiate drip at 14 units/ kg/hr. (Round weight and infusion to the tenth. Enter only number(s) in the blank.) Calculate the heparin bolus dosage ____[BLANK-1]________;Calculate the initial infusion dose _____[BLANK-2]________ (Enter the number(s) only in the blank.)
Read Details