o$$ Indicate cardinalities $($one$-$to$-$one, one$-$to$-$many, many$-$to$-$many$)$ in your ERD.

You are hired to set up a relational database for a small community hospital. The first thing you do is to go to the hospital and find out the attributes that need to be stored, and their inter$-$relationships. Here are your findings:

Every room has a unique room number $($integer$).$ Every room has one designated usage $($char $[40]),$ but different rooms may have the same usage. Every patient is assigned a room, but many patients may be assigned to the same room. Every patient has a unique patient number $($integer$)$ Every patient has a name $($char$[40])$ which is not necessarily unique. A patient may be treated by more than one doctor, and a doctor may attend to more than one patient. Every doctor has a unique doctor number $($integer$),$ name $($char$[40]),$ and a unique phone $($char$[10]).$

$$ Draw a relational model that represents the small community hospital. Show the primary key of each relation, the foreign keys and their references.

$$ Write the appropriate SQL statements to create the small community hospital database.