You recently discover that issues for a hospital health information systems project are not being documented or properly communicated throughout the organization. Discuss your approach documenting issues and concerns, and communicating them

HIMA410-Workforce analytics is a common approach to business operations because it is based on the analysis of employee and staff data. This approach can help businesses find answers to key workforce and workflow challenges, and solutions. Research the types of workforce analytics and discuss how they can be applied to common HIM, informatics and analytic roles.      HIMA360-Project managers are often responsible for distributing and communicating project results and ongoing updates. You recently discover that issues for a hospital health information systems project are not being documented or properly communicated throughout the organization.This is causing rising issues with resistance to change and comfortability with the new system. Discuss your approach documenting issues and concerns, and communicating them. Also discuss the importance of training and other activities that can ease user concerns.                                                                                          HIMA460-Data governance programs focus on different areas based on organizational needs. Trinity Hospital has chosen to focus on the laboratory data, as a model for other departments throughout the hospital.If all areas of a data governance program are not met, is it truly data governance?What are some key elements you would consider to establish standards for any data governance program?

What events eroded support for President Bushs policies during his second term?

 
Discussion Board: A Nation Divided
88 unread replies.88 replies.NOTE: Be sure to get your initial post in by the usual Thursday deadline and the reply in by Friday (the last day), which is a day earlier than usual.Normally, this week’s discussion would be based around the idea of globalization, which is important especially given the recent challenges surrounding COVID-19 and its global transmission. Yet, as I was looking through chapter 28, I realized I wanted to ask questions about a lot of different topics rather than just one topic. Thus, I turned to the focus questions at the beginning of the chapter, and realized they are great questions and things I really hoped you picked up on while reading. So I will post all 6 questions, and I would like for you to choose 2 to write about in this week’s discussion. This will give us an opportunity to read about many different topics and respond to classmates who wrote about something different.So be sure to include the question at the beginning of each of your two answers, give a thorough analysis of the question IN YOUR OWN WORDS (I would rather you not use quotes for this), and reply to a classmate that answered a different question than you answered. Here are the 6 questions (remember, choose 2):1. What events eroded support for President Bush’s policies during his second term?2. What were the economic practices that contributed to the crisis of 2008?3. What kinds of change did voters hope for when they elected Barack Obama?4. What were the major challenges of Obama’s first term?5. What was divisive about Donald Trump’s campaign and early presidency?6. What were the prevailing ideas of American freedom at the beginning of the 21st century? 

“Economic Equilibrium through Different Lenses: A study of Utility, Pain, Pleasure, and Scarcity.”

Description

Write an essay of at least 5 pages on the following:

NOTE: The point of the essay is not to work through the details of the different theories; nor to judge each, on its own, or in relation to the others, and to other lines in economic thought: are they right or wrong? The point is to think through the ways in which they define what economic theory should be, what it should include and exclude, and how it should study what needs to be studied.

Jevons founds his economic theory on the calculus of pain and pleasure adopted from Bentham. Walras and Menger found their theories on scarcity: they define the economic as the situation that arises when the quantity of goods is insufficient to satisfy all the wants to be satisfied by those goods.
I don’t think that there is any fundamental opposition between these two approaches: both employ the concept of utility, and, especially, that of marginal utility (though none of the three – Jevons, Menger, Walras – uses the term “marginal utility” itself). They are all looking for a mechanism to bring about an equilibrium of supply and demand. Nonetheless, pain and pleasure on the one hand, scarcity on the other, are not the same. So:
What is similar, and what is different in the starting-points themselves – pain and pleasure, scarcity? Is there a difference in their focus? Does one point you in a different direction than the other? What is similar in the mechanisms? Is there anything significantly different? Will there be significant differences in the result?
(Note: later neoclassical economics, on the whole, goes for the scarcity approach; and, for example, Robbins, Hicks and Mises all reject pain and pleasure at least in their Benthamite form. You don’t need to take this up, but it’s worth remembering.)
Some references:
Jevons, W” The Theory of Political Economy, 1 or 2nd edition.
Walras, L ” Elements of Theoretical Economics 3rd edition
Menger,C” principles of Economics

Your company (the parent company) has tasked you with identifying the best organizational structure for the start-up.What type of organizational structure are you recommending and why? What are the key advantages of the structure you are proposing? Are there any disadvantages?

