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...
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...
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...
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...
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...
SECTION 1: CASE STUDY: Audit of Sales and Collections Cycle (85 Marks) Read the case below for Digitex LLC and a...
SECTION 1: CASE STUDY: Audit of Sales and Collections Cycle (85 Marks) Read the case below for Digitex LLC and answer the question that follow: Brief company background Digitex LLC has been in business since 1998 and has grown rapidly over the Middle East. The company is a distributor of electronic parts and equipment to the IT industry in the GCC region. Digitex has some strong internal controls policies and procedures over its business environment both internally and externally. However,...
Complete this question by entering your answers in the tabs below. Required A Record each transaction...
Complete this question by entering your answers in the tabs below. Required A Record each transaction in the appropriate columns. Indicate the financial statement effect. (Enter decreases with a minus sign to indicate a negative financial statement ASSETS LIABILITIES Net income = Revenue - Expenses Transaction Accounts + Receivable + Merchandise Inventory Notes Payable STOCKHOLDERS' EQUITY Common Stock Accounts Payable Cash + Equipment = + Required A next Use the horizontal model, or write the journal entry, for each of...
MULTIPLE CHOICE [20 MARKS] Answer ALL questions. QUESTION ONE REQUIRED For each of the questions below write down o...
MULTIPLE CHOICE [20 MARKS] Answer ALL questions. QUESTION ONE REQUIRED For each of the questions below write down only the letter of the most appropriate ane eg. 1.11 C. Note: Calculations must not be shown in your answer book. are items that may be included as part of Trade and other receivables in the А balance sheet Trade debtors; Accrued expenses; Income received in advance Trade creditors; Accrued expenses; Income received in advance Trade debtors; Income received in advance; Prepaid...
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...
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...
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...
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...
SECTION 1: CASE STUDY: Audit of Sales and Collections Cycle (85 Marks) Read the case below for Digitex LLC and answer the question that follow: Brief company background Digitex LLC has been in business since 1998 and has grown rapidly over the Middle East. The company is a distributor of electronic parts and equipment to the IT industry in the GCC region. Digitex has some strong internal controls policies and procedures over its business environment both internally and externally. However,...
Complete this question by entering your answers in the tabs below. Required A Record each transaction in the appropriate columns. Indicate the financial statement effect. (Enter decreases with a minus sign to indicate a negative financial statement ASSETS LIABILITIES Net income = Revenue - Expenses Transaction Accounts + Receivable + Merchandise Inventory Notes Payable STOCKHOLDERS' EQUITY Common Stock Accounts Payable Cash + Equipment = + Required A next Use the horizontal model, or write the journal entry, for each of...
MULTIPLE CHOICE [20 MARKS] Answer ALL questions. QUESTION ONE REQUIRED For each of the questions below write down only the letter of the most appropriate ane eg. 1.11 C. Note: Calculations must not be shown in your answer book. are items that may be included as part of Trade and other receivables in the А balance sheet Trade debtors; Accrued expenses; Income received in advance Trade creditors; Accrued expenses; Income received in advance Trade debtors; Income received in advance; Prepaid...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago