Make an ER diagram that describes the following data and relationships: [2]

• A health care organization keeps track of its doctors and outpatient locations.
• For each doctor it keeps track of the DoctorID (unique), DoctorName, and 
DoctorYearofMDGraduation (year graduated from medical school).
• For each outpatient location it keeps track of the OLID (Outpatient Location ID; unique) and 
OLName (Outpatient Location Name).
• Each doctor works at exactly one outpatient location and each outpatient location must have 
at least one doctor working at it, but can have many doctors working at it.

 

2. Make an ER diagram that describes the following data and relationships: [3]

•  
  • A health care organization keeps track of outpatient locations and examination rooms within the outpatient locations
  • For each outpatient location, the health care organization keeps track of the OLID (Outpatient Location ID; unique) and OLName (Outpatient Location Name)
  • For each examination room (weak entity) the health care organization keeps track of the ERoomNumber (unique within its outpatient center, but an examination room in different outpatient locations can have the same ERoomNumber) and ERoomSize
  • Each outpatient location must have at least one, but can have many, examination rooms, and each examination room is located in one outpatient location.

 

 

3. Investco Scout is an investment research company. Create the ER diagram for the Investco Scout Funds Database, which is supposed to contain the following information: 


•  
  • It will keep track of investment companies, the mutual funds they manage, and securities contained in the mutual funds.
  • For each investment company, Investco Scout will keep track of a unique investment company identifier, a unique investment company name, and the investment company's location.
  • For each mutual fund, Investco Scout will keep track of a unique mutual fund identifier, the mutual fund name, and the mutual fund inception date.
  • For each security, Investco Scout will keep track of a unique security identifier, as well as the security name and type.
  • Investment companies can manage multiple mutual funds. Investco Scout will not keep track of investment companies that do not manage any mutual funds. A mutual fund is managed by one investment company.
  • A mutual fund contains one or many securities. A security can be included in many mutual funds. Investco Scout will keep track of securities that are not included in any mutual funds.
  • For each instance of a security included in a mutual fund, Investco Scout will keep track of the amount included  Use the edrplus login to create a diagram.

Answer rating: 100% (QA)

DoctorId and OLID are unique that is primary keys so they are represented as underlined It ... View the full answer