1. Describe a simple database of your choice or design, along with the table/s representing the data, and illustrate the Insertion Anomaly through the real data or records there. Your database should be different from those already covered in the lectures or practicals.

Choose a topic related to health that has meaning to your personal health, interests, and well-being. This may be a disease, such as diabetes, or a healthy fitness activity.

Conduct a database search comparing one of the following database directories with Google Scholar.

• CINAHL and Google Scholar
• PubMed and Google Scholar

Explain how you were able to narrow down the number of article hits you had initially, and present within your post a summary of the credible article you chose as your resource. How do you know your article choice is credible? Which database do you prefer and why?

How will using a database search facilitate your:

• scholarly work;
• nursing work (evidence-based practice); and
• personal self-development?

Your company maintains a database with information on your customers, and you
are interested in analyzing patters observed over the past quarter. 23% of customer
in the database placed new orders within this period. However, for those customers
who had a salesperson assigned to them, the new order rate was 58%. Overall, 14%
of customers within the database had salesperson assigned to them.
a) Draw a contingency table for this situation.
b) What percentage of customers in the database placed a new order but did not
have a salesperson assigned to them.
c) Given that a customer did not place a new order, what is the probability that the
customer had a salesperson assigned to him or her?
d) If a customer did not have a salesperson assigned to him or her, what is the
probability that the customer placed a new order?

PartA: Create the database. Name the database doctorWho. Then create a page that allows Doctor Who’s assistant to add a new patient record. You will need to give the assistant rights to this database. The assistant’s username is 'helper' and the password is 'feelBetter'. For this to work, you will need to create several pages so be sure to include all of them when submitting your work. Name the main page addPatient.php.

PartB: Add at least five records to the patient's table in the doctorWho database you created in PartA. Now create a page that will display three or more fields from each of these records. The display should consist of, at a minimum, the patient’s first and last names, and a unique identifier. Name the page getPatient.php and be sure to include the necessary accompanying files when you submit your work.

Database exercise: inpatient cases

• Create database using name RUMKIT
• Create tables below in that database

• patient(idPatient, fullName, biologicalMother, birthdate, address)
• doctor(idDr, fullName, specialization, consulRates)
• inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add
• room(idRoom, roomName, cost)

• fill the data above to each table
• Create sql query and relational algebra expressions for the query

Please give me detailed answer so I could learn from it. Thank you very much

Determine the interest rate (i) that makes the pairs of cash flows below economically equivalent.

For Walmart Inc., find the balance sheet and notes to the financial statements in the fiscal year ended on January 31, 2018 Form 10- K. The Form 10- K can be located by going to the home page of the Securities and Exchange Commission and locating the SEC EDGAR Database. The address for the home page is www. sec. gov. Using the information you find, answer the following questions:

( a) What current assets are included on the balance sheet?

( b) If the company lists accounts receivable and an allowance account, analyze these accounts.

( c) What method does the company use to value inventory?

( d) What depreciation method does the company use?

( e) What assets other than current assets and property, plant, and equipment are included on the balance sheet?