Question) Draw an ER diagram that captures the following information: The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Assume the rising cost of health care, you approve. Here’s the information that you gather: Patients are...

Question )Deadlock prevention algorithms prevent deadlocks by restraining how requests can be made. A different method for avoiding deadlocks is to require additional information about how resources are to be requested. For example, consider the following snapshot.                ...

Case Studies for Exam Preparation: Question. Give two examples of information about a problem domain that can be captured in UML Activity Diagrams, and two ways in which these diagrams can be useful for Requirements Analysis. Answer: Examples of info represented: Activity diagrams show how tasks depend on one another...

Question. How can you apply the data to the warehouse? What are the modes?Answer: Data may be applied in the following four different modes: load, append, destructive merge, and constructive merge. Let us understanding of the effect of applying data in each of these four modes:Load: If the target table to be loaded...