Begin reading Chapters 10, 11 and 12 in course textbook
Robbins, S. P., & Coulter, M. (2016). Management, 13th Edition. Pearson Education.
Part a 

Why do organizations need to have structure?
How do organizations choose an organizational structure?

Part b
You are the Chief Human Resources Officer (CHRO) of a large tech company in Silicon Valley and your company has just acquired a small start-up company that has recently developed an apparatus that can introduce a drug into the human body subcutaneously without the use of a needle. This small start-up has ten employees and all are either programmers or medical researchers including the two founders of the start-up. The two founders, Mike and Ike, are both 25 years old and are not savvy business people.
Your company (the parent company) has tasked you with identifying the best organizational structure for the start-up.
You are now making your presentation to the Board as to what organizational structure you’re recommending to be implemented at the start-up company. Some members of the Board have asked you the following questions:
(For this role-play you will answer the following questions…)

Do we need to develop an organizational structure for the start-up company or could it just remain the same as the management structure of the parent company?
What type of organizational structure are you recommending and why?
What are the key advantages of the structure you are proposing? Are there any disadvantages?

You are a medical professor in charge of creating college assignments and answers for medical college students. You design and conduct lectures, evaluate student performance and provide feedback through examinations and assignments. Answer each question separately. Include and Introduction. Provide an answer to this content

Begin reading Chapters 10, 11 and 12 in course textbook
Robbins, S. P., & Coulter, M. (2016). Management, 13th Edition. Pearson Education.
Part a 

Why do organizations need to have structure?
How do organizations choose an organizational structure?

Part b
You are the Chief Human Resources Officer (CHRO) of a large tech company in Silicon Valley and your company has just acquired a small start-up company that has recently developed an apparatus that can introduce a drug into the human body subcutaneously without the use of a needle. This small start-up has ten employees and all are either programmers or medical researchers including the two founders of the start-up. The two founders, Mike and Ike, are both 25 years old and are not savvy business people.
Your company (the parent company) has tasked you with identifying the best organizational structure for the start-up.
You are now making your presentation to the Board as to what organizational structure you’re recommending to be implemented at the start-up company. Some members of the Board have asked you the following questions:
(For this role-play you will answer the following questions…)

Do we need to develop an organizational structure for the start-up company or could it just remain the same as the management structure of the parent company?
What type of organizational structure are you recommending and why?
What are the key advantages of the structure you are proposing? Are there any disadvantages?

. Do not write who you are in the answer.

Define the key term warrant, and provide exceptions to the warrant requirement.

Prior to beginning work on this video presentation, read Fourth Amendment: Search and SeizureLinks to an external site., The Difference Between the 5th and 6th Amendment Right to CounselLinks to an external site., Probable Cause and Reasonable SuspicionLinks to an external site., Saul Ornelas and Ismael Ornelas Ledesma, Petitioners v. United StatesLinks to an external site., and Pre-Trial MotionsLinks to an external site..
The fourth, fifth and sixth amendments are the most important of the Bill of Rights which affect criminal law, prosecutions, and defenses in the United States. Consider the protections against unreasonable searches and seizures, the right to remain silent, the right to due process, the right to counsel, and the right to a speedy trial as the “Holy Grail” of constitutional protections for those accused of a crime.
Part 1: Your PowerPoint (or equivalent) presentation:
If your last name begins with the letters A through G (fourth amendment). Create a five- to eight-slide PowerPoint explaining the fourth amendment. Additionally, provide 50 to 75 words of explanations for each of your PowerPoint slides in the discussion area, just as you would present an oral presentation explaining the slides on the topics listed. In your PowerPoint slides and discussions,

List the requirements of the fourth amendment.
Define the key term warrant, and provide exceptions to the warrant requirement.
Examine what the remedy is for a defendant when a motion granted to suppress is granted for a fourth amendment violation.

