Homework Answers
Part a i.e. doing survey along 100m of railway line and finding groups without motor car will br easy as the cases will be limited in this study so we will have accurate data and quickly as well
And on the other hand if we go by option b then it will be lengthy as well as inaccurate as we will not be able to do check of all person without motor car but we can check all person in range of 100m of railway line
Do like the answer
Add Answer to:
Which of the two following SELECT queries (a or b) of a geographic database is likely...
Write SQL queries to answer the following question: A. Which students are enrolled in Database and...
Write SQL queries to answer the following question: A. Which students are enrolled in Database and Networking? (Hint: use SectionNo for each class, so that you can determine the answer from the Registration table by itself.) I have attempted the code below, but am receiving an error under the first SELECT, showing error code 1064, (syntax error) SELECT StudentName, StudentID FROM Student WHERE StudentID =(select StudentID FROM Registration WHERE (SectionNo=2714 OR SectionNo=2715) GROUP BY StudentID HAVING COUNT (*)>1;
In using a database created from this model, which of the following SQL queries would give...
In using a database created from this model, which of the
following SQL queries would give us a list of customers who have
daily deposit transactions (deposit is a
transaction type) totaling $10,000 or more across all of
their accounts (i.e., this is a total across all accounts of a
customer, not per account). Include in this list the Customer ID
and name, and the dates and their respective daily total.
SELECT c.cust_id, c.cust_name, DATE(t.tran_date), SUM(t.tran_amount) AS daily_total
FROM Customers...
10- Specify the following queries in SQL on the database schema of Figure 2. a. Retrieve...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
To study poverty in the city of Halifax, researchers will randomly select 30 blocks from the...
To study poverty in the city of Halifax, researchers will randomly select 30 blocks from the city, then randomly select 10 households from each of those blocks to be interviewed, producing a total of 300 interviews. Based on the interviews, the families will be classified as living below poverty line or not. Refer to the computer output below and answer the following related questions. i. (1 Mark) Based on the result of this study, how many families out of the...
Which of the following are places likely to have extremophiles living in them? Select all that...
Which of the following are places likely to have extremophiles living in them? Select all that apply. A) high salt B) low pH C)human skin D)very low temperature E)liquid magma
K3 K3 School of CS & IT, RMIT Introduction to Database Systems Tutorial Sheet 2: SQL...
K3 K3 School of CS & IT, RMIT Introduction to Database Systems Tutorial Sheet 2: SQL The database below is for a department store, and describes stock, staff, clients, and sales. Each question in this tutorial concerns this "store" database. SALE ITEM ITEM STAFF NUMSOLD CLIENT SDATE TYPE DESCRIP PRICE K3 Simon 6 Clark 19980311 Knife set $17.95 K11 Simon Cilla 19980121 K5 Ladle $6.95 K11 Simon Cilla 19980123 K11 Scraper $0.95 L12 Sorcha 5 Charles 19971130 L12 Rack $22.95...
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code =...
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY cl.CountryCode HAVING COUNT(*) > 1 LIMIT 10; From a previous question I asked which was: Using the database you installed from the link below, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses. The...
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY c...
I have this answer: SELECT c.Code, count(*) FROM country c JOIN countrylanguage cl ON c.Code = cl.CountryCode GROUP BY cl.CountryCode HAVING COUNT(*) > 1 LIMIT 10; From a previous question I asked which was: Using the database you installed from the link below, provide an example query using both a group by clause and a having clause. Show no more than ten rows of your query result. Discuss if the query you wrote can be rewritten without those clauses. The...
database
The Papa Car Service & Repair Centers are owned by the Silent Car Dealership; Papa services and repairs only silent cars. Three Papa centers provide service and repair for the entire state. Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked parts inventory. Each center also maintains a manual file system in which each car’s maintenance history is kept: repairs made, parts used, costs,...
You will develop an E-Commerce database used to maintain customers, products and sales information. You are...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
In using a database created from this model, which of the
following SQL queries would give us a list of customers who have
daily deposit transactions (deposit is a
transaction type) totaling $10,000 or more across all of
their accounts (i.e., this is a total across all accounts of a
customer, not per account). Include in this list the Customer ID
and name, and the dates and their respective daily total.
SELECT c.cust_id, c.cust_name, DATE(t.tran_date), SUM(t.tran_amount) AS daily_total
FROM Customers...
10- Specify the following
queries in SQL on the database schema of Figure 2. a. Retrieve the
names of all senior students majoring in ‘CS’ (Computer Science).
b. Retrieve the names of all courses taught by Professor King in
2004 and 2005. c. For each section taught by Professor King,
retrieve the course number, semester, year, and number of students
who took the section. d. Retrieve the name and transcript of each
senior student (Class =4) majoring in CS. A...
K3 K3 School of CS & IT, RMIT Introduction to Database Systems Tutorial Sheet 2: SQL The database below is for a department store, and describes stock, staff, clients, and sales. Each question in this tutorial concerns this "store" database. SALE ITEM ITEM STAFF NUMSOLD CLIENT SDATE TYPE DESCRIP PRICE K3 Simon 6 Clark 19980311 Knife set $17.95 K11 Simon Cilla 19980121 K5 Ladle $6.95 K11 Simon Cilla 19980123 K11 Scraper $0.95 L12 Sorcha 5 Charles 19971130 L12 Rack $22.95...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
Most questions answered within 3 hours.
-
Cobb-Douglas Preferences: Cobb-Douglas preferences on the
consump-
tion set R2+ can be represented by a utility...
asked 48 seconds from now -
In your experience, what are some of the barriers to the
successful implementation of a project?...
asked 2 minutes ago -
Math 333 Plz help ASAP
The yield of a chemical process is being studied. From previous...
asked 3 minutes ago -
1. A normal distribution has a mean of
μ = 60 and a standard deviation
of...
asked 4 minutes ago -
The size of your Social Security benefits is determined by:
(select all that apply) Question 1...
asked 17 minutes ago -
Starch polymers are broken down by enzymes into monomers
called:
a.)maltose
b.) dextrins
c.) glucose
d.)...
asked 23 minutes ago -
How does HA (High Availability) work and name two ways it can
help an organization?
asked 26 minutes ago -
Saginaw Company is a garden products wholesale firm. In
December, Saginaw Company expects to sell 26,000...
asked 26 minutes ago -
Write a program for the management of a bookstore in java,
WITHOUT THE USE OF BOOK...
asked 26 minutes ago -
. Consider the Malthusian model and assume Y = zF (L; N) = zLN 1
,...
asked 39 minutes ago -
Reasons that BMW located their manufacturing plant in
Spartanburg South Carolina include ___________
a favorable tax...
asked 41 minutes ago -
17) Complete the following by balancing the chemical
reactions:
(a) H2(g) + N2(g) → NH3(g)
(b)...
asked 41 minutes ago