Blog

A funeral home has to register through the “Known Shipper” program to be able to ship remains. 

What is the translatory motion that occurs after 90 degrees of abduction of the Humeral head on the glenoid fossa of the scapulae to facilitate full arm elevation?

Based on the nursing notes available, which mental health client is most likely to be admitted if only one bed were available for admission to the mental healthcare facility?

A charge nurse is making assignments for four clients with dementia on a memory care unit. Which client situation requires direct intervention by the registered nurse rather than delegation to an LPN or UAP?

Brittany (age 35) is single and has AGI of $75,000. She has maxed out her contributions to her 401(k) and wants to make a contribution to her traditional IRA. How much can she contribute in 2024 and would any of the contribution be deductible?

Assume we have a relation containing customer information of a bank with the schema below: Customer(customerID, branchID, zip, income, balance) We know the following facts about the data stored in this relation: (1) There are around 100,000 records stored in the relation; (2) there are 20 different branches, and each branch roughly has the same amount of customers; (3) Around 50 customers reside in each distinct zip code. A workload with three types of queries is executed against this relation. All three types show up at a similar rate in the workload. The three query types are: • Query 1: Retrieve customer information with a given CustomerID; • Query 2: Get the average income of customers in a continuous zip code range of size 10. (e.g., 16803 – 16813) • Query 3:  Calculate the balance sum of all customers in a branch with a given branchID. (a) [6 points] You now have a chance to build two indexes on this table and justify your choice. (b) [4 points] What type of index are they (Hash, B+Tree)?   [Hints: remember the rules of creating an index: Make some attribute K a search key if the WHERE clause contains: An exact match on K A range predicate on K A join on K Try to create index that covers multiple workloads Try to select a index based on the frequency of the workload Try to select a index on a workload that is more selective ]

Only for questions 5, you are allowed to use paper submission. Please draw the diagram(s) on a paper and submit it. For the schema from the ERD use submission over canvas. Please remember to submit the paper within 10 minutes of your respective submission of the final exam over Canvas. Anything sent beyond that will not be considered for grading. Also please make sure your handwriting is readable. Also submit the scratch paper that you have used during the exam.   For all the questions try to explain the intermediate steps. Just providing the answer will give you only 1 point for the question. Also even if you do not get the final answer right, showing me the steps will help you to get partial credits, which is more than 1 point. In case you have any questions please write an email or join the Zoom Call. Also please take your time in answering the questions, please donot rush and read them carefully. https://psu.zoom.us/j/96938983918?pwd=piKUiSupaauwq3lNwai4g29wlDHDt9.1

For the following schedule Draw the conflict graph. (here time progresses as you go to the bottom)[4] T1 T2 T3   R(X)       R(X) W(Y)       W(X)       R(Y)   W(Y)     Is the schedule conflict serializable? [3] Prove or disprove using a conflict graph. If yes then please give the equivalent serial schedule. [2]

You will have 2 hours and 50 minutes (almost 3 hours; shown as 2:50:00 in the upper right corner of your screen) to work on the exam; starting from when the questions first load.  You will be unable to make any more changes after 2 hrs 50 mins from the time you start the exam AND you will be unable to start the exam after 11:59 pm (end of the day) on Monday, Dec 16. If you lose internet access, the timer will not stop, so you will still only have 75 minutes from when you started before your exam will be over. If your normal internet connection is unreliable, please find a different place to work. You could bring your laptop to campus and use Normandale’s internet OR you could use one of the computers in Normandale’s computer labs. If you plan to work from a different location, TRY IT FIRST with the Pre-Exam Agreement, especially if it will not be at Normandale (since you will need to download Honorlock and have access to a webcam.)  Which of the following is true? (Choose any/all correct answers.)

What is the recommended dose of Amoxicillin for adults to prevent bacterial endocarditis before a dental procedure?