Requirements Specification (this is a fictional scenario)

A large business, with several medical practices, contacted your company to create a database design. You received the task to investigate if there is a need for a hierarchy based on the specifications below, and to create the hierarchy analysis if needed. You must not create the entire analysis but only the aspects related to the hierarchy as described in the instructions, class lectures and sample examples. This is the relevant fragment from the requirements specification related to your task.

In the practice we have medical doctors, nurses, staff and other employees (e.g. cleaners for which we just keep contact information: name, SSN, phone).

For the doctors we keep the name, SSN, phone, email, main specialty, medical school. A doctor may have appointments and write prescripions. For nurses we keep the name, SSN, phone, and nurse program they completed. A nurse will prepare the patient during the visit and may collect various data. For staff we keep the name, SSN, phone and their role (e.g. receptionist, scheduler, accountant). Based on the practice policies, a nurse will not be allowed to perform staff duties.

The company wants to keep a log with who was working daily, between what hours and in which role. The company also wants to fast identify the role of a person in the organization (e.g. doctor, nurse, ...), based on the last name or id.

• Which is the supertype?
• SUPERTYPE_ENTITY_NAME (it might be in the current model or it might be a new entity)
• Which are the subtypes?
• SUBTYPE_ENTITY_NAME, SUBTYPE_ENTITY_NAME, SUBTYPE_ENTITY_NAME... (they might be in the current model or some might be new entities) Do not include subtypes that are not needed. You must have a justification why you need a subtype to be in the list. Including a subtype that does not store anything specific (attribute or relationship) will be considered a mistake.
• List the common attributes for the supertype and its PK:
• SUPERTYPE (PRIMARY_KEY, ATTRIBUTE, ATTRIBUTE, ....)
• [Composite/Simple/Surrogate] Primary Key: PRIMARY_KEY
• List the specific attributes for the subtypes and their PKs/FKs:
• For each subtype provide:
• SUPERTYPE (PRIMARY_KEY, ATTRIBUTE, ATTRIBUTE, ....)
• Primary Key: PRIMARY_KEY
• Foreign Key: FOREIGN_KEY references primary key ... in ...
• List the hierarchy relationships:
• ENTITY relation ENTITY (repeat as needed)
• Analyze the completeness constraint:
• The hierarchy has complete/partial subtypes, because ...
• Analyze the disjoint constraint:
• The hierarchy has disjoint/overlapping subtypes, because ...
• Do you need a subtype discriminator? Explain.
• The hierarchy needs (does not need) a subtype discriminator because ...
• Describe the subtype discriminator (if needed):
• The subtype discriminator is: .... with the values ...
• Entity Relationship Diagram
• After you finished the hierarchy analysis you must draw the ERD in MySQL Workbench and include in your report a signed screenshot. (to sign a screenshot you write your name in a text object visible in the screenshot; crop the image to show only the ERD and the text object)
• Draw the hierarchy using 1:1 relationships, add the correct constraints symbol and the subtype discriminator if needed.

In what follows, use any of the following tests/procedures: Regression, multiple regression, confidence intervals, one-sided t-test or two-sided t-test. All the procedures should be done with a 5% P-value or a 95% confidence interval.

Upload the data HeartRate_Exercise. These data are based on 45 randomly chosen high school students.

SETUP: It is believed that high school students who do not exercise have a heart rate (at rest) above 70. Given the data your job is to confirm or disprove this belief.

1. What test/procedure did you perform?

a. One-sided t-test

b. Two-sided t-test

c. Regression

d. Confidence interval

2. What is the P-value/margin of error?

a. 1.56075E-45

b. 3.1215E-45

c. 6.149555

d. 8.065421

e. None of these

3. Statistical interpretation

a. Since the P-value is very small, we are confident that the average heart rate is above 70.

b. Since the P-value is very small, we are very confident that the averages are different.

c. Since the P-value is very small, we are confident that the slope of regression line is not zero.

d. We are 95% certain that the confidence interval is [70.268, 86.399].

e. None of these

4. Conclusion

a. Yes, I am confident that the above assertion is correct.

b. No, we cannot claim that the above assertion is correct.

weekly exercise (hours) Heart Rate at rest
16      55
2       76
3       78
17      46
19      76
3       68
19      61
12      68
15      48
2       71
4       72
2       81
10      64
9       61
0       73
0       84
5       72
16      58
0       77
19      54
4       79
8       73
6       85
17      57
2       75
7       85
13      73
3       75
8       84
6       52
5       60
18      69
1       66
19      90
19      64
5       65
0       74
2       55
18      67
2       78
0       71
18      76
11      76
13      84
0       91

Brad and Jen are husband and wife. Five years ago, Brad and Jen, together with their friend, Angie, set up a company called Organics Farm Pty Ltd (Organics Farm) to operate an organic farming business in Queensland. The three of them met at the University where Brad and Jen were each completing a degree in agriculture and Angie a degree in commerce. All three have a passion for organic produce. When they set up the company after completing their university studies, it was agreed by the three of them that they would have equal shares in the company and that they would all be directors. It was also agreed that Brad and Jen would be responsible for the day to day running of the farm whilst Angie would be responsible for the finances and the marketing and sale of the organic produce. The business has been running successfully and it now has a strong market presence throughout Australia. During one of Organic Farm’s board meetings, Angie proposed that they look towards expanding into the Asian market. Angie explained that she had done some research and that her investigations showed there was a demand for organic produce. She suggested using the company’s surplus funds to conduct further market research into the export market. Brad and Jen voted against this proposal because they wanted to use the surplus funds to donate to the local school to build a swimming pool which Brad hoped would be named after his grandfather. Angie queried whether this was an appropriate use of corporate funds given that the demand for organic produce was just starting to grow in Asia and that Organics Farm could really capitalise on this growing demand. But Angie’s concerns were dismissed by Brad and Jen. Shortly after this board meeting, Brad and Jen called a general meeting of Organic Farm’s shareholders and a resolution was passed removing Angie as a director. In the next board meeting, Brad and Jen resolved to increase directors’ remuneration and to stop paying dividends.

(a) What action can Angie take against Brad and Jen in relation to the donation of funds to the local school? Angie believes that there has been a breach by Brad and Jen of their common law and statutory duty to act in good faith, in the best interests of the company and for a proper purpose.

(b) What action can Angie take against Brad and Jen for the non-payment of dividends?

For each variable:

Construct a frequency distribution

Calculate appropriate measures of central tendency

Calculate appropriate measures of dispersion

Write a sentence or two summarizing the frequency distribution, central tendency, and dispersion of each variable

Each item is worth 10 points for a total of 40 points.

Survey Items:

1. What is your age in years? (Values are actual ages.)

2. Educational level

                        0. Less than HS

                        1. High School

                        2. Jr. College

                        3. Bachelor's degree

                        4. Graduate school

3. Gender

                        1. Male

                        2. Female

4. "White people have a right to keep Blacks out of their neighborhoods. "

                        1. Agree strongly

                        2. Agree slightly

                        3. Disagree slightly

                        4. Disagree strongly

Please see the next page for the dataset.

Segregated

Case     Age    Degree    Sex    Neighborhoods

1         29       3          2                    4

2         38       3        2                    4

3         63       2        2                    4

4         30       1        1                    3

5         38       1        1                    2

6         48       3        1                    3

7         28       1        2                    2

8         30       3        2                    2

9         25       0        2                    3

10        35       1        1                    4

11        73       0        2                    3

12        55       3        1                    4

13        70       4        2                    4

14        50       1        2                    1

15        62       0        1                    2

16        45       3        1                    2

17        45       2        2                    4

18        35       1        1                    2

19        74       1        2                    4

20        32       0        1                    1

21        36       1        1                    4

22        29       1        2                    2

23        42       3        2                    1

24        40       1        2                    4

25        35       1        2                    3

26        68       3        2                    4

27        38       1        2                    2

28        32         2        2                    4

29        50       0        2                    3

30        26       1        2                    4

The results of both sections of your employment examination have finally been received, and you were offered the position. You have a few important decisions to make before you can formally accept or decline the position.

