Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:

Answers

Answer 1

The complete question is:

a. Display the SMemberID and SMemberName for all staff members.

b. Display the CCID, CCName, and CCIndustry for all corporate clients.

c. Display the BuildingID, BNoOfFloors, and the manager’s MFName and MLName for all buildings.

d. Display the MFName, MLName, MSalary, MBDate, and number of buildings that the manager manages for all managers with a salary less than $55,000.

e. Display the BuildingID and AptNo, for all apartments leased by the corporate client WindyCT.

f. Display the InsID and InsName for all inspectors whose next inspection is scheduled after 1-JAN-2014. Do not display the same information more than once.

g. Display the SMemberID and SMemberName of staff members cleaning apartments rented by corporate clients whose corporate location is Chicago. Do not display the same information more than once.

h. Display the CCName of the client and the CCName of the client who referred it, for every client referred by a client in the music industry.

i. Display the BuildingID, AptNo, and ANoOfBedrooms for all apartments that are not leased.

Also a schema of the HAFH database is attached.

Answer:

Using SQL's SELECT, FROM, WHERE syntax, find below the queries for each question.

SELECT SMemberID , SMemberName

FROM staffmember

SELECT CCID, CCName, CCIndustry

FROM corpclient

SELECT b.BuildingID, b.BNoOfFloors, m.MFName, m.MLName

FROM building b, manager m

WHERE b.ManagerID = m.ManagerID

SELECT m.MFName, m.MLName, m.MSalary, m.MBDate, count(*) as buildings

FROM building b, manager m

WHERE m.MSalary<55000

AND b.ManagerID = m.ManagerID

GROUP BY m.ManagerID

SELECT b.BuildingID, a.AptNo

FROM building b, apartment a, corpclient c

WHERE c.CCName = "WindyCT"

AND c.CCID = a.CCID

AND a.BuildingID = b.BuildingID

SELECT DISTINCT i.InsID, i.InsName

FROM inspector i, inspecting x

WHERE i.InsID = x.InsID

AND x.DateNext > "2014-01-01"

SELECT DISTINCT s.SMemberID, s.SMemberName

FROM staffmember s, cleaning c, apartment a, corpclient cc

WHERE s.SmemberID = c.SmemberID

AND c.AptNo = a.AptNo

AND a.CCID = cc.CCID

AND cc.CCLocation = "Chicago"

SELECT cc1.CCName, cc2.CCName

FROM corpclient cc1, corpclient cc2

WHERE cc1.CCIDReferencedBy = cc2.CCID

AND cc2.CCIndustry = "Music"

SELECT a.BuildingID, a.AptNo, a.ANoOfBedrooms

FROM apartment a

WHERE a.CCID NOT IN (SELECT c.CCID FROM corpclient c)

Write The SQL Queries That Accomplish The Following Tasks In The HAFH Realty Company Property Management

Related Questions

Keisha has a worksheet with a range of cells using the following columns: Name, Score, Group, Study Group, and Date. Keisha needs to sort the worksheet on the Date field. Which option should she use to most efficiently complete this task?

A: Use the Cut and Paste option to reorganize the data to fit that order.
B: Use the Filter function to organize the data based on the date.
C: Use the Order function to organize the data based on the date.
D: Use the Sort function to organize the data based on date order.

Answers

Answer:

The answer is

d. Use the Sort function to organize the data based on date order.

Explanation:

Most accurate one.

The option that she should use to most efficiently complete this task is to use the Sort function to organize the data based on date order. The correct option is D.

What is a worksheet?

It is "a piece of paper used to record work schedules, working hours, special instructions, etc. a sheet of paper used to jot down problems, ideas, or the like in draft form." A worksheet used in education could have questions for pupils and spaces for them to record their responses.

A single spreadsheet called an Excel Worksheet is made up of cells arranged in rows and columns. A worksheet always starts in row 1 and column A. A formula, text, or number can be entered into each cell. Additionally, a cell can point to a different cell on the same worksheet, in the same workbook, or in a different workbook.

Therefore, the correct option is D. Use the Sort function to organize the data based on date order.

To learn more about the worksheet, refer to the link:

https://brainly.com/question/1024247

#SPJ6

can a computer Act on its own?

Answers

Answer:

hope this helps...

Explanation:

A computer can only make a decision if it has been instructed to do so. In some advanced computer systems, there are computers that have written the instructions themselves, based on other instructions, but unless there is a “decision point”, the computer will not act on its own volition.

PLEASE THANK MY ANSWER

V(t)=5 cos wt + 2 ? Is this ac or dc ? And why ?

Answers

Answer:

this is AC b/c.... cos is a periodic function.. think waves... the voltage is going to vary between positive 5 and negative 5 volts... so it's a low voltage signal, but still AC, the W is for how fast it's varying and the +2 is the off set of the wave.

Explanation:

As a twist on the Hello World exercise, you are going to be the end user of the Hello class. This class is designed to greet the user in a variety of world languages. For this task, complete the following:
Use the Scanner class to ask the user for their name.
Create a Hello object by passing the name to the constructor.
Call at least 3 methods from the Hello class to print the greeting in 3 different languages.
Remember to write your code in the HelloTester class, but make sure you take a look at the Hello class so that you know the names of the methods you need to use.

Answers

Answer:

Here is the Hello class:

public class Hello { //class name

private String name; //to store the name

public Hello (String names) //parameterized constructor

{ name = names; }

public void English() { //method to greet user in english

System.out.print("Hello "); //displays Hello on output screen

System.out.print(name); //displays user name

System.out.println("!"); } //displays exclamation mark symbol

public void Spanish(){ //method to greet user in spanish

System.out.print("Hola "); //displays Hello on output screen

System.out.print(name); //displays user name

System.out.println("!"); } //displays exclamation mark symbol

public void French() { //method to greet user in french

System.out.print("Bonjour "); //displays Hello on output screen

System.out.print(name); //displays user name

System.out.println("!"); } } //displays exclamation mark symbol

Explanation:

Here is the HelloTester class:

import java.util.Scanner; //to accept input from user

public class HelloTester { //class name

public static void main (String[]args) { //start of main method

String name; //to store the name of user

Scanner input = new Scanner(System.in); //creates Scanner class object

System.out.println("Enter name?" ); //prompts user to enter name

name = input.nextLine(); //scans and reads the name from user

Hello hello = new Hello(name); //creates Hello class object and calls constructor by passing name

hello.English(); //calls English method using object hello to greet in english

hello.Spanish(); //calls Spanish method using object hello to greet in spanish

hello.French(); } } //calls French method using object hello to greet in french

The output of the program is:

Enter name? user Hello user! Hola user! Bonjour user!

The screenshot of the program along with its output is attached.

Java Program:

Java is one of the most popular programming languages that is being widely used in the IT industry. It is simple, robust, and helps us to reuse the code.

The required program is,

\\import java.util.Scanner;

class Hello

{

private String name;

public Hello(String yourName)

{

name=yourName;

}

public void english()

{

System.out.print("Hello ");

System.out.print(name);

System.out.println("!");

}

public void spanish()

{

System.out.print("Holla ");

System.out.print(name);

System.out.println("!");

}

public void french()

{

System.out.print("Bonjour ");

System.out.print(name);

System.out.println("!");

}

public void german()

{

System.out.print("Hallo ");

System.out.print(name);

System.out.println("!");

}

public void russian()

{

System.out.print("Privet ");

System.out.print(name);

System.out.println("!");

}

public void chinese()

{

System.out.print("Ni hao ");

System.out.print(name);

System.out.println("!");

}

public class HelloTester

{

public static void main(String[] args)

{

Scanner input=new Scanner(System.in);

String name;

//Accepting the name

System.out.print("\nEnter your name: ");

name=input.next();

/creating an object of Hello class

Hello hello=new Hello(name);

System.out.println("\nGreeting in English: ");