1

For the attached ERD diagram: Provide a minimum of five business rules that will provide the...

Question

For the attached ERD diagram: Provide a minimum of five business rules that will provide the...

For the attached ERD diagram: Provide a minimum of five business rules that will provide the framework upon which your ERD will be designed and built. While there is a minimum number of rules, the expectation is that you will have rules documenting all relevant aspects of your database project. To achieve maximum credit for this section, your business rules should be comprehensive addressing your entire model.

Business rules are precisely written and unambiguous statements that are derived from a detailed description of an organization's operations. It includes entities, relationships, attributes, connectivity, cardinalities,and constraints.

Provider ExercisePlan Provider ID patient has_exercise- Exercise D last_name firsrt_name speciaity department ID_F descriptio

Provider ExercisePlan Provider ID patient has_exercise- Exercise D last_name firsrt_name speciaity department ID_F description repetitions Date Provider belongs to patient ID_FK office_phone Pain level Patient Patient has_provider patient ID last_name first_name Contains_exercise sSN DOB emai CarePlan --Care_has_provider Department care ID care_description prescirption_list 0care_start care_end provider_ID_FK department D department_nam + department heas department des department_loca -Department_plan_for_patient- patient CarePlan

Answers

In regards to the database design, business rules can be defined as the conditions that the database must meet. It describes how two entities are associated with each other.

For the given ERD diagram, the business rules can be stated as:

1. One or many Patient has one (and only one) ExercisePlan.

2. Zero or many Patient can have zero or many CarePlan

3. One or many Patient has one or many Provider.

4. One or many Provider can belong to one or many Department.

5. One or many CarePlan has one or many Provider.


Similar Solved Questions

1 answers
A mass of 0.11 kg is initially at rest at an unknown position on the -x...
A mass of 0.11 kg is initially at rest at an unknown position on the -x axis, xi. It begins accelerating towards x=0, with a constant acceleration of 2.50 m/s2 As it passes x= -7.30 m its speed is 5.18 m/s. Calculate the speed of the mass as it crosses the origin, x=0 (in m/sec). use the equation re...
1 answers
QUESTION 14 A manufacturing process requires small amounts of glue. The glue used in the production...
QUESTION 14 A manufacturing process requires small amounts of glue. The glue used in the production process is cl period cost. indirect material. direct material. miscellaneous expense. QUESTION 15...
1 answers
1) (Boy sledding on hill) A boy on a sled (total mass of boy-plus-sled m =...
1) (Boy sledding on hill) A boy on a sled (total mass of boy-plus-sled m = 34 kg) slides down a straight, snowy incline of length 4-236 m angled at a-15° with the horizontal. At the base of the hill is a tiny dip, after which the boy begins sliding up another straight hill, traveling a lern gth ...
1 answers
A plane is flying horizontally with speed 184 m/s at a height 2260 m above the...
A plane is flying horizontally with speed 184 m/s at a height 2260 m above the ground, when a package is dropped from the plane. The acceleration of gravity is 9.8 m/s2 . What is the horizontal distance from the release point to the impact point? Answer in units of m. A second package is thrown down...
1 answers
Use the given degree of confidence and sample data to construct a confidence interval for the...
Use the given degree of confidence and sample data to construct a confidence interval for the population proportion p. nequals=​195, xequals=​162; ​95% confidence A. 0.777less than<pless than<0.884 B. 0.789less than<pless than<0.873 C. 0.788less than<pless than<0....
1 answers
3. The Associated Press is a large entity that collects opinion polls online. Poll results are...
3. The Associated Press is a large entity that collects opinion polls online. Poll results are often accompanied by error margins (margins of error), which they explain the following way: For a poll of 1600 adults, the variation due to sampling error (i.e., the margin of error) is no more than three...
1 answers
How do you solve for variable w in the equation #v=lwh#?
How do you solve for variable w in the equation #v=lwh#?...
1 answers
Gen1 5). 8 pts. M and M2 are fixed in free space as shown. Where between...
gen1 5). 8 pts. M and M2 are fixed in free space as shown. Where between M and M2 can we place a test mass (M3 ) so that the resultant force on it will be zero? ie x = ? • finish the sketch M - 32 kg M2 - 2 kg 8 m...
1 answers
Brief Exercise 6-3 In its first month of operations, Bethke Company made three purchases of merchandise...
Brief Exercise 6-3 In its first month of operations, Bethke Company made three purchases of merchandise in the following sequence: (1) 188 units at $9, (2) 523 units at $10, and (3) 136 units at $11 Assuming there are 331 units on hand, compute the cost of the ending inventory under the FIFO method ...
1 answers
An analog signal, bandlimited to 10 Hz is corrupted by high-frequency noise. The spectrum of the...
An analog signal, bandlimited to 10 Hz is corrupted by high-frequency noise. The spectrum of the noise is from 30 Hz to 50 Hz. The noisy analog signal is sampled at 70 Hz. A digital lowpass filter is to be designed so as to remove the noise from the signal. For the filter design problem, what would ...
1 answers
28. On the diagram, indicate the following areas: H- High Pressure (.5pt) L - Low Pressure...
28. On the diagram, indicate the following areas: H- High Pressure (.5pt) L - Low Pressure (.5pt) ST - Strongest winds (.5pt) S Strong Pressure Gradient (.5pt) W - Weak Pressure Gradient (.5pt) Use an arrow to show direction of the pressure gradient. (5pt) Using the blank contour map below, draw and...
1 answers
1. Given the open-loop transfer function G(s)h(s) find the asymptotes, (b) find the breakaway points, if...
1. Given the open-loop transfer function G(s)h(s) find the asymptotes, (b) find the breakaway points, if any, (c) find the range of K for stability and also the ju-axis crossing points, and (d) sketch the root locus. (20 points) K/Ks+1)(s+2)(s+3)(s+4)) where 0 s K < 00, (a) K/[s(s+3)(s2+2s+2)] wh...
1 answers
The machine part ABC is supported by a frictionless hinge at B and a 20° wedge at C. Knowing that the static coefficient of friction at both surfaces of the wedge is 0.3. Determine: (a) the force...
The machine part ABC is supported by a frictionless hinge at B and a 20° wedge at C. Knowing that the static coefficient of friction at both surfaces of the wedge is 0.3. Determine: (a) the force P required to move the wedge. (b) The components of the corresponding reaction at B (c). Draw the no...
1 answers
An asset with a 5‐year MACRS* life will be purchased for $10,500. It will produce net annual benefits (i.e., revenues) o...
An asset with a 5‐year MACRS* life will be purchased for $10,500. It will produce net annual benefits (i.e., revenues) of $2000/year for 6 years, after which time it will have a net salvage value of zero and will be retired. The company’s total tax rate is 34% and they use an ieff (MARR)...
1 answers
(d) 0.75 Question 4 4 pts The angle of incidence is 0, =70°, and the angle...
(d) 0.75 Question 4 4 pts The angle of incidence is 0, =70°, and the angle of transmission is 04 =40°. Light is going from air to some mysterious material. What is the index of refraction of the mysterious material? (a) 0.571 (b) 0.643 (c) 0.940 (d) 1.46 Question 5 4 pts...
1 answers
Question 11: (a) (4 points) For each of the four Lewis dot structures in this picture,...
Question 11: (a) (4 points) For each of the four Lewis dot structures in this picture, please give one thing which is obviously wrong. Provide only one obviously incorrect thing per structure. örö 6) NO. 8- N= c) O: O=0 id) ONCE 00=8= 30 (b) (4 points) Using VSEPR theory, explain why the s...

-- 0.011441--