1. Create a conceptual database design for the following scenario using an ER model created in LucidChart.

For this it does not have to be in liquidchart but any type of chart form since i will make the charts in the program later.

The purpose of this form shown below is to record the medication given to a particular patient at the Wellmeadows Hospital. Examine the data shown on the form.

2. Create a conceptual database design using an ER model in LucidChart for the following scenario. Submit a link to your model.

A person would like to keep track of the books that she has read. She would like the ability to track the basic information about a book (title, author, etc.) and whether it is fiction or non-fiction. Additionally she would like to keep track of when she read the book and a short summary of the book. It's possible that she will re-read a book and she would like a record of that.

3

Create a conceptual database design using an ER model in LucidChart for the following situation. Submit a link to your model.

Students can registered for many courses. Courses are identified by their CRN and have characteristics such as a course number, name and section. Students are identified by a student ID. We keep track of a student's name, phone numbers (home, cell, etc.) and two addresses - the student's permanent address and an optional local address. The local address may be or may not be a campus address.