Making your PowerPoint (or equivalent) Presentation
You may wish to include visual enhancements in your presentation. These may include appropriate images, a consistent font, appropriate animations, and transitions from content piece-to-content piece and slide-to-slide. (Images should be cited in APA format as outlined by the University of Arizona Global Campus Writing Center’s Tables, Images, & AppendicesLinks to an external site. resource.) The Where to Get Free (and Legal) ImagesLinks to an external site. guide provides assistance with accessing freely available public domain and/or Creative Commons licensed images. It is recommended that you access the University of Arizona Global Campus Writing Center’s How to Make a PowerPoint PresentationLinks to an external site. and Simple Rules for Better PowerPoint PresentationsLinks to an external site. which provide useful assistance with creating successful PowerPoint presentations.
Part 2: Your computer screen video recording (Screencast) of a PowerPoint (or equivalent) presentation:

Take photos of key points in each exercise, and place them in PowerPoint using appropriate titling and transitions.
Write speaker’s notes as a script for your presentation at the bottom of each slide.
Use Screencast-O-Matic Download Screencast-O-Maticto record your presentation and voice. (You will need either a laptop’s built-in microphone or an external microphone headset to record your voice).
Using the screen cast software package, obtain a link to share with others.

Posting:

Paste your video link, and post your PowerPoint file within your initial post in this discussion forum.

Discuss the implications of a biblical worldview and Christian philosophy for practical application to the overall field of education.

EDLC 504
Biblical Worldview Paper Assignment Instructions

Overview

The
Biblical Worldview Paper Assignment is course-embedded into every degree program in Liberty University’s School of Education (SOE). Its purpose is to carry out LU’s mission to provide an education with a solid Christian foundation and to ensure that every SOE program completer understands the implications of a biblical worldview for the field of education. While there are other assignments that require candidates to write a personal philosophy of education, that is not necessarily the intent of this particular assignment. The goal of this activity is for candidates to accomplish the following:

· Convey an understanding of what is meant by a biblical worldview.
· Support and illustrate this understanding by citing the Bible and other literature on the topic of biblical worldview.
· Apply principles of a biblical worldview to educational practice.
· Articulate key components of a Christian philosophy of education, citing from the Bible and other literature on the topic of Christian philosophy of education.
Because the SOE embeds this assignment into every degree program—i.e., bachelor, master, education specialist (Ed.S.), and doctorate (Ed.D)—it is likely that candidates who earn multiple degrees from LU’s SOE will be required to complete the assignment multiple times. Especially in the Ed.S. and Ed.D. degrees, the Biblical Worldview Assignment may be required for more than one course. Candidates who are required to complete the assignment more than once may resubmit the initial assignment but are encouraged to revise as needed. For example, expectations for undergraduate and graduate writing levels are different; therefore, the composition of the paper may need to be strengthened with the repeated submission. Also, check the assignment directions and rubric to ensure that you are meeting the present course’s specific requirements.

Mission of Liberty University: This assignment advances LU’s mission by promoting “the synthesis of academic knowledge and Christian worldview in order that there might be a maturing of spiritual, intellectual, social and physical value-driven behavior” and by encouraging “a commitment to the Christian life, one of personal integrity, sensitivity to the needs of others, social responsibility and active communication of the Christian faith, and, as it is lived out, a life that leads people to Jesus Christ as the Lord of the universe and their own personal Savior.”

Instructions

Write a 4-page paper in current APA format that conveys your understanding of what is meant by a biblical worldview and a Christian philosophy of education. Also, discuss the implications of these principles in their application to educational practice. Page length requirement begins with the introductory paragraph and ends with the conclusion; it includes neither the title page nor the reference page. An abstract is not required. In addition to the Bible, cite a minimum of four references that represent the body of literature supporting and explaining biblical worldview and Christian philosophy of education. No more than 10% of the paper is to include direct quotes; therefore, you should do much more summarizing and paraphrasing than quoting. Citations are required both for direct quotes and for summarized ideas drawn from references. The format of the paper is to include the sections below with headings that follow current APA format.
·
Title Page

·
Introduction

Present a strong, clear thesis statement. The focus of this paragraph is to introduce the reader to the thesis statement. The remainder of the paper should support and illustrate the main point(s) of the thesis statement.
·
Biblical Worldview

Based upon your readings of the Bible and literature on the topic of biblical worldview, convey a basic understanding of the elements of a worldview that is based distinctively on a perspective of life drawn from Judeo-Christian scriptures. Do not focus on the field of education in this section. A common error is for writers to neglect the discussion of a biblical worldview by focusing too much on the field of education, which is to be addressed in subsequent sections of the paper.
·
Christian Philosophy of Education

