Strategies for Maintaining the Therapeutic Relationship with A Patient

Strategies for Maintaining the Therapeutic Relationship with A Patient

Instructions/Descriptions

Strategies for Maintaining the Therapeutic Relationship with A Patient

Explain the controversy that surrounds your selected disorder.

Explain your professional beliefs about this disorder, supporting your rationale with at least three scholarly references from the literature.

Explain strategies for maintaining the therapeutic relationship with a patient that may present with this disorder.

Finally, explain ethical and legal considerations related to this disorder that you need to bring to your practice and why they are important.

3 pages

Primary Key/Foreign Key Placement Entity Relationship Diagram

Assignment Instructions

Part 1: Definitions

Define each of the following terms. In addition, provide an example of each term.

Business rule

Entity set (entity type)

Entity instance

Attribute

Relationship

Connectivity

Cardinality constraint

Primary key

Foreign key

Associative entity

Part 2: Business Rules

Please use this four-row format when writing your connectivity-determining business rules.

Explanation of each row in the 4-row format:

Write the entity pair. Underline and/or bold.

Give one business rule. Indicate the multiplicity of that rule in parentheses.

Give the other business rule. Indicate the multiplicity of that rule in parentheses.

Give the connectivity. (If the connectivity is M: N, give the associative entity name.)

Following is an example of the required four-row format for business rules for a binary relationship for this Assignment.

Example:

Publisher – Book

[Order Now]

ONE Publisher may publish MANY Books [M]

ONE Book has ONE Publisher [1]

Publisher 1:M Book.

Complete the same 4-row format for the remaining relationships in the ERD illustrated in Figure 1.

The Unit 2 Seminar will have more information about writing these rules and for determining, in a one-to-many relationship, which is the “1” entity type and which is the “M” entity type.

Be sure the connectivity row (row 4) for each 1:M relationship has the correct direction. The rule with the multiplicity “many” will determine the direction.

For example, if the rule is: “ONE Publisher may publish MANY Books,” then Publisher is the “1” table and Book is the “M” table, so you would write the connectivity as: Publisher 1:M Books.

Use the four-row format to write the business rules and connectivity for each of the four binary relationships other than Publisher-Book in the enterprise data model pictured above in Figure 1.

Part 3: Primary Key/Foreign Key Placement

The primary key (PK) of a table is often named after the table. Example: ISBN-13 is chosen as the name of the primary key for the Book table; Published is the PK of the Publisher table.

For each entity set in the table below, give the primary key attribute(s) and the foreign key attribute(s) (if any).

Hint 1 – There may not be a foreign key attribute if the entity is not on the “M” side of a relationship.

Hint 2 – One entity type in the above table is not shown in Figure 1.

Part 4: Entity Relationship Diagram

Update the ERD from Question 2 to account for the M: N relationship between Book and Author. Start with the diagram in Unit 2 Publisher Q4A . Also, review the Unit 2 Visio Tutorial .

Part 5: Entity Relationship Diagram Including Review of Books by Customers Scenario

The report form below shows the fields to identify the review of books by customers. Follow either the top-down database design or the bottom-up database design approach to extend the ERD from Question 2. Provide the new ERD. Include a 4–6 sentence paragraph describing how you chose the approach you used to extend the ERD and the process followed.

An entity set table showing Primary and Foreign Key Attributes.

[Order Now]

Customer ID:

Customer Name:

Assignment Requirements

Be sure to use appropriate APA format and cite your textbook or other sources that you used in your paper.

Strategies , Maintaining , Therapeutic, Relationship ,Patient

Strategies for Maintaining the Therapeutic Relationship with A Patient

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!