Save this document with a new name by replacing the $$LASTNAME$\_$FIRSTNAME$$ part of its file ASSIGNEMENT INSTRUCTIONS:

Save this document with a new name by replacing the "LASTNAME$\_$FIRSTNAME" part of its file

name with your name. Do not remove or change my instructions in your submission.

Place your name, date, the course code, and your section number above the instructions.

The chapter $4$ assignment refers to the example in your textbook which is a required material

for this class $($see the syllabus$).$ Therefore, not having the textbook is not a valid reason for not

being able to complete the assignment.

You must follow all instructions in this document to avoid losing points.

In one of your previous assignments, you used business rules to create a conceptual data model

reflecting a healthcare scenario. This time, you will use the same scenario to create a logical model with

Crow's Foot notation. Use figure $4\mathrm{.}16$ on p$.126("$Ternary relationship $($Logical$)"$ in your textbook as a

starting point:

The example on p$.126$ shows a ternary relationship between the DOCTOR, PATIENT, and DRUG entities,

which requires adding an associative $($bridge$)$ relation PRESCRIPTION. The PRESCRIPTION relation has a

composite PK whose elements $($attributes$)$ are also FKs$.$ You must complete the above diagram in

Lucidchart by adding the attributes listed in figure $4\mathrm{.}17$ on p$.128$:

name with your name. Do not remove or change my instructions in your submission.

$$ Place your name, date, the course code, and your section number above the instructions.

$$ The chapter $4$ assignment refers to the example in your textbook which is a required material

for this class $($see the syllabus$).$ Therefore, not having the textbook is not a valid reason for not

being able to complete the assignment.

$$ You must follow all instructions in this document to avoid losing points.

In one of your previous assignments, you used business rules to create a conceptual data model

reflecting a healthcare scenario. This time, you will use the same scenario to create a logical model with

Crow's Foot notation. Use figure $4\mathrm{.}16$ on p$.126("$Ternary relationship $($Logical$)$ in your textbook as a

starting point:

My name is Katie C