Based upon your readings of the Bible and literature on the topic of Christian philosophy of education, convey a basic understanding of the elements of an educational philosophy that is based distinctively on a perspective drawn from Judeo-Christian scriptures. Address metaphysical and axiological issues. Metaphysical issues relate to questions of meaning and purpose. Axiological issues relate to questions of values. Minimize the discussion of practical application to the field of education in this section. A common error is for writers to neglect the discussion of a Christian philosophy of education by focusing too much on the implications for educational practice, which will be addressed in the subsequent section.
·
Implications for Educational Practice

Discuss the implications of a biblical worldview and Christian philosophy for practical application to the overall field of education. Ensure that you discuss these implications for the field in general, but you may also proceed to specify implications for your particular area of interest. For example, if you are preparing to serve as a content area teacher, a special education teacher, an administrator, or a school counselor, you may—after addressing implications for the overall field of education—address implications for your area of service.
·
Conclusion

An effective conclusion affirms the thesis statement and leaves the reader with a clear idea of how thoughts in the paper fit together to make a specific point.
·
Reference Page

List here at least 4 references in addition to the Bible.

One your references is to be the course textbook.

Submission: Submit the document in the course submission area and in LiveText. It will not be graded until it is submitted in both locations. In the course submission area, the assignment will be checked by Turnitin for plagiarism. It will be graded in LiveText using the embedded rubric there.

View the
Biblical Worldview Paper Assignment Resources for additional information related to Biblical and Christian worldviews.

Note: Your assignment will be checked for originality via the Turnitin plagiarism tool.

Page 2 of 2

Share social conformity situations that you have experienced and apply social psychology theory to explain your actions in those situations.

 
OBEDIENCE
The intent of social psychology research has been and still is to explain how circumstances are more a power determinant of individual behavior than our own intuitions lead us to believe. Research on obedience and compliance is focused less on explaining why obedience can be a good thing—which it can—and more on explaining why people obey/comply with demands when they would likely prefer not to or when the demands compel them to do bad things (e.g., the classic Milgram and Stanford Prison studies).
Many are familiar with the experience of being tasked by someone in authority (e.g., a teacher, work supervisor, athletic coach) to do something of questionable value and which may be counterproductive. The demand itself appears to be arbitrary and may serve only to establish the authority of the person making it.
For this Discussion, you will share social conformity situations that you have experienced and apply social psychology theory to explain your actions in those situations.
RESOURCES

Be sure to review the Learning Resources before completing this activity.Click the weekly resources link to access the resources. 
WEEKLY RESOURCES 
TO PREPARE

Review the Learning Resources related to conformity and obedience and consider how they would apply to this Discussion.
Consider a time when you have experienced when compliance with a task was required, even when you believed that time could have been better spent doing something more productive. The task may have come from a teacher, supervisor, coach, or other authority figure.
If you complied with the order, reflect on why. If you did not, reflect on why you did not comply. 

BY DAY 4
Post an example of a time when you complied with an authority person’s demand, despite thinking it was not a good use of your time. Please explain why you did. Then, give an example of a time when you refused to comply; explain why. Your post must be informed by social psychology theory and research.
RESOURCES/REFERENCES
 

Aronson, E., Wilson, T. D., Akert, R. M., & Sommers, S. R. (Eds.). (2019). Social psychology (10th ed.). Boston, MA: Pearson.

Chapter 8, “Conformity and Obedience: Influencing Behavior” 

Note: Viewing media and interactives embedded in the electronic version of this course text is not required for this course.
Aagerup, U. (2018). Accessible luxury fashion brand building via fat discrimination. Journal of Fashion Marketing and Management,Links to an external site. 22(1), 2–16.doi:10.1108/JFMM-12-2016-0116
Griskevicius, V., Goldstein, N. J., Mortensen, C. R., Cialdini, R. B., & Kenrick, D. T. (2006). Going along versus going alone: When fundamental motives facilitate strategic (non)conformity. Journal of Personality and Social PsychologyLinks to an external site., 91(2), 281–294.  http://dx.doi.org/10.1037/0022-3514.91.2.281
Doli?ski, D., Grzyb, T., Folwarczny, M., Grzyba?a, P., Krzyszycha, K., Martynowska, K., & Trojanowski, J. (2017). Would you deliver an electric shock in 2015? Obedience in the experimental paradigm developed by Stanley Milgram in the 50 years following the original studies. Social Psychological and Personality Science,Links to an external site. 8(8), 927–933.   https://go.openathens.net/redirector/waldenu.edu?url=https://doi.org/10.1177/1948550617693060

