Databases

What are the steps involved in designing a database application? Using ER data model , list the possible types of relations that may exist between two entities.

Construct an ER diagram for the hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted