Ask Question, Ask an Expert

+61-413 786 465

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.


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.


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.


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.


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

In sql database questions phase-1 in 100 words what steps

In SQL Database Questions: Phase-1 In 100 words, what steps can one take to avoid losing work? Which command is used to save changes to the database? What is the syntax for this command? Phase-2 In 100 words, explain the ...

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

Sql injection on a searchthe way search performs its task

SQL injection on a search The way Search performs its task is by executing the following query (in a php script):          $var=stripslashes($_POST['search']);          $query = "SELECT username from lab1_login where use ...

Project outline and requirements provide a brief

Project Outline and Requirements Provide a brief description of the organization (can be hypothetical) that will be used as the basis for the projects in the course. Include company size, location(s), and other pertinent ...

Sql assignmentin these exercises youll enter and run your

SQL Assignment In these exercises, you'll enter and run your own SELECT statements. You will use the MyGuitarShop database for these queries. If you do not already have the MyGuitarShop database, the SQL script and the i ...

Question a suppose you are a marathon runner that can run a

Question : a) Suppose you are a marathon runner that can run a maximum of n miles on a single bottle of water. You are given a map of your marathon route with all the water stations marked. Design an efficient algorithm ...

We can represent a data set as a collection of object nodes

We can represent a data set as a collection of object nodes and a collection of attribute nodes, where there is a link between each object and each attribute, and where the weight of that link is the value of the object ...

Question team project submission - submit to the unit 4

Question: Team Project Submission - Submit to the Unit 4 Group Project Area This version of the capstone project assignment is FOR GRADING this week. Submit to the group area the document containing completed Sections On ...

Assignmentqueries functions and triggersdatabase

Assignment Queries, Functions and Triggers Database Systems Aims The aims of this assignment are to: formulate SQL queries; populate an RDBMS with a real dataset, and analyse the data; design test data for testing SQL qu ...

Database and information retrieval assignment - data

Database and Information Retrieval Assignment - Data Privacy Essay Task - Write an essay (aim for 750 words) that addresses issues associated with data proivacy. Use the Australian Privacy Principles - discussed in class ...

  • 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