Given the following relation schemes:

Teacher = [CourseN, Quarter,TeacherName]
Course = [CourseN,CourseName, Nunit)
Student = [studentName, CourseN, Quarter]
LocationNTime = [CourseN, Quarter , DayTime,  RoomN]

//Examples of DayTime: M2:00AM, W4:50PM, and T8:00PM. Note that DayTime is represented as a string.

Express the following queries by SQL statements and test them using any appropriate data. Take screenshots of the result, please let me know what program you use and please show all answers in complete form.

1. List the name of every teacher (distinct names) who teaches in RoomN 34 in Winter2011.

2. List CourseN, CourseName,  and TeacherName of every course meets on Monday PM.

3. List the name of every teacher who taught at least one course in RroomN 723.

4. List the CourseN, Quarter, RoomN and DayTime of every course taught by Karen Reed in the Spring 2005.

5. List the CourseN and TeacherName of every course taken by the student Ron Smith or by the student David Weidman.

6. List the CourseN and Quarter of every course taught by Karen Reed and met or meets in RoomN 713.

7. List the name of every teacher who has taught the same course at least two times.

8. List the name of every teacher( distinct names) who has taught at least two different courses in the same or different quarters.

9. List the CourseN, CourseName, and Quarter which meets or met at least two times a week.

10. List the CourseN and CourseName of every course with number of units > 4.

11. List every course number and students name who has taken the course at least twice.

12. Use * to list the CourseN, CourseName, Nunit, Quarter, TeacherName of every
course sorted by CourseN ascending, CourseName descending. 

13. List the CourseN and Quarter of every course taught by two different instructors in the same quarter ordered by the CourseN in descending order.

All in Java, this is a java 2 class so nothing to advanced

For this assignment, students will develop a turn-based ghost hunting game with two different levels of ghosts.  The key learning objectives for this assignment are: ability to setup and use classes, understanding and using inheritance, use of overloaded constructors.

The overall game concept:  You are a ghost hunter character in a game.  You are trying to clear the ghosts from a haunted house.  As you enter each room, you encounter ghosts that you must battle in order to move on.  Once you have battled and destroyed 3 ghosts and the boss ghost, the house is cleared and it is ready for a family to move in. 

Since both ghost types share common attributes, you will setup a parent or super class for Ghost with the shared attributes.  Then you will create subclasses that differentiate the specific characteristics of the regular or boss ghost.

Both ghost types will have attributes for their name and the “damage” they inflict on a character.  The default constructor for the base or super class, will be to initialize the values to null and zero.

Class RegularGhost:  A Regular ghost has a unique attribute for “health restored” to the character once the battle is over and it has been defeated.  This value will add to the health of the ghost hunter.  This ghost class will have overloaded constructors for three types of ghosts 1) default (no parameters) is 20% chance of escape, 15% damage, and 10 health restore 2) Parameter for chance of escape and damage  3) Parameter for chance of escape, user defined damage levels, and health restore.  The parameters will be set in the constructors based on asking the user if they want the game setting on easy, medium, or hard. 

Class BossGhost:  A Boss ghost has a unique attributes for “health” and “damage taken”.  There is one overloaded constructor for this class:  health and damage inflicted are parameters based on the user difficulty setting.  The amount of damage taken will be determined by the battle method chosen by the user.  This will impact the health, so at a minimum, you will need setters and getters for the health attribute.

Class GhostHunt:  Main program

Pseudocode for Gameplay:

1)  Introduce the game to the user

2) Ask the user for a setting level (easy, medium, hard)

3) Ask the user for their character name

4) Introduce the setting

5) Ask the user the room they want to enter, each room has a different ghost (objects with unique names created from default and overloaded constructors)

6) Describe the room

7) The character encounters a regular ghost: Describe the ghost, tell user the battle has started

            – Random result based on chance of escape for ghost sucked up or escapes, or damage inflicted to character

            – Check for ghost dead or character dead

            – Ask user if they want to continue battle or run away

            – Repeat above steps until either the user runs away, or the ghost or character loses

            – If the user chooses to run away then continue

            – If the user wins, then add the “health restored” and continue

            – If character/user loses: end game

8) Repeat 5 and 6 until 3 ghosts have been defeated or the character/user loses

9) The character enters the final room and encounters a boss ghost

            – Ask the user which tool they want to use (such as:  magic spell, ectoplasm vacuum)

            – Random result whether it works or not and whether ghost inflicts damage on them or not

            – Check for boss ghost or character out of health

            – Then repeat the first step of the boss battle until one of them is out of health

            – If character/user loses: end game

            – If character wins then Congratulate the user on winning! and end your story (the family moves in, everybody is happy, etc.)

Based on the book Street Occupations by Patricia Acerbi, explain why and how street commerce changed in Rio de Janeiro between the 1850s and 1925.  Pay special attention to regulations and the changing role of the State, the municipal government, and the police. Include evidence from the book to support your argument.

4 pages, double-spaced. (name on the top, no need for cover page).

Upload to canvas (PDF or word file), or bring a hard copy to class (I prefer electronic submission)

