Random Hospital Example ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Random Hospital Example A hospital has 10 wards, each containing up to 20 patients. Patients have only one doctor allowed to prescribe drugs for them. Doctors do their rounds once a day and prescribe drugs by prescription as they see fit. A prescription identifies the drug by code and name, since different drugs may have similar names, which the pharmacy might confuse… given the doctors’ handwriting. The prescription also contains the recommended dosage, and the length of treatment. The pharmacy types out a label for the drug container, incorporating notes about the drug which are listed in the catalogue provided by the drug supplier. After the pharmacy has prepared the drugs, they dispatch them via the hospital porter to the appropriate patient. Once a month, the pharmacy prepares several reports for hospital managem
Random Hospital Example ERD Problem
Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a
You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality.
Random Hospital Example
A hospital has 10 wards, each containing up to 20 patients. Patients have only one doctor allowed to prescribe drugs for them. Doctors do their rounds once a day and prescribe drugs by prescription as they see fit. A prescription identifies the drug by code and name, since different drugs may have similar names, which the pharmacy might confuse… given the doctors’ handwriting. The prescription also contains the recommended dosage, and the length of treatment. The pharmacy types out a label for the drug container, incorporating notes about the drug which are listed in the catalogue provided by the drug supplier. After the pharmacy has prepared the drugs, they dispatch them via the hospital porter to the appropriate patient. Once a month, the pharmacy prepares several reports for hospital management. These include one which shows the quantities and cost of each drug issued, and another which shows the value of drugs issues by each doctor.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
