Ask Question, Ask an Expert

+1-415-315-9853

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

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

Database normalizationnormalize the below orders table to

Database Normalization Normalize the below Orders table to 3NF. Make sure to identify all the entities and their attributes, especially if you make any new items (such as entity or attributes). The following is a list of ...

This assignment consists of two 2 sections a design

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name accor ...

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Data analysis projectyou have contracted with a local

Data Analysis Project You have contracted with a local school district to help them decide whether to use an interactive computer program or a standard chapter from a textbook to teach students to use fractions. The scho ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure to the concepts relating to database systems and optimal strategies for efficient management of databases Learning Outcomes assessed: 1. Crea ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen