How would you include on the erd the need to represent

Assignment Help Computer Engineering

Reference no: EM133548723

Question: A hospital has a large number of registered physicians. Attributes of PHYSICIAN include Physician ID (the iden- tifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient ID (the identifier) and Patient Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of pa- tients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients, or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment Detail). Components of Treatment Detail include Date, Time, and Results. Did you draw more than one relation- ship between physician and patient? Why or why not? Did you include hospital as an entity type? Why or why not? Does your ERD allow for the same patient to be admitted by different physicians over time? How would you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted?

Reference no: EM133548723

Questions Cloud

Describes the movie kids behind bars and combines : What did you learn from the film that you did not know before you watched the film? Describes the movie "Kids Behind Bars" and combines the questions from

How would it work in comparison to the von neuman system : What could be next? Use you creative minds to design a new structure, how would it work in comparison to the von Neuman system

How does the chief maintain the progress the department has : how does the chief deal with tensions felt in the law enforcement community since Ferguson, Baltimore, Dallas, and the rise of shootings against the police?

Explain the controversy of establishing a court system : Explain the controversy of establishing a court system at the creation of the U.S. Constitution. Your responses must include the major elements

How would you include on the erd the need to represent : How would you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted

How would you as the leader ensure that all cultures : Are leadership visions for organizations inadequate if not shared with constituents? What are the implications associated with sharing, or not sharing

How would utilitarian ethics respond, and why : How would utilitarian ethics respond, and why? How would Kantian ethics respond, and why? which side, if either, has the most rational and well-argued position

What is your opinion on the relative clarity : What is your opinion on the relative clarity, elegance, and efficiency of the two algorithms (using the definition and using the formula) to compute F(20)

Discuss the parts of the social ecology theory : Discuss the parts of the Social Ecology Theory and its relationship with the Broken Windows what it means for improving a neighborhood

User Account

All Pages