About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Algebra See all

Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all

Teaching Since:	Jul 2017
Last Sign in:	304 Weeks Ago, 3 Days Ago
Questions Answered:	15833
Tutorials Posted:	15827

Education

MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002

Experience

Manager Planning
WalMart
Mar-2001 - Feb-2009

Category > Computer Science Posted 12 Oct 2017 My Price 10.00

Please let me know if the highlighted part is correct. Those are the business rules i created

There are two parts in this assignment.

Part 1: New Wave Therapy
New Wave Therapy is an office of physical therapists which tracks its patients using a spreadsheet. The office wants to upgrade to using a relational database. You have been tasked with this conversion, and need to convert this flat field design into a relational database design.

New Wave Therapy has given you its current spreadsheet design, which contains the following fields (columns).

Patient ID
Patient First Name
Patient Last Name
Patient Phone
Patient Email
Injury Type Name
Injury Type Description
Average Recovery Days
Expected Recovery Date
Exercise 1 Name
Exercise 1 Description
Exercise 1 Times Performed
Exercise 2 Name
Exercise 2 Description
Exercise 2 Times Performed
Exercise 3 Name
Exercise 3 Description
Exercise 3 Times Performed

The office has also given you the following business rules, which are incomplete and are not all necessarily structural.

Patients have a type of injury.
There are many types of injuries, some examples include neck pain, thoracic pain, and knee pain.
Each type of injury carries with it an average number of days it takes for full recovery.
To aid the office in requesting insurance renewals and tailoring treatment appropriately, a date is estimated for each patient as to when they would fully recover.
Three exercises are given to each patient for them to complete daily, at-home; the exercises are periodically changed as healing progresses.
Patients are asked to track and report the number of times they complete each exercise.

1. To get started, create a complete list of business rules that you will use as a basis for your logical diagram. Your list of business rules should specify all entities, relationships, optionality constraints, and plurality constraints, and must make provision for the data and business rules given to you by the New Wave Therapy office. There are many solutions that will correctly make provision for the given data and business rules.

Each patient can have multiple injuries
Each injury can take more than one days to recover
Each patient must have 3 exercises
Each patient can track multiple attendance
Each attendance is for 1 patient

2. Now create a logical entity-relationship diagram (ERD) that illustrates the relational database design described by the business rules in #1. All entities should be normalized to BCNF. Recall that logical ERDs contain SQL-based constraints on the attributes, including primary and foreign key constraints.

Part 2: Disorders
The following incomplete list of business rules describe the relationships between some of the different types of disorders to the human body.

1. Thoracic disorders can be hernias, spine injuries, or neither.

2. Musculoskeletal disorders and gastrointestinal disorders are all disorders, but not all disorders are musculoskeletal or gastrointestinal.

3. Knee disorders are patellar dislocations, knee dislocations, Plica syndrome, or none of these.

4. Structural gastrointestinal disorders can be diverticulosis, colitis, or neither.

5. Gastrointestinal disorders must be either functional gastrointestinal disorders or structural gastrointestinal disorders.

6. Thoracic disorders and knee disorders are musculoskeletal disorders.

7. Constipation and irratible bowel syndrome are functional gastrointestinal disorders.

All relationships described in these rules are specialization-generalization relationships. These rules also reflect the entities and relationships that exist in the real-world.

1. Create a complete list of business rules that are consistent with the incomplete list given above. Try to order the rules logically, either starting at the bottom of the hierarchy working upward, or from the top of the hierarchy working downward. This list should make provision for all entities and relationships given in the above list, and there are many solutions that do so.

2. Develop an extended entity-relationship diagram (EERD) that illustrates the relational database design described by the business rules in #1. The diagram should include the primary key of each table in order to demonstrate correct implementation of specialization-generalization. While EERDs may well contain other attributes, in this assignment you need not include them because they are not described in the business rules. You should use legal database identifiers such as Thoracic_disorder or Colitis in your EERD.

Your submission will be evaluated according to the following grading rubric.

	Grade	Qualities Demonstrated by the Assignment Submission	Grade Assigned
Content (70%) Measures the quality of the content in the assignment	A+ è 100	The content demonstrates exceptional understanding of all relevant subject matter and its inter-relationships. All major relevant issues are thoroughly covered, and all content is very focused and on-topic. There is no known way to improve the content, and there are absolutely no technical or coverage errors present.
	A è 96	The content demonstrates exceptional understanding of all relevant subject matter and its inter-relationships. All major relevant issues are thoroughly covered, and all content is very focused and on-topic. At most one insignificant technical or coverage error may be present
	A- è 92	The content demonstrates deep understanding of all relevant subject matter and its inter-relationships. All major relevant issues are covered, and all content is on-topic.
	B+ è 88	The content demonstrates understanding of all relevant subject matter and its inter-relationships. Almost all major relevant issues are covered, and the content is at least reasonably on-topic.
	B è 85	The content demonstrates understanding of most relevant subject matter and its inter-relationships. Almost all major relevant issues are covered, and all content is at least reasonably on-topic.
	B- è 82	The content demonstrates moderate understanding of much relevant subject matter and its inter-relationships. There is reasonable coverage of major relevant issues, and the content is at least reasonably on-topic.
	C+ è 78	The content demonstrates some understanding of relevant subject matter and its inter-relationships. Some major relevant issues are covered, and at least some content is on-topic.
	C è 75	The content demonstrates understanding of a small portion of the relevant subject matter and its inter-relationships. Some major relevant issues are covered, and at least a small portion of the content is on-topic.
	C- è 72	The content demonstrates little understanding of and insight into the relevant subject matter and its inter-relationships. A small portion of the major relevant issues are covered. The focus of the content may be off topic or on insubstantial or secondary topics
	D è 67	The content demonstrates almost no understanding of or insight into the relevant subject matter and its inter-relationships. Almost none of the major relevant issues are covered, and the content may be almost entirely off-topic.
	F è 0	The content demonstrates no understanding of or insight into the relevant subject matter and its inter-relationships. No major relevant issues are covered, and the content is entirely off-topic.
Exposition (30%) Measures how well the content is expressed	A+ è 100	The presentation of all ideas and designs is exceptionally clear and persuasive; the entire submission is exceptionally organized. There is no known way to improve the clarity or organization of the submission.
	A è 96	The presentation of all ideas and designs is exceptionally clear and persuasive; the entire submission is exceptionally organized. There may be at most one insignificant way to improve the clarity or organization of the submission.
	A- è 92	The presentation of all ideas and designs is very clear and persuasive; the entire submission is very organized.
	B+ è 88	The presentation of all ideas and designs is clear and persuasive; the entire submission is organized.
	B è 85	The presentation of most ideas and designs is clear and persuasive; most of the submission is organized.
	B- è 82	The presentation of most ideas and designs is generally clear; most of the submission is reasonably organized.
	C+ è 78	Some parts of the submission are hard to understand; some parts are disorganized.
	C è 75	About half of the submission is hard to understand; about half is disorganized.
	C- è 72	Most parts of the submission are hard to understand; most parts are disorganized.
	D è 67	Almost all of the submission is hard to understand and disorganized.
	F è 0	The entire submission is hard to understand and disorganized.

Attachments:

1507811972-HashmiIram_assign3_health.doc

Answers

SophiaPretty

(5)

Status NEW Posted 12 Oct 2017 12:10 PM My Price 10.00

----------- ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.