rey writer

as agreed please due in 12 hours; no plagiarism 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

A realtor leases houses to customers. The realtor has several branches. Each branch has a branch number, an address and…

A realtor leases houses to customers. The realtor has several branches. Each branch has a branch number, an address and a telephone number. Each employee has an employee number, name, address, a salary and holds a position such as manager. Each employee is affiliated to one branch only and manages a number of houses. Each house is managed by a single employee. Each branch has a number of maintenance crews who are responsible for dealing with maintenance issues in the rented homes. These may be tasks such as repairing a leak, fixing a washing machine etc. Each crew has a crew number. Each crew is assigned a maintenance task such as repair a leak at house no 50. Each house for rent has a house number, an address, the square footage of the house, the monthly rent, the number of bedrooms and a status flag indicating whether it is vacant and therefore available for rent. Some houses are apartments, whereas others are single family dwellings. Apartments have a fixed charge for water and electricity. This charge is stored in the database. For a single family house, the renter pays water and electricity based on usage. The area of the land for a single family home is also shown in the database. The database also holds information about the renters, their names, the house they have rented out, their id number and the period of the lease. • Draw an Entity-Relationship diagram • Create the relations • Write relational algebra expressions and expression trees to answer the following queries: i. List all houses that cost less than $500 a month. ii. List the total number of available apartments. iii. List all the crews that have to repair a leak. List the crew numbers. iv. List all the number of customers that are renting apartments and the number of customers that are renting single family homes v. List all the pairs of apartments and houses (a,b) that have both the same number of bedrooms. The first item in the pair should be the apartment. List the house numbers. vi. List the average number of houses managed by an employee. • Express the following constraints in relational algebra i. An apartment with 4 bedrooms should not cost more than $700 per month ii. An employee works at only one branch • Write the following queries in SQL: i. List all the pairs of apartments and houses (a,b) that have both the same number of bedrooms. The first item in the pair should be the apartment. List the house numbers. ii. Find the average rental price of single family homes iii. Find how many apartments have been rented out iv. For each apartment that has been rented out for more than 6 months, reduce the rental price by $50 per month and increase the water rates by $10 a month v. For each employee that manages 5 houses less than the average number of houses managed by an employee, reduce his salary by $5000. • Write the following queries in SQL and each query must use at least one sub-query i. Find the single family home with the highest price ii. Find the lowest priced apartment with 3 bedrooms • Write the following constraints in SQL i. A single family home a land of less than 0.5 acres should have a maximum rent of $2000 per month ii. If an apartment has the same number of bedroom as a single family dwelling, then the apartment must have a lower monthly rental. iii. When updating the rental price of an apartment, check that there is no lower priced apartment with the same number of bedrooms iv. When making any modifications to the rent of single family homes, check that the average rental of single family homes is at least $20,000. • Using SQL create a view that will display the house number, type of house, , number of bedrooms, availability for rent and the monthly rental. • Is this view updateable? Explain. • Write embedded SQL queries to ask a potential renter for a monthly rental and number of bedrooms and find the house whose price is closest to the desired price. Print the type of house
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Variation

Statistics for Managers course

Variation exists in virtually all parts of our lives. We often see variation in results in what we spend (utility costs each month, food costs, business supplies, etc.).  Consider the measures and data you use (in either your personal or job activities). When are differences (between one time period and another, between different production lines, etc.) between average or actual results important? How can you or your department decide whether or not the observed differences over time are important?  How could using a mean difference test help?

250 word minimum

Tanner, D. E., & Youssef–Morgan, C. M. (2013).  Statistics for Managers. San Diego, CA: Bridgepoint Education, Inc. (book used for this course)

 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Need help please

Analyze a speech

 

For this discussion, find and watch a recorded speech via YouTube or other online video repositories. In your post, analyze the speech for effectiveness. For example, what communication styles or traits did the speaker use? Was the main message effectively communicated? Please be sure to include the link to the speech as well.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Analyzing Cultural Relevance in Instruction

Analyzing Cultural Relevance in Instruction

In Chapter 12, Wardle (2013) summarizes the important characteristics of a culturally relevant teacher. Use this information as a guide or resource throughout this assignment to help inspire your thinking as you apply your knowledge of culturally relevant pedagogy toward specific solutions to problems facing a teacher with a very diverse student population. This exercise provides excellent practice over the application of culturally relevant principles in the design of effective instructional solutions. You will need to design such instructional solutions within the Final Project, so it is very important to practice such skills here. Specifically, for this assignment, you will view a brief video taken with a cell phone by a student in a high school social studies class.The video (Bliss, 2013) documents a meltdown Bliss experienced during his World History course at Duncanville High School in Duncanville, Texas. A transcript of the audio is provided in the Instructor Guidance for this week along with other detailed assistance for completing this assignment. 

After reviewing the Instructor Guidance for this task, create your assignment to meet the content and written communication expectations below.

Content Expectations

  • Video Analysis Questions (2 points): Answer the questions below based on your inferences and ideas after viewing the events captured in the cellphone video.

    1. Description: What is the problem (from Jeff Bliss’s perspective as well as from Ms. Phung’s perspective)? 
    2. Diagnosis: What probably caused it? Who benefits? Who loses? What position do you take on this issue? 
    3. Solution: How could a more equitable, culturally relevant approach to the class improve the situation? How might Ms. Phung respond differently to Jeff’s concerns?
  • Equity Strategies (2.5 points): Describe any equity strategies you noticed or inferred being implemented in the video. Suggest at least one strategy for each of the four categories that the teacher could have utilized to help meet student needs in a more equitable fashion.

    1. Instruction
    2. Classroom Environment
    3. Student Grouping
    4. Student Recognition/Leadership
  • Culturally Relevant Strategies (2.5 points): Describe evidence of any culturally relevant pedagogy in action in the cellphone video and suggest at least three strategies that could be used to create a more culturally relevant classroom. Such strategies might be drawn from the following areas:

    1. Maximizing academic success through relevant instructional experiences
    2. Addressing cultural competence through reinforcing students’ cultural integrity
    3. Involving students in the construction of knowledge
    4. Building on students’ interests and linguistic resources
    5. Tapping home and community resources
    6. Understanding students’ cultural knowledge
    7. Using interactive and constructivist teaching strategies
    8. Examining the curriculum from multiple perspectives 
    9. Promoting critical consciousness through opportunities to challenge predominant elements of the students’ social norms

Written Communication Expectations

  • Page Requirement (.25 points): Submit three to five pages, not including the title and reference pages.
  • APA Formatting (.25 points): Format your paper according to APA style as outlined in the Ashford Writing Center.
  • Syntax and Mechanics (.25 points): Display meticulous comprehension and organization of syntax and mechanics, such as spelling and grammar. 
  • Source Requirement (.25 points): Reference the cellphone video and Wardle (2013) textbook. All sources on the references page need to be used and cited correctly within the body of the assignment.

Next Steps: Review and Submit the Assignment

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Written7(200words)

Assume that you are a police sergeant who supervises ten patrol officers on your squad. You have noticed signs of alcohol abuse regarding two of your officers. What steps have you taken to remedy this situation?

 

 

Do you think that police officers should be able to have long hair, beards, tattoos, and piercings visible to the public while in uniform?  Discuss the legal precedents that allow police departments to set grooming standards.

 
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

MUST BE NEW AND ORIGINAL WORK NOT GIVEN TO OTHER STUDENTS. Write in a clear, concise, and organized manner; demonstrate ethical scholarship in the accurate representation and attribution of sources; and display accurate spelling, grammar, and punctuation.

MUST BE NEW AND ORIGINAL WORK NOT GIVEN TO OTHER STUDENTS. Write in a clear, concise, and organized manner; demonstrate ethical scholarship in the accurate representation and attribution of sources; and display accurate spelling, grammar, and punctuation. Include citations in the text and references at the end of the document in APA format.PLEASE READ INSTRUCTION CAREFULLY. IN TEXT CITATION AND MUST CITE ALL REFERENCE IN APA FORMAT. MUST ADHERE TO RUBRIC.

 

 

Purpose of Assignment 

Weeks 3, 4 and 5 Individual Assignments are integrated to generate a Strategic Management Plan. This is part three of the three part Strategic Management Plan addressing strategy implementation, evaluation and control. The purpose of the Week 5 individual assignment is to allow the student to discuss and explain how the strategies discussed in prior weeks are converted into implementation activities both domestically and internationally, in alignment with legal, social and ethical considerations. Furthermore, the student has an opportunity to explain and discuss how the strategic plan and implementation activities will be monitored. 

Weeks 3, 4, and 5 Individual Assignments are integrated to generate a Strategic Management Plan. This is Part 3 of the three part Strategic Management Plan. 

Assignment Steps 

Write a 1,050-word report on the company you selected in Week 3 (COMPANY IS CHICK FIL A) , following up on the Individual Assignment of Week 3 (Environmental Scanning), and address the following: 

  • Strategy Implementation
    • Discuss International Strategy.
    • Discuss Strategic Implementation.
    • Explain the influence of Governance and Ethics.
    • Discuss the Company Social Value.
    • Discuss Innovation and Diversification.
    • Discuss Legal limitations. 
  • Evaluation and Control
    • Explain Strategic Metrics.
    • Discuss Key Financial Ratios. 

Cite at least 3 scholarly references.

Format your paper consistent with APA guidelines

 

 

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

“What the Body would be without Bones” diagrams, flow chart 2500 words DUE Saturday by 9pm

 

Essay #1 (6%):. â€œThe Human Body Without Any Bones”. (Due on 07 Sep 2013).  Include illustrations, diagrams, flow charts, references, or any other material you may want. Use your ingenuity. You may want to make it like a video game. Post under Assignment tab on Blackboard. Word limit: 2500.
 
 
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

300-500 minicase labor relations

Complete Minicase #1: Trying to Striker a Balance on page 234 of your textbook. Your response should be between 300-500 words, 12 pt. font, double spaced, 1″ margins.

 

reference page for sources/resources used (cite them in response if used)

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"