What are some of the ways that Pitney Bowes has aligned its goals for diversity with a market-driven approach to meeting its customers’ needs?

 
Assignment:
Assignment – Part 1:
In this assignment, you are the game show host for the Diversity game (attached PowerPoint).
Gather two or three friends or family members as contestants. If you have more, divide them into two groups. Use a piece of paper to keep score and print the second page of the presentation to mark which questions were incorrectly answered. 
1. Open the PowerPoint Diversity game. Start the Slideshow to begin.
Read these instructions to the teams:

One person (or team) will randomly be selected to choose the first question category and level. Once a question is read aloud, all person (or team) will debate the answer. One team will raise a hand or use his or her assigned team noisemaker when the team is ready to answer.
I will call on the first team to respond. If they answer correctly, they will receive the number of points indicated, and they will choose the next question category and level. If their answer is incorrect, I will call upon the second team and so on.
In the event that no team answers the question correctly, I will give the correct response. The team that chose last still has control of the board and should choose the next question.
Scores will be recorded and the winner announced at the end of the round. There will be one round of 25 questions (or two rounds of 25 questions each if you also play Double Diversity).

2. Once you have the “board” displayed, and the first team has selected their question, click one of the cells to reveal a question.
3. To return to the main board, click on the “Diversity” icon in the lower right corner of the screen.
4. If the game is close, use the Double Diversity board.  To advance to the Double Diversity board, click the logo in the top-right (above “The Amazing Race”) of the main game board. This will take you to the Double Diversity! board (Board 2). 
After playing the game, discuss with the contestants why they believe they missed some of the questions.
Write a 500-word essay that evaluates the game play, your thoughts on why questions were correctly and incorrectly answered, and what you learned from the game. 
Assignment – Part 2:
Select three of the following five prompts.  Write a response of at least 300 words for each of the three prompts:

What was one of your earliest experiences concerning race? Describe the experience, how you felt, and how the experience was handled. If you could rewrite that experience, how would you change it and/ or how it was handled?
Explain the concept of “best practice” and what it means in the context of diversity strategy. What are the challenges of developing and implementing best practices? What are the potential benefits?
What are some of the ways that Pitney Bowes has aligned its goals for diversity with a market-driven approach to meeting its customers’ needs? Be specific.
What is/are the common theme(s) between the Bowman exercise and the Miner article?
Review the author’s list of 46 examples of white privilege. Critically evaluate which of these indicate white privilege and which might be artifacts of other forces (market forces, personal choice, etc.). 

 Submit both Assignments in the same document.
Assignment Expectations:

Explain the relationship between personal integrity and ethical leadership, and between ethical leadership and positive organizational outcomes.

 
Prepare an 8-10 slide PowerPoint presentation for a group of managers. Explain the relationship between personal integrity and ethical leadership, and between ethical leadership and positive organizational outcomes. Explain the ethical principles of autonomy, beneficence, nonmaleficence, and justice and how these principles guide ethical health care leadership practices.
Introduction
As you prepare for your career, it is important to build a foundational understanding of the basic ethical theories directly related to health care management. It is important to infuse ethical knowledge and principles throughout an organization to effectively address challenging situations in all aspects of management, leadership, strategic planning, and decision making.
You should also understand the relationship between personal value systems and ethical management practice. The concept of moral integrity is a basis for professional actions and leads to positive business outcomes. Of course, there are personal ethical challenges that might present barriers in maintaining long-term, consistent success as a moral leader; therefore, the development of a personal moral compass and ethical bottom line can be useful in guiding your career.
Autonomy, beneficence, nonmaleficence, and justice are examples of the ethical principles most commonly used by health care leaders in organizational management planning, problem-solving, and decision making. Effective managers refer directly to these ethical principles for preventing and resolving issues related to all aspects of business.
While these principles appear to be relatively easy to define, the challenge for health care leaders is in their appropriate application. An effective leader develops knowledge, understanding, and skills in ethical leadership through observation, practice, and reflection on experiences and outcomes. The constant, and often profound, changes in our health care system create continuous learning opportunities to develop moral leadership qualities and skills. Each sector of the health care system presents different needs and situations related to each of the ethical principles, although some applications are universal.
Preparation
Suppose the health care organization where you work has determined that most employees are unclear about the differences between ethics and morality, and professional ethics and personal ethics. As a mid-level manager, you have been asked to develop and present a lunch-and-learn session on ethics for other managers within the organization.
Review the resources provided and conduct your own search for scholarly and professional resources on ethical principles and theories. Find at least three authoritative resources you can use to support your work on this assessment.
The format for this assessment is an 8–10 slide PowerPoint presentation. Please use the notes section of each slide to expand the points on the slide. Be sure your presentation is appropriate for the audience and presents the required aspects clearly. Follow APA guidelines for any in-text citations and your references. You must include a title slide and a references slide. You do not need to record yourself giving the presentation.
Instructions
Prepare an 8–10 slide PowerPoint presentation for managers in a health care organization. Include the following:

Explain the relationship between personal moral integrity and ethical leadership in health care. Be sure you also consider how these concepts differ and the role of health care managers in ensuring that ethics are an integral element in their leadership.
Explain the ethical principles of autonomy, beneficence, non-maleficence, and justice.
Explain how these principles guide health care leadership practices.
Explain the relationship between ethical health care leadership and positive outcomes for the organization.

Additional Requirements

Include a title slide and references slide.
Number of slides: 8–10.
At least three current scholarly or professional resources.
APA format for citations and references.
Consider the target audience and feel free to be creative.

Note: The assessments in this course build upon each other, so you are strongly encouraged to complete them in sequence.
Competencies Measured
By successfully completing this assessment, you will demonstrate your proficiency in the course competencies through the following assessment scoring guide criteria:

Competency 1: Explain how ethical theories and principles influence health care organizational management practice.

Explain the ethical principles of autonomy, beneficence, nonmaleficence, and justice.
Explain how ethical principles guide health care leadership practices.
Explain the relationship between ethical health care leadership and positive outcomes for the organization.

Competency 3: Examine the role personal moral integrity plays in ethical leadership practice.

Explain the relationship between personal moral integrity and ethical leadership.

Competency 4: Communicate ideas effectively.

Correctly format citations and references using current APA style.
Write content clearly and logically, with correct use of grammar, punctuation, and mechanics 

The Business Research Library Guide and Health Care Administration Undergraduate Program Library Guide can help direct your research.
If you are unfamiliar with working with PowerPoint, please review the Microsoft Office Software tutorials.
Voices of Integrity.

Listen to the interviews with Kristopher Vlosich and Randall Kilgore. 

Forrestal, E. J., & Cellucci, L. W. (2016). Ethics and professionalism for healthcare managers. Health Administration Press.

Jeong, C., & Han, H. (2013). Exploring the relationship between virtue ethics and moral identity. Ethics & Behavior, 23(1), 44–56.
Jansen, L. A. (2013). Between beneficence and justice: The ethics of stewardship in medicine. Journal of Medicine & Philosophy, 38(1), 50–63. 
U.S. Department of Veterans Affairs. (n.d.). National Center for Ethics in Health Care. http://www.ethics.va.gov/integratedethics.asp
American College of Healthcare Executives. (2016). Ethics toolkit. http://www.ache.org/abt_ache/ethicstoolkit/ethicsTOC.cfm
World Health Organization. (2015). Global health ethics: Key issues [PDF]. http://apps.who.int/iris/bitstream/10665/164576/1/9789240694033_eng.pdf
The Kennedy Institute of Ethics. (2014, December 19). Introduction to bioethics: Bioethics at the bedside [Video]. | Transcript. YouTube. https://www.youtube.com/watch?v=c3I0SxI2grM&list=PL9Vn7DAzOnmjvMkB7coxPfcVNt7Hhu0Rs&index=1
The Kennedy Institute of Ethics. (2014, December 19). Introduction to bioethics: Bioethics & justice [Video]. | Transcript. YouTube. https://www.youtube.com/watch?v=9vxRs_poQwU&index=3&list=PL9Vn7DAzOnmjvMkB7coxPfcVNt7Hhu0Rs
The Kennedy Institute of Ethics. (2014, October 1). Rebecca Kukla on Autonomy, Georgetown University (1/6). [Video]. | Transcript. YouTube. https://www.youtube.com/watch?v=hWVLS_xK7Ag
U.S. Department of Veterans Affairs. (n.d.). A brief business case for ethics [PDF]. https://www.ethics.va.gov/docs/integratedethics/A_Brief_Business_Case_for_Ethics_in_Health_Care.pdf 
Morrison, E. E. (2020). Ethics in health administration: A practical approach for decision makers (4th ed.). Jones & Bartlett. Available in the courseroom via the VitalSource Bookshelf link.

Examine how modern RDBMSs manage multiple concurrent user access to a database as well as how these RDBMSs manage online or real-time backup and recovery processes

Weighting:

Students in groups of four will design and implement a database that support a firm involved in various activities. It must have stored functions and procedures. The database can be accessed by a specific user with suitable security and authentication facilities.

Assessment addresses SLOs

b

Model, design and implement complex database structures (including databases distributed over a network) using a relational database management system (RDBMS)

C

Apply advanced SQL programming (often as a stored procedure) to fulfil complex data/information retrievals from an RDBMS

d

Develop and apply scripts and configure web server software as part of a Web database

e

Examine how modern RDBMSs manage multiple concurrent user access to a database as well as how these RDBMSs manage online or real-time backup and recovery processes

Marking Criteria

Please refer to Marking Rubric on Canvas

Assignment Requirements
Your group has started a small consulting services business in developing databases.
WIN Car rental services is a small business in Sydney. As the name suggests they are in the business of car rentals. They approached you to develop a database for their business. Till date they are using an excel file to manage their business. The excel file is attached with this assignment document. Have a look at it before you start working on the assignment.
The entities required for the database are as follows:
·

Customer
– customerId, lastName, firstName, address, postcode, state, phone, memberDate.

·

Insurance
– insuranceId, insuranceType, price

·

Vehicle
: rego, description, make, model, carYear, value, engineCapacity, odometer, purchaseDate, vehicleTypeId.

·

Rental
: rentalId, bookingDate, bookingMethod, checkout, rentDays, checkin, dueDate, odometerIn, damage, paymentId, rego, customerId, insuranceId.

·

VehicleType
: VehicleTypeID, VehicleType, Charge.

·

RentalCharge:
RentalID, Rent.

·

PayType
: Payment_ID, Pay_Type.

Along with the database files you were asked to submit other documentation as listed below:

Task 01:

A. ER Diagram in Crows Foot Notation. (Draw using Draw.io)
a. Primary keys and foreign keys must be identified.
b. All attributes must be identified.
c. All relationships (both directions) must be clearly listed.
B. Data dictionary (create in Excel)
C. Any other required information.

Task 02:

The following SQL files must be submitted.
A. SQL Statements to create the database and insert at least 5 records in every table.
· Create a database called “winCarRentals” that has all the above listed tables.
· Insert all the data shown in the excel file.
· Create a minimum of 5 customers. You four people and me.
· Create at least 3 rentals.
B. SQL statements to incorporate functions and triggers in the database.
· When data is inserted in the customer table, Customer MemberDate must be before or equal to the current date.
· When data is inserted in the vehicle table, Vehicle’s PurchaseDate, must be before or equal to the current date.
· When data is inserted in the rental table, rental booking date, checkoutdate must be after or equal to the current date.
· When a vehicle is checked in (the check-in filed is set to null when the record is created, when the vehicle is returned, check in date is set to the returned date), the rental must be calculated and stored in the rental charge table.
C. SQL statements to run a number of report queries.
· Write a query to print the list of customers who did not rent a vehicle.
· Write a query to display the cars that are currently on rent.

Submission Requirements
Students must submit their assignments through CANVAS shell. Email submissions will not be accepted.
Deliverables:
A Microsoft Word document containing the ER diagram and the data dictionary to answer Task 1.
Three SQL files ready to be uploaded to the WAMP server to satisfy Task 2.
All these files must be placed in a zip file and must be submitted through CANVAS.

** One submission per group is enough. All the group members do not need to submit the same files **

Wentworth Institute of Higher Education, 302 Elizabeth Street, Sydney http://www.win.edu.au/ Higher Education CRICOS code: 03279M
image1.png