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

Lab manualin this lab you will learn how to use ddl and

Lab Manual In this lab you will learn how to use DDL and Oracle Enterprise server to create user accounts, modify, monitor and delete them. You will take the first look at object permissions in Oracle. The last assignmen ...

Assignmentthis assignment consists of two sections a design

Assignment This assignment consists of two 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 nam ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Graph databases assignment1choose a social network that you

Graph Databases Assignment 1. Choose a social network that you use. Say, FaceBook, Twitter, LinkedIn, or anything else. 2. Design a model to store and manage relationship data from these social networks in a graph databa ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

Apriori analysis and cluster analysis-data analysis

ApriorI analysis and Cluster analysis-Data Analysis assignment CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" se ...

Individual outsourcing risksprepare a 8- to 10-slide

Individual: Outsourcing Risks Prepare a 8- to 10-slide PowerPoint presentation, including speaker notes, that identifies the possible risks to an organization in each of the following outsourcing situations: • The use of ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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