Homework Answers
Please Note:
As per the HOMEWORKLIB RULES, I have answered the first
question. Please Re-post for the other Questions
Q1. Answer)
a.
select * from tblCustomer where CustomerState = 'New York';
b.
select * from tblCustomer where CustomerCreditLimit >
50000;
Add Answer to:
Q1. Based on the two tables and the attributes below, write SQL commands for each question...
using SQL Assume the relations shown below (underlined attributes are primary and foreign keys): merchants(mid, name,...
using SQL Assume the relations shown below (underlined attributes are primary and foreign keys): merchants(mid, name, city, state) products(pid, name, category, description) sell(mid, pid, price, quantity_available) orders(oid, shipping_method, shipping_cost) contain(oid,pid) customers(cid, fullname, city, state) place(cid, oid, order_date) For each of the following questions write a SQL query: List names and sellers of products that are no longer available (quantity=0) List names and descriptions of products that are not sold. How many customers bought SATA drives but not any routers between 2009...
Question 1.Write a SQL statement for each of the following questions based on the above tables...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters
Problems and Exercises 1 through 9 are based on the dass scheduling
3NF relations along with some sample data shown in Figure 6-11.
Not shown in this figure are data for an ASSIGNMENT relation,
which represents a many-to-many relationship between faculty and
sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student
table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...
Using the database: Write SQL queries for each of the questions below. 1. Find the media...
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
MULTIPLE CHOICE WRITE THE LETTER OF THE CORRECT ANSWER IN THE SPACE PROVIDED BEFORE THE QUESTION...
MULTIPLE CHOICE WRITE THE LETTER OF THE CORRECT ANSWER IN THE SPACE PROVIDED BEFORE THE QUESTION NUMBER. 3.11. The Customers List functions as the A. General Ledger B. Accounts Receivable Ledger C. Income Account D. Primary Account for each The Sales by Customer Detail report shows information about Customer A. Credit Sales B. Cash Sales C. Sales on Account D. All of the above QUICKBOOKS ONLINE PLUS: A Complete Course 2017 3.13. A Credit Memo s prepared to record a...
Please write ONE SQL statement for each of the following tasks using the below tables. Note...
Please write ONE SQL statement for each of the following tasks using the below tables. Note that you can only use conditions specified in the task description and cannot manually look up data and add conditions. Task 1: return title of textbooks with price over $100. Task 2: return number of courses sections scheduled for each year and semester. Please return year, semester, and number of courses. Task 3: Return names of all courses in Information Systems undergraduate program. Task...
Prepare and execute each of the queries listed using the "Adventureworks2012" database in SQL: Server: http://msftdbprodsamples.codeplex.com/releases/view/93587...
Prepare and execute each of the queries listed using the "Adventureworks2012" database in SQL: Server: http://msftdbprodsamples.codeplex.com/releases/view/93587 When all of your queries are complete, cut and paste the SQL Syntax into a word document. In order to see what the column names are, you need to click on the table and then Columns to see the field names. Make sure to include column headings that make sense in the queries (use the as “Field Name” after the field selected). Multi-table Queries...
Problem 1-5 using the table below in the picture to be answered in Microsoft SQL. Thanks...
Problem 1-5 using the table below in the picture to be
answered in Microsoft SQL. Thanks
4. Write SQL queries to answer the following questions, a. How many students were enrolled in secoon 14 b. How many students were enrolled in ISM 3113 5. Write an SOL query to answer the following question Which students were not enrolled in any courses on Problems and Exercises 6 through 14 are based on Figure 7-15. The problem set continues from Chapter 6,...
Write the following questions as queries in SQL. Use only the operators discussed in class (in...
Write the following questions as queries in SQL. Use only the operators discussed in class (in particular, no outer joins are allowed). Please use renaming consistently! The following database schema is given: RESEARCHER(rid,name,institution,city,country) PAPER(title,journal,volume,number,year) AUTHOR(resid,title) where rid is the identifier (primary key) of RESEARCHER, name is the researcher’s name, institution is where the researcher works, and city and country the city and country where the institution is located; title is the paper identifier (primary key) of PAPER, journal is the...
If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
Using the database: Write SQL queries for each of the questions
below.
1. Find the media type which
has 100 or more tracks. Print the name of such media type. Number
of rows returned in the result = 3
A) Find the playlists which have one or more tracks that have
never been purchased in California (CA). Print the Id, and the name
of such playlists. Number of rows returned in the result = 18
B) Find the customers who...
MULTIPLE CHOICE WRITE THE LETTER OF THE CORRECT ANSWER IN THE SPACE PROVIDED BEFORE THE QUESTION NUMBER. 3.11. The Customers List functions as the A. General Ledger B. Accounts Receivable Ledger C. Income Account D. Primary Account for each The Sales by Customer Detail report shows information about Customer A. Credit Sales B. Cash Sales C. Sales on Account D. All of the above QUICKBOOKS ONLINE PLUS: A Complete Course 2017 3.13. A Credit Memo s prepared to record a...
Problem 1-5 using the table below in the picture to be
answered in Microsoft SQL. Thanks
4. Write SQL queries to answer the following questions, a. How many students were enrolled in secoon 14 b. How many students were enrolled in ISM 3113 5. Write an SOL query to answer the following question Which students were not enrolled in any courses on Problems and Exercises 6 through 14 are based on Figure 7-15. The problem set continues from Chapter 6,...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
Most questions answered within 3 hours.
-
A galaxy is a large grouping of stars. Approximately how many
stars are in the Milky...
asked 37 minutes ago -
The Pen, Evan, and Torves Partnership has asked you to assist in
winding-up its business affairs....
asked 41 minutes ago -
A) Asha Company completed its inventory count. It arrived at a
total inventory value of
$200,000....
asked 1 hour ago -
When you move a rope up and down, waves are created. If the
waves pass through...
asked 2 hours ago -
QUESTION 52
Which of the following is a direct result of scarcity?
A college student misses...
asked 2 hours ago -
The zero order reaction 2N2O→2N2+O2 has the rate constant k of
7.20×10−3 molL s. If the...
asked 2 hours ago -
When you borrow money to buy a house, a car, or for some other
purpose, you...
asked 2 hours ago -
Write a c program that finds the uncommon elements from two
array elements using pointers
only...
asked 2 hours ago -
SQL help:
Design a database diagram for a database that stores information
about the Downloads that...
asked 3 hours ago -
In 1970s and 1980s, molecular biologists discovered that the
hormone testosterone, binds a receptor protein that...
asked 5 hours ago -
january 1 2010 road catering service purchase a piece of
equipment for 58000 which is expected...
asked 6 hours ago -
Explain Mertons concept of anomie is and what the
modes of adaptation to it are?
asked 6 hours ago