I. School Versus Work A. The school you would like to attend costs $100,000. To help finance your education, you need to choose whether or not to sell your 1,000 shares of Apple stock, 1,000 EE Savings Bonds (with $100 denominations and 4.25% coupon rate) that are five years from their 30-year maturity date, or a combination of both. Provide the appropriate data and calculations that you would perform to make this decision. B. What are the advantages and disadvantages of selling a combination of stocks and bonds? Be sure to support your answers. C. Suppose that you choose to sell your stocks, bonds, or a combination of both. What is your choice, and what is your financial reasoning behind this choice? Consider supporting your answer with quantitative data. D. Suppose that you choose to accept the job. What is your financial reasoning behind this choice? Be sure to support your answer with quantitative data. II. Bonus Versus Stock

A. The company has offered you a $5,000 bonus, which you may receive today, or 100 shares of the company’s stock, which has a current stock price of $50 per share. Mathematically, what is the best choice? Why?

B. What are the advantages and disadvantages of each option? Be sure to support your answers.

C. What would you ultimately choose to do? What is your financial reasoning behind this choice? Consider supporting your answer with quantitative data.

III. Compliance

A. While investigating the shares offered to you by your potential boss, you discover that the company you are considering working for is not registered as required under the Securities Act of 1933. How does this influence you as a potential employee and as a potential shareholder? Be sure to reference any applicable statutes or laws.

B. You know that accepting this job may eventually lead to a promotion into the role of the financial manager. As the potential financial manager, what federal and shareholder requirements would you need to be familiar with in order to ensure that you are being completely compliant?

Crane Co. provides music lessons to many clients across the city. The following information is available to be used in recording annual adjusting entries at the company’s September 30, 2021, year end:

Prepare the adjusting journal entries. (Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to the nearest whole dollar, e.g. 5,275. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

Determine which ethical perspective is primarily reflected in each of the arguments below and, in 1-2 sentences for each argument, explain why it corresponds to the ethical perspective you selected..

Ethical Perspectives:

A = Consequentialism
B = Duty Ethics/Deontology
C = Virtue Ethics
D = Moral Relativism

Arguments:

1. Free health care should be available to all people. After all, if that were the case, it would benefit everyone.
2. Character education should be part of the public school system in the United States. We need to cultivate integrity in our children, and the public school system should play a role in this important process.
3. Although many societies have practiced human sacrifice, human sacrifice wasn't considered wrong, even though we believe it is wrong in our culture. So, human sacrifice within those cultures wasn't really wrong.
4. Same-sex marriage is right because the polls show that most Americans favor it, even if that is not the case in other countries.
5. The legalization of same-sex marriage is wrong because the government has no right to legally sanction any form of personal relationship except one: marriage relationships between a man and a woman. That is the only type of relationship that can lead to procreation, and the state has a legitimate interest in procreation. Thus, the state has a duty to support marriage between a man and a woman, and a duty to refrain from getting legally involved in other types of relationships.
6. Dropping the atomic bombs on Hiroshima and Nagasaki was wrong because those acts violated the right to life of many innocent people, and we should protect those rights.
7. Dropping the atomic bombs on Hiroshima and Nagasaki was right because those acts ended the war faster, and thus made the world a safer place.
8. We need to do a background check and to collect some character references on Mr. Jones before we hire him.
9. He doesn't have the right character and temperament to be a state governor. He has been involved in corruption scandals, known to be dishonest, and has problems controlling his anger.
10. Sure, slavery is wrong in our society because we all agree it's wrong. However, slavery isn't absolutely wrong because many societies have practiced slavery.

PacRim Careers provides training to individuals who pay tuition directly to the business. The business also offers extension training to groups in off-site locations. Additional information available at the December 31, 2020, year-end follows:

1. An analysis of the company’s policies shows that $1,330 of insurance coverage has expired.
2. An inventory shows that teaching supplies costing $530 are on hand at the end of the year.
3. The estimated annual depreciation on the equipment is $9,000
4. The estimated annual depreciation on the professional library is $4,860.
5. The school offers off-campus services for specific employers. On November 1, the company agreed to do a special six-month course for a client. The contract calls for a monthly fee of $870, and the client paid the first five months' revenue in advance. When the cash was received, the Unearned Extension Revenue account was credited.
6. On October 15, the school agreed to teach a four-month class for an individual for $1,280 tuition per month payable at the end of the class. The services to date have been provided as agreed, but no payment has been received.
7. The school's two employees are paid weekly. As of the end of the year, three days' wages have accrued at the rate of $130 per day for each employee.
8. The balance in the Prepaid Rent account represents the rent for three months: December, January, and February.