Upload the projects relational schemas here.
Show me the list of tables, columns, and constraints (PKs, FKs) created for your projects.
Data: 1)List attributes for your listed entities (PKs, FKs, Composite, and derived if any)
Professional Staff:
Staff ID Primary key
Staff Type (Picklist): (Pharmacist, Physician, Midwives, Nurse Practitioner, Registered Nurse, Patient, Medical Technician)
Name
Specialization
Non-Professional Staff:
Staff ID Primary key
Name
Type of staff (Picklist): (office Admin, Receptionist, Bookkeeper)
Patient Details:
Patient ID Primary Key
Contact Details
Medical History
Guardian Name
Insurance Details
Appointment:
Appointment id: Primary key
Patient id: Foreign key
Coverage Schedule:
Schedule ID (Primary Key)
Schedule Time
Staff Id (Foreign Key)
Patient Monthly details:
Statement id (Primary Key)
Patient id (Foreign Key)
Balance
Payments Received
Daily Laboratory Log
ID (Primary key)
Date
Records
Master Schedule
Practitioner ID (Primary)
Patient Id (Foreign)
Date
Walk-ins
Insurance Provider
Insurance Id (Primary Key)
Clinic Information
Practioner Information
Visit ID (Foreign key)
Type of Visit
Operating Log
Log id (Primary key)
Date
Surgery Details
Operating Room schedule
Schedule Id (Primary Key)
Date
Surgery Info
Delivery Log
Log id (Primary key)
Delivery Information
Date
Recovery Room Log
Log id (Primary Key)
Recovery Details
Date
Monthly Activity Log
Report Id (Primary Key)
Month-Year
Activity Centric Details
Facility
Facility Id (Primary Key)
Type of Facility
Prescription
Rx Number (Primary Key)
Patient id (Foreign Key)
Patient Information
Doctor Name
Total Price
Balance Due
2)List relationships (1:1, 1:M, and M:M if any)
§Staff – Coverage Schedule (One to Many Relationship)
§Patient – Appointment (One to Many Relationship)
§Patient – patient Monthly statement (One to Many Relationship)
§Practitioner Provider’s statement (One to Many Relationship)
§Professional staff Appointment (One to Many Relationship)
Please make sure Physician, Midwives, NP, RN should all be in one entity called Staff. How would you operate the visits? A patients calls in to schedule an appt. a Staff will conduct the visit. Visit will use many rooms (1: M) Visits will have referral, Visits will incur charges Visits will produce prescriptions (for Medicine or for Labs), diagnostics, procedures, labs.
Tool: Please use oracle
Display relational schemas here Show me list of tables, columns, and constraints (PKs, FKs)
/0 Comments/in Programming /by bonniejecintaQuestion
Upload the projects relational schemas here.
Show me the list of tables, columns, and constraints (PKs, FKs) created for your projects.
Data: 1)List attributes for your listed entities (PKs, FKs, Composite, and derived if any)
Professional Staff:
Staff ID Primary key
Staff Type (Picklist): (Pharmacist, Physician, Midwives, Nurse Practitioner, Registered Nurse, Patient, Medical Technician)
Name
Specialization
Non-Professional Staff:
Staff ID Primary key
Name
Type of staff (Picklist): (office Admin, Receptionist, Bookkeeper)
Patient Details:
Patient ID Primary Key
Contact Details
Medical History
Guardian Name
Insurance Details
Appointment:
Appointment id: Primary key
Patient id: Foreign key
Coverage Schedule:
Schedule ID (Primary Key)
Schedule Time
Staff Id (Foreign Key)
Patient Monthly details:
Statement id (Primary Key)
Patient id (Foreign Key)
Balance
Payments Received
Daily Laboratory Log
ID (Primary key)
Date
Records
Master Schedule
Practitioner ID (Primary)
Patient Id (Foreign)
Date
Walk-ins
Insurance Provider
Insurance Id (Primary Key)
Clinic Information
Practioner Information
Visit ID (Foreign key)
Type of Visit
Operating Log
Log id (Primary key)
Date
Surgery Details
Operating Room schedule
Schedule Id (Primary Key)
Date
Surgery Info
Delivery Log
Log id (Primary key)
Delivery Information
Date
Recovery Room Log
Log id (Primary Key)
Recovery Details
Date
Monthly Activity Log
Report Id (Primary Key)
Month-Year
Activity Centric Details
Facility
Facility Id (Primary Key)
Type of Facility
Prescription
Rx Number (Primary Key)
Patient id (Foreign Key)
Patient Information
Doctor Name
Total Price
Balance Due
2)List relationships (1:1, 1:M, and M:M if any)
§Staff – Coverage Schedule (One to Many Relationship)
§Patient – Appointment (One to Many Relationship)
§Patient – patient Monthly statement (One to Many Relationship)
§Practitioner Provider’s statement (One to Many Relationship)
§Professional staff Appointment (One to Many Relationship)
Please make sure Physician, Midwives, NP, RN should all be in one entity called Staff. How would you operate the visits? A patients calls in to schedule an appt. a Staff will conduct the visit. Visit will use many rooms (1: M) Visits will have referral, Visits will incur charges Visits will produce prescriptions (for Medicine or for Labs), diagnostics, procedures, labs.
Tool: Please use oracle
TCH-539 Introduction to Educational Research
/0 Comments/in Writing /by bonniejecintaQUESTION
Choosing a Research Topic
Topic: Integrating Technology in the Early Childhood classroom.Research fuels innovation and efforts to increase outcome in multiple professional fields. Every professional field thrives on research and innovation. In order to establish a solid understanding of a field of study, professionals benefit from understanding the foundations of research and how research applies to practical applications in that field.
During this course, you will conduct an action research study. According to the text, successful action research follows a standard four stage process:
Clarifying vision and targets
Articulating theory
Complete a 150-250 word rationale for each area of research and include the following:
Why you selected the area of research and topics to investigate.
The research approach you believe has the greatest potential for achieving your goals.
How your research will contribute to student success and educator.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.
eng 112- Rhetorical Triangel
/0 Comments/in Writing /by bonniejecintaQUESTION
This discussion board allows you to practice identifying elements of the rhetorical triangle in a Coca-Cola commercial. Take your time here, rewatch the commercial as many times as you need to, and think about your answers. Learning to identify the elements of the rhetorical triangle whenever we read or watch something makes us better consumers of information and better critical thinkers.
Watch the Coca-Cola commercial “Hello Happiness” (opens in new window) at
Using this commercial, write a minimum 250-word post that evaluates the rhetorical triangle. Be sure to answer all of the following questions. Do not number your answers with numbers, but make sure your wording makes it clear which question you are answering (Don’t forget to include an introduction and conclusion and appropriate paragraph breaks). When you have finished your post, respond to the posts of two of your peers; each response should be at least three sentences.
Who is the writer of this commercial?
What code/language is used in creating this commercial?
Based on the language used (and other parts of the code, or elements of the message), who is the audience for this commercial?
How does the creator of the commercial establish credibility? How does the creator create trust or goodwill between itself and the audience?
Lehman College Criminal justice POL 217
/0 Comments/in Law /by bonniejecintaQuestion
part 1)Please read Jared Diamond Chapter 2 (the PDF on the Course Content section) about traditional justice in New Guinea and answer/ respond to the following questions.
-How is justice different in New Guinea than in western industrialized societies like the US, Canada and Europe?
-What were the consequences for the driver if the victims family did not accept his apology and peace offering?
-What is Jared Diamond’s critique of modern western justice systems?
-Which system is better for victims? Traditional justice, or modern western justice systems?
-What can the US and other countries learn from this example?
Part2) The summer of 2020 saw a surge in violent crime in NYC and nation wide and many competing theories emerged to explain this violence. Listen to the Podcast “A Surge in Shootings” from August 24th, 2020 https://www.nytimes.com/2020/08/24/podcasts/the-daily/gun-violence-new-york.html .
According to the podcast, what are the three competing explanations for what was driving the surge in violent crime in NYC that summer? Which of these theories do you find more convincing, and have you seen any evidence from news stories or your personal experience as to why this might be driving crime up? Do you feel that any of these theories is more or less compelling 2 years later?
Debates about the root causes of a rise or decrease in crime are important because they influence policy decisions about what the police, courts and government should do. What are the policy implications of the theory you find most convincing for the rise in crime and do you think that this will address the root issue?
Taysir discussions Hed 158
/0 Comments/in Writing /by bonniejecintaQUESTION
Discussion 11
1. Watch the following videos.
2. From the videos above, answer the following questions:
Discussion 12
1. Watch the following videos.
2. From the videos above, answer the following questions:
3. Reply to a classmate.
Do not reply to a reply.
20 points for your original post and 10 points for replying to your classmates.
ORGANIZATIONAL POLICIES AND PRACTICES TO SUPPORT HEALTHCARE ISSUES
/0 Comments/in Health Medical /by bonniejecintaQUESTION
Quite often, nurse leaders are faced with ethical dilemmas, such as those associated with choices between competing needs and limited resources. Resources are finite, and competition for those resources occurs daily in all organizations.
In this Discussion, you will reflect on a national healthcare issue and examine how competing needs may impact the development of polices to address that issue.
To Prepare:
Provided resources
Option 2 has to be done
/0 Comments/in Science /by bonniejecintaQUESTION
Detalls
below.
This is the fourth podcast you will be summarizing as a graded assignment (others can be summarized for extra credit). For this assignment, you may opt for one of two podcasts presented
Your summary should be between 300 and 500 words (1-1.5 page, 1.5 spaced, Times Hew Roman) and should include the main points you hear on the chosen podcast.
For full credit, please include:
3) Your personal take on this podcast
Option 1: Crabs All the Way Down
Podcost link: Crabs All the Way Down. Radiolab E
The entire podcast is divided into two stories. Though initially they seem to be unrelated, they are shown to be connected at the end of story #2. Your focus should be mostly on story #2 (which discusses convergent evolution, odaptive radiation) but should bring in the lesson learned from the first story. Please summarize it as such.
Rodiolab summary:
This week we examine one of nature’s most humble creations: crabs. Turns out when you look closely at these little scuttlers, things get surprisingly existential – about how to come into being.
Option 2: The Mosquitoes are Winning (https://www.nytimes.com/2023/10/05/podcasts/the-daily/mosquitos-malaria.html)
Podcost link option 2: The Masauitoes Are Winning | The Daily
The Daily summory:
For decades, the world seemed to be winning the war against mosquitoes and tamping down the deadly diseases they carried. But in the past few years, progress has not only stalled, it has reversed. Stephanie Nolen, who covers global health for The Times, explains how the mosquito has once again gained the upper hand in the fight.
The Affordable Care Act and The Provisions of Medication Access and Cost Discussion
/0 Comments/in Health Medical /by bonniejecintaQuestion
Make a peer response to the following response:
The RN would discuss the need for hospitalization with this patient by first detailing how important it is to monitor the patient and make sure the antidote, in this case Acetylcysteine, gives the appropriate therapeutic effects for the overdose. Acetaminophen can cause extensive liver damage because the glutathione pathway is overwhelmed by too much of acetaminophen’s metabolite, NAPQI. This toxic compound can accumulate in the liver and cause damage like hepatic necrosis. Apart from the physiological concern, the nurse must also take the patient’s report of wanting to die seriously because this demonstrates that she has suicidal ideations and that she is having something in her life negatively affecting her mental health. In this case, it is the nurse’s responsibility to understand what caused the patient to make this decision, does she still actively want to harm herself, is she a harm to others, and if she has a support system of friends or family to help her through this difficult time. An alternative to a hospitalization in this case would most likely involve Mimi going to therapy to get to the root of the issue. For example, since she is a first generation student this can lead to her feeling an overwhelming responsibility to succeed and she does come from a culture where there is a negative stigma surrounding mental health issues.
NOW.. follow the instructions for the following discussion:
What are your views on the Affordable Care Act (ACA), as it relates to the provisions of medication access and cost?
HUM110 GCCCD Where Does Art Come From Questions
/0 Comments/in Writing /by bonniejecintaQuestion
part one
d7
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.part two
unit 5 Project For: Accounting for Managers: ACG510 ACG510-2401B-02
/0 Comments/in Business & Finance /by bonniejecintaQUESTION – QUESTION
Assignment Details
This IP builds upon your work in all previous units.
In this project, you have been analyzing and interpreting the publicly traded company, American Eagle Outfitters, Inc. (located in Appendix A: American Eagle Outfitters, Inc., 2020 Annual Report of the required textbook: Financial Accounting).
Unit 1: Industry and Business Structure
Unit 2: Current Asset Analysis
Unit 3: Inventory and Long-Term Asset Analysis
Unit 4: Long-Term Liabilities and Equity
Unit 5: Overall Company Analysis and Conclusion
Do not discuss the financial analysis line by line; instead, identify the significant findings.
Discuss the meaning of the findings.
After you have completed Unit 5’s comprehensive financial analysis, you must gather all of your Individual Projects from previous units (5 pages per unit = 25 pages total) for your financial analysis and interpretation course project. Be sure to properly cite sources using the APA format as well as include references and in-text citations.