Reference: Chicago (only footnotes, no need for a bibliography)

Notes:

[First note] Patricia Acerbi, Street Occupations: Urban Vending in Rio de Janeiro, 1850-1925(Austin: University of Texas Press, 2017), xxx [include page or pages]

[After] Acerbi, Street Occupations, [include page number]

Make sure quote cite the page number.

Only use this book and just follow link. book:https://books.google.com/books?id=UVowDwAAQBAJ&printsec=frontcover&dq=Based+on+the+book+Street+Occupations+by+Patricia+Acerbi&hl=en&sa=X&ved=0ahUKEwiBu-b3idXnAhXIrZ4KHWb7DFEQ6wEIKTAA#v=onepage&q=Based%20on%20the%20book%20Street%20Occupations%20by%20Patricia%20Acerbi&f=false

    Students will be required to develop a journal chronicling contemporary ethical issues as presented in the mainstream electronic media (I know its a bit of an oxymoron; however, the point is that you should find articles/editorials, NOT blog entries). The article/editorial should engage some issue of contemporary public policy and argue in support of a specific position.

    Each journal entry should include a brief (250-500 words) summary of the article and an ANALYSIS (700-1000 words) of the position using our method for resolving disputes from Module 1 for each piece….These requirements are for EACH of the 3 articles that you cover, which means youll have a 250-500 word summary and 700-1000 word analysis for each of the 3 articles that you choose (e.g., each submitted journal will have a total of 3000-4500 words).

–TOTAL= 3 articles w/summary and analysis of each articles =
  1 summary and 1 analysis per article.

    Each entry must include a working link to the source (or you can copy the entire piece at the beginning of your entry), with date and title of the article (so that the instructor can read it).

    All entries must be from the year 2014 or later, no exceptions.

    I will provide a few websites and articles that might be good to look into to, but generally if you simply keep in mind as you go about your daily wanderings on the internet, youll likely come across some interesting and useful articles/editorials.

    Because some of the specific positions we read in the course assignments are less recently written, this should be viewed as an opportunity to engage with contemporary issues/approaches related to our class focus and an enjoyable assignment that should not require great stress.

For this paper, you are going to expand on one of the discussion forums that you have already written. You will choose one of the topics from discussion forums 1-4 and elaborate on the current trend in this area.

Your paper should include an introduction of the topic that includes a historical definition based on literature, a discussion of the current research in the field (last 5 years only), and a section that addresses future questions that will need to be addressed and/or explored in research.

This paper should draw on a minimum of ten substantial journal article resources and will be 10 to 12 pages in length (not including the title page, abstract, or reference pages) observing all APA style conventions.

You may use any articles or writings that you wrote about in your previous discussion forums in this course.

I am choosing to critique Callista Roys Adaptation Model

Select one of the models listed on the table in Meleis (Table 10-1, p. 177) and critique the theory you have selected to present.

Address all criteria presented in the model you select. For Barnum that includes the Internal Criticism and External Criticism, Chinn and Kramer includes Description of Theory and Critical Reflection, Fawcett you should complete Analysis & Evaluation of Nursing Models if you are using a model or Analysis & Evaluation of Nursing Theories if you are using a theory, which most of you are using. Lastly, you should complete Criteria for Practice Theory, Criteria for Midrange Theory or Criteria for Conceptual Models, whichever is appropriate for your theory.

PLEASE FOLLOW INSTRUCTIONS IN PAPER, FEEL FREE TO ADD OR REWRITE ANY PARAGRAPHS THAT DONT LOOK GOOD..ALSO THE LITERATURE EVALUATION TABLE HAS TO BE IN PORTRAIT FORMAT, PLEASE PUT IN THIS FORMAT AND MAKE CHANGES.. THE LITERATURE AND PAPER ARE TO BE ALL INCLUDED IN ONE PAPER.. SO IT STARTS WITH PAPER THEN GOES INTO LITERATURE EVAL TABLE. I WILL BE MAKING A PAMPLET TO BE ADDED TO PAPER SO PLEASE LEAVE SPACE SO I CAN ADD ONE..,
I have done all the work I just am getting stuck on putting this all together and having trouble writing the few things that need to be included for a good paper, please contact me with any questions. 

Discuss the changing economic landscape of the United States between the world wars. In your response, trace the highs and lows from the fallout of World War I, the onset of the Great Depression, and the impact of the New Deal. How did these trends have an impact on marginalized communities?

Care plan expectations:

Pt 2 year old trash patient with pneumonia

No less than three no more than five diagnosis.

Each diagnosis needs two measurable and obtainable goals   One long term and one short term goal. Each goal must be measurable and obtainable.

Each Goal needs at least three interventions. As a nurse how would you attain these goals you have set.

Next, you  have your nursing rationales why did you do the interventions. Where is the evidence to support what you are doing? This is where you will reference using APA format.

Cite your sources and provide reference page. At least one source (textbook).

Finally, evaluation you will say whether the goal was met or not met. If not met how/what could you do differently to make an obtainable goal.

APA format is easily located from Googling Purdue Owl or simply typing in your search engine  APA reference format.