Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:
The complete question is:
Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:
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.
a.
SELECT SMemberID , SMemberName
FROM staffmember
b.
SELECT CCID, CCName, CCIndustry
FROM corpclient
c.
SELECT b.BuildingID, b.BNoOfFloors, m.MFName, m.MLName
FROM building b, manager m
WHERE b.ManagerID = m.ManagerID
d.
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
e.
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
f.
SELECT DISTINCT i.InsID, i.InsName
FROM inspector i, inspecting x
WHERE i.InsID = x.InsID
AND x.DateNext > "2014-01-01"
g.
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"
h.
SELECT cc1.CCName, cc2.CCName
FROM corpclient cc1, corpclient cc2
WHERE cc1.CCIDReferencedBy = cc2.CCID
AND cc2.CCIndustry = "Music"
i.
SELECT a.BuildingID, a.AptNo, a.ANoOfBedrooms
FROM apartment a
WHERE a.CCID NOT IN (SELECT c.CCID FROM corpclient c)
write a program that reads in a number n and prints out n rows each containing n star charactersg
In python:
rows = int(input("How many rows would you like? "))
i = 0
while i < rows:
print("*" * rows)
i += 1
I hope this helps!
g Unlike when you create a String, when you create a StringBuilder, you must use the keyword ____________.
Answer:
Unlike when you create a String, when you create a StringBuilder, you must use the keyword new
Explanation:
Strings are used in programming which also opens the way for StringBuilder to be used too. In javascript, for instance, variables are useful for storing data, We have "Let" and "const" variables. Const variables cannot be changed after they’re created. The data stored are in types an example is a string. Strings allow one to write a value and store the result in a variable.
For example, using the dot operator, when you:
console.log('love'.length); // Prints 4
Note that console.log() allows the computer to evaluate the expression inside the parentheses and print that result to the console.
.length prints 4 as the result. This shows how the string has a property that stores the number of characters in that string.
StringBuilder with the keyword "new" is used when we want to change or modify data property stored in a string.
Low level security is designed to detect and impede _____ some unauthorized external activity Some None Most All
Answer:
Low-level security is designed to detect and impede some unauthorized external activity.
Examples of low-level security systems include:
Basic physical obstacles to defense Locks for increased-security Simple lighting coverage Standard alarm SystemsExplanation
Protection devices that prevent and track any unwanted external actions are called Low-Level security measures.
Other obstacles to the installation of the security system, such as reinforced doors, fences, high-security locks, and window bars and grates, are often installed after simple physical protection barriers and locks have been created.
Also, a simple lighting system that could not be more complex than the standard security lighting systems over windows and doors and a regular security warning system that will be an unattended unit that offers monitoring capability and sound warnings at the location of unwanted entry.
Storage facilities, convenience shops, and small business premises are some of the locations that incorporate low-level security devices.
Cheers
What is the difference between Information Technology and Communication Technology?
Answer:
Explanation:
information tech is technology that teaches you information, and communication tech is tech that lets you talk to family and friends and meet new people.
Answer:
The main difference between information technology and communication technology is that Information technology is a subject that is use of computers to store, retrieve, transmit and manipulate data, or information, often in the context of business or other enterpise whereas a Communication technology is the use of computers to communicate with family and friends.
Which of the following industries does not use technology?
Medicine
Marketing and advertising
Law enforcement
Arts and entertainment
None of the above
Answer:
None of the above
Explanation:
Medicine uses technology to research
Advertiseres use platforms like Instagram to share the product they are promoting
Law enforcement uses tech to pull up databases of people's records
Arts and entertainment use them to create (in some cases), share, and sell their art.
Hope this helps!
Answer:
E
Explanation: got it right on edge 2020
PLEASE HURRY!!!
Look at the image below!
Answer:A and E
Explanation:
The last three are strings while the other choices are integers.
Putting ' ' or " " around something makes it a string and the input is asking the user to input a string.
What information is required for a complete citation of a website source?
A: the title, volume number, and page numbers
B: the responsible person or organization and the website URL
C: the responsible person or organization, date accessed, and URL
D: the responsible person or organization and the date accessed
Answer:
C: the responsible person or organization, date accessed, and URL
Explanation:
in programming and flowcharting, what components should you always remember in solving any given problem?
Answer:
you should remember taking inputs in variables
Write some code that assigns True to the variable is_a_member if the value assigned to member_id can be found in the current_members list. Otherwise, assign False to is_a_member. In your code, use only the variables current_members, member_id, and is_a_member.
Answer:
current_members = [28, 0, 7, 100]
member_id = 7
if member_id in current_members:
is_a_member = True
else:
is_a_member = False
print(is_a_member)
Explanation:
Although it is not required I initialized the current_members list and member_id so that you may check your code.
After initializing those, check if member_id is in the current_members or not using "if else" structure and "in" ("in" allows us to check if a variable is in a list or not). If member_id is in current_members, set the is_a_member as True. Otherwise, set the is_a_member as False.
Print the is_a_member to see the result
In the example above, since 7 is in the list, the is_a_member will be True
What issues will the Internet of Things present to Cybersecurity?
Answer:
The IoT offers new ways for businesses to create value, however the constant connectivity and data sharing also creates new opportunities for information to be compromised. Explore some of the more notable developments in the battle to combat cyber risks.
Explanation:
I hope this helps you. UwU. P.S. Plz mark me Brainlyest
PLEASE HURRY!!!
Look at the image below!
Answer:
cde
Explanation:
You start counting from 0.
So letters are:
a b c d e f
0 1 2 3 4 5
We do include the 2, but not the 5. So answer is cde.
What is a clip art gallery
The IP address and the port are both numbers. Which statement is true?
A computer has many IP addresses and many ports.
A computer has one IP address and many ports.
A computer has one IP address and one port,
Acomputer has many IP addresses and one port.
Answer:
A computer has one IP address and many ports.
Explanation:
Answer:
A computer has one IP address and many ports.
Explanation:
HELP!!
Why is email etiquette important? (1 point)
Email is rarely used to communicate via technology.
With more and more written communication through technology, it is important to sound competent and qualified and for your meaning to be clear.
Not many classes are taken online.
Even though companies and employers use a lot of email communication, they don't really care if you are clear with your communication
Answer:
B
Explanation:
Nowadays computer games are mostly available on external
hard disk.
Is it true or false?
Answer:
false
Explanation:
because a lot of times they are downloads without the disk
It is false that nowadays computer games are mostly available on external hard disk.
What is hard disk?A hard disk drive (HDD) is a type of computer storage device that uses magnetic storage to store and retrieve digital information.
Hard disks are usually located inside the computer and are used to store the operating system, applications, and user data such as documents, pictures, and videos.
Computer games can be stored on a variety of devices, including internal hard drives, external hard drives, solid state drives, and even cloud storage.
While external hard drives may be a popular option for some users, computer games can be installed and played from a variety of storage devices depending on user preferences and hardware capabilities.
Thus, the given statement is false.
For more details regarding hard disk, visit:
https://brainly.com/question/9480984
#SPJ2
ASAP 20 Points please hurry
Answer:
All you got to do is type System.out printIn("Study English) etc...
Explanation:
Look at the answer to see if it is right.
Cleary specifying the theme to be used for a site
before building it provides which main advantage:
site navigation
site consistency
O
a clear message
O O O
improved readability
Answer: site consistency
Answer:
B) Site Consistency
Explanation:
How to get passed administrattor on macbook air to get games and stuff.
Answer:
You need to use the name and password of the main owner of the computer/the account you made when you first got it. Then, you should be able to download apps and use it if you have your apple ID set up.
Explanation:
Write a program named palindromefinder.py which takes two files as arguments. The first file is the input file which contains one word per line and the second file is the output file. The output file is created by finding and outputting all the palindromes in the input file. A palindrome is a sequence of characters which reads the same backwards and forwards. For example, the word 'racecar' is a palindrome because if you read it from left to right or right to left the word is the same. Let us further limit our definition of a palindrome to a sequence of characters greater than length 1. A sample input file is provided named words_shuffled. The file contains 235,885 words. You may want to create smaller sample input files before attempting to tackle the 235,885 word sample file. Your program should not take longer than 5 seconds to calculate the output
In Python 3,
MY CODE: palindromefinder.py
import sys
def is_Palindrome(s):
if len(s) > 1 and s == s[::-1]:
return true
else:
return false
def main():
if len(sys.argv) < 2:
print('Not enough arguments. Please provide a file')
exit(1)
file_name = sys.argv[1]
list_of_palindrome = []
with open(file_name, 'r') as file_handle:
for line in file_handle:
lowercase_string = string.lower()
if is_Palindrome(lowercase_string):
list_of_palindrome.append(string)
else:
print(list_of_palindrome)
If you can adjust my code to get program running that would be ideal, but if you need to start from scratch that is fine.
Open your python-3 console and import the following .py file
#necessary to import file
import sys
#define function
def palindrome(s):
return len(s) > 1 and s == s[::-1]
def main():
if len(sys.argv) < 3:
print('Problem reading the file')
exit(1)
file_input = sys.argv[1]
file_output = sys.argv[2]
try:
with open(file_input, 'r') as file open(file_output, 'w') as w:
for raw in file:
raw = raw.strip()
#call function
if palindrome(raw.lower()):
w.write(raw + "\n")
except IOError:
print("error with ", file_input)
if __name__ == '__main__':
main()
WILL MARK AS BRAINLIEST
Describe the environmental issues in India and list ways that technology has been used to address these issues.
India has been having to engineer better technology to better prepare people in india for the brutal monsoon seasons in india
Which of the following is another word for a copyeditor?
microeditor
macroeditor
assignment editor
assistant editor
Answer: speaking of microeditor
Explanation: thats not the only thing i know of thats micro :0
Implement the following logic in C++, Use appropriate data types. Data types are represented as either numeric (num) or string.
start
string name
string address
num item //use int
num quantity
num price //use double as data type
num SIZE = 6
num VALID_ITEM [SIZE] = 106, 108, 307, 405, 457, 688 //use int as data type
num VALID_ITEM_PRICE [SIZE] = 0.59, 0.99, 4.50, 15.99, 17.50, 39.00 //use double as data type
num i
bool foundIt = false
string MSG_YES = "Item available"
string MSG_NO = "Item not found" get name, address, item, quantity
i = 0
while i < SIZE
if item == VALID_ITEM [i] then
foundIt = true
price = VALID_ITEM_PRICE [i]
endif
i = i + 1
endwhile
if foundIt == true then
print MSG_YES
print quantity, " at " , price, " each"
print "Total ", quantity * price
else
print MSG_NO
endif
stop
Answer:
Follows are the modified code in c++ language:
#include<iostream>//header file
#include<string>//header file
using namespace std;
int main()//main method
{
string name,address, MSG_YES, MSG_NO;//defining string variable
int item,quantity,size=6, i=0;//defining integer variable
double price;//defining double variable
int VALID_ITEM[]={106,108,307,405,457,688};//defining integer array and assign value
double VALID_ITEM_PRICE[]={0.59,0.99,4.50,15.99,17.50,39.00};//defining double array and assign value
bool foundIt=false;//defining bool variable
MSG_YES="Item available";//use string variable to assign value
MSG_NO = "Item not found"; //use string variable to assign value
cout<<"Input name: ";//print message
cin>>name;//input value in string variable
cout<<"Input Address: ";//print message
cin>>address;//input value in string variable
cout<<"Input Item: "<<endl;//print message
cin>>item;//input value in string variable
cout<<"Input Quantity: "<<endl;//print message
cin>>quantity;//input value in string variable
while(i <size)//defining while that checks i less then size
{
if (item ==VALID_ITEM[i]) //use if block to match item in double array
{
foundIt = true;//change bool variable value
price = VALID_ITEM_PRICE[i];//hold item price value in price variable
}
i++;//increment the value of i
}
if (foundIt == true)//use if to check bool variable value equal to true
{
cout<<MSG_YES<<endl;//print value
cout<<"Quantity "<<quantity<<" at "<<"Price "<<price<<"each"<<endl;//print value
cout<<"Total"<<quantity*price;//calculate the total value
}
else//else block
cout<<MSG_NO;//print message
}
Output:
please find the attached file.
Explanation:
In the above given C++ language modified code, four-string variable " name, address, MSG_YES, and MSG_NO", four integer variable "item, quantity, size, and i", and "integer and double" array is defined, that holds values.
In the string and integer variable "name, address, and item, quantity", we input value from the user-end and use the while loop, which uses the if block to check the "item and quantity" value from the user end and print its respective value.
1. Add an import statement above the class declaration to make the Scanner class available to your program.
2. In the main method, create a Scanner object and connect it to the System.in object.
3. Prompt the user to enter his/her first name.
4. Read the name from the keyboard using the nextLine method, and store it into a variable called firstName (you will need to declare any variables you use).
5. Prompt the user to enter his/her last name.
6. Read the name from the keyboard and store it in a variable called lastName.
7. Concatenate the firstName and lastName with a space between them and store the result in a variable called fullName.
8. Print out the fullName.
9. Compile, debug, and run, using your name as test data.
10. Since we are adding on to the same program, each time we run the program we will get the output from the previous tasks before the output of the current task.
Answer:
import java.util.Scanner;
public class Assignment{
public static void main(String [] args)
{
Scanner input = new Scanner(System.in);
String firstName, lastName;
System.out.print("Firstname: ");
firstName = input.nextLine();
System.out.print("Lastname: ");
lastName = input.nextLine();
String fullName = firstName +" "+lastName;
System.out.print(fullName);
}
}
Explanation:
I'll use the line numbers in the question to point at the corresponding instruction
import java.util.Scanner; -- The import statement (1)
public class Assignment{
public static void main(String [] args)
{
Scanner input = new Scanner(System.in); -- Scanner object (2)
String firstName, lastName; -- Variable declarations
System.out.print("Firstname: "); ---- Prompt to enter first name (3)
firstName = input.nextLine(); --- User input for firstName (4)
System.out.print("Lastname: "); ---- Prompt to enter first name (5)
lastName = input.nextLine(); --- User input for lastName (6)
String fullName = firstName +" "+lastName; --- concatenating both user inputs (7)
System.out.print(fullName); --- Print out fullName (8)
}
}
Read the following code:
x = 1
while(x < 26)
print(x)
x = x + 1
There is an error in the while loop. What should be fixed? (5 points)
Select one:
a. Add a colon to the end of the statement
b. Begin the statement with the keyword count
c. Change the parentheses around the test condition to quotation marks
d. Use quotation marks around the relational operator
For a while loop to function properly, it needs a colon after it.
Answer choice A is correct.
to save a copy of word online document to your hard drive which option should you select? Save as , save, rename or download and copy
Answer:
The correct answer is Save as
The option that is to select to save a copy of word online document to hard drive is the save as option.
What is word document?The term “Word Document” is used to denote the document that is made in the Microsoft Word. This document is made in the proper format with the MS Word. This document can be safe electronically by selecting the save as option.
After saving that document, this will automatically save on the hard drive of the computer device of that user.
Therefore, option A is correct.
Learn more about the Word document, refer to:
https://brainly.com/question/15939168
#SPJ2
Which statements are true regarding file management? File management means grouping related files into folders. You can store multiple folders within a file. However, a single folder can only store a single file. You can also create subfolders. Related folders when grouped together are called subfolders. When you logically organize files, folders, and subfolders, you'll get a file hierarchy resemblinga tree.
The statements that is true regarding file management are;
File management means grouping related files into folders. You can also create subfolders. Related folders when grouped together are called subfolders. What is file management what does it include?File Management is known to be one that is made up of the common operations done on files or groups of files, such as creating, opening, renaming, and others
Note that in file management, Each user are required to access to create, delete, read, write, and modify a file and also user need to have limitations to no access to others files.
Hence, The statements that is true regarding file management are;
File management means grouping related files into folders. You can also create subfolders. Related folders when grouped together are called subfolders.Learn more about file management from
https://brainly.com/question/12736385
#SPJ1
Before inserting a preformatted table of contents, what must you do first?
apply heading styles to text
update the table of contents
navigate to the Review tab and the Table of Contents grouping
navigate to the Insert Table of Contents dialog box
Answer: apply heading styles to text.
Explanation:
Your game design company has recently asked all employees to use a specific personal information management application (PIM) to increase workplace efficiency. The PIM is collaborative, so contacts, calendar entries, and notes are shared across the team. Several team members are resistant to the idea, saying it interrupts their workflow, and they prefer their own way of handing contacts, notes, etc. Others don’t want their own notes to be seen by their coworkers.
Answer:For example, an office worker might manage physical documents in a filing cabinet by placing them in folders organized alphabetically by project name, or might manage digital documents in folders in a hierarchical file system.
Explanation:
If a function does not return a value, which of the follow is correct?Group of answer choicesThe return type is a Swift optional type.The return type must be set to nil.The return type is omitted from the function declaration.
Answer:
In swift programming language it is ok when a function does not return any value you are not necessarily required to set return type because it is optional so the correct answer is "The return type is omitted from the function declaration".
Explanation:
If programing language is swift so we can omit return type from function declaration otherwise if language is C++ we can set return type "Void".