Chapter $4$ page $80$ has a scenario for West Lake Research Hospital

Please read the scenario from the Text Book and Submit the following.

Define the entities, attributes, and relations that exist between them.

Create a logical model using crow$$s feet notation in Visio.

Identify the key fields for each entity and the foreign keys.

Analyze the diagram, Identify which role $($i$.$e$.,$ domain, linking, lookup, or weak$)$ each entity plays in your database.