Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem: Modify the database by adding an additional column ("Deleted_Date") to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph. In addition, describe what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?

problem: Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.

Database Proposal Below:

Pharmacy Designating Database:

The intent of this Database Design Proposal is to design and develop a database that will describe, compile, and designate the location of the medications ordered. Medications are ordered 24/7 in the hospital for the inpatients and yet the medications ordered are not making it to the patient. The medications seem to be lost or simply missing from the floor. The nurses have several places to look for their patients’ medications, but stay confused about where each medication is kept. Designing a designating database would list the description of where the medication is kept on each floor or if it will come from pharmacy.

Introduction:

Pharmacy systems today are more efficient and user friendly when compared to the systems 20 years ago. In the early years of pharmacy systems, it was basic and did not provide extra information for the pharmacist or nurses when it came to the route of the medication or what form the medication was dispensed. For ex, Sodium Chloride 0.9% can be administered IV or oral, but the medication form is the same for both routes. Sodium Chloride 0.9% is sent to the floor in its original IV vial for IV use and is drawn up into an oral syringe for oral use. The problem is that the nurse on the floor does not know how the medication will be sent up and that creates confusion on where it will be located: loaded in the AcuDose machine (medication storage machine), in the patient specific drawer in the AcuDose machine, in the refrigerator, or if it has to be tubed up to the floor from the pharmacy.

Resources:

In order to develop the designating medication database the following resources are needed:

• Invest into a database server such as Oracle server or SQL Server.

• Database Management System - This is a collection of software tools that enable the design, construction, maintenance, and backup of databases and allow for data retrieval, manipulation, and processing. Must work with WizOrder/Horizon Expert Orders (HEO), StarChart/StarPanel, AdminRx, and RxStar.

• Client workstation use for reviewing the report through a dashboard.

• A technical business analysis would be needed to design the database.

• A pharmacist informatics purchasing manager that has the knowledge base of medications and clinical connectivity.

Budget:

The budget that would be set for this project would be based on the type of database server purchase and the number of business analyst and developer used.

Users: (Personnel/Credentials):

The user that would use this database would be pharmacist, nurse, doctors, and respiratory therapist. The skill set must be a health care background. They must have access to AcuDose, StarChart/StarPanel, and AdminRx.

Conclusion:

Designing a designating medication database will give healthcare organization the ability to locate the medication and view the description of the medication. The database can contribute the meaningful use of achieving a decrease in medication delay and descriptive education. It can improve quality of care by having the ability to view available formulary medications listed for their specific area. The database will hold all available medication descriptions and have the capacity to store future medication information.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M9201

Have any Question? 


Related Questions in DBMS

Your taskyou have been commissioned to develop a database

Your task You have been commissioned to develop a database system that is capable of keeping records for FU's table tennis matches from now on. The database needs to keep a record of: - All team information, including pl ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

Question as explained throughout this course entity

Question: As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. ...

Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

Solve the following questions using oracle you are not

Solve the following questions using Oracle. You are not allowed to use the syntax of any DBMS other than Oracle. Make sure to upload an electronic copy of your solution to your CSC335 TRACE folder. Name the file hw4.sql. ...

Answer the following question explain the difference

Answer the following Question : Explain the difference between a database management system (DBMS) and a database. Are Microsoft Access, SQL Server, and Oracle examples of databases or database management systems (DBMS)?

This assignment is a continuation of this solution the case

This assignment is a continuation of this solution The case study company has received the first report from its enterprise content management (ECM) consultant and now has a documented list of major content requirements ...

Analytic reportpurpose the purpose of this task is to

Analytic Report: Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given ...

Question create an erd for the following scenario once you

Question: Create an ERD for the following scenario. Once you submit you will get access to the correct way to create the ERD. Please watch the video and correct any errors in your submission and resubmit. A small company ...

Question sql injection is in the top 10 owasp and common

Question : SQL Injection is in the top 10 OWASP and Common Weakness Enumeration. Using MySQL and PHP, show your own very short and simple application that is vulnerable to this attack. Provide another version that mitiga ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As