What are the steps involved in designing a database application?

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 digram 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