Homework Answers
Option D is true,
It will returns cid which id always used an online and saving account.
Because first part of is return the cid of customers who have not type online means this part is returns the cid of saving type and second part is return the cid of customers who have not type saving means this part is return the cid of online type ids,
And now both parts union is return the Cids of customers who have type online and saving.
Add Answer to:
Application domain. Consider a simple banking application in which customers perform transactions on some of their...
CUSTOMER EMP INVOICE LINE P CODE V CODE CUS CODE EMP CODE NV NUMBER NV NUMBER,...
CUSTOMER EMP INVOICE LINE P CODE V CODE CUS CODE EMP CODE NV NUMBER NV NUMBER, LINE NUMBER Create SQL queries for displaying the following results 5. List the customers who have ordered product bearing product code "23109-HB. Display first names, last names of customers, invoice numbers and product codes 6. Display Vendor details (V_CODE, V NAME) and product details (P CODE, P DESCRIPT) and product quantity on hand in excess of product min quantity (give alias of Quantity above...
Create SQL statements based on the given tables: Code to create the tables: CREATE DATABASE LAB...
Create SQL statements based on the given tables:
Code to create the tables:
CREATE DATABASE LAB4DB;
USE LAB4DB;
CREATE TABLE CUSTOMER (
CUS_CODE int primary key,
CUS_LNAME varchar(15),
CUS_FNAME varchar(15),
CUS_INITIAL varchar(1),
CUS_AREACODE varchar(3),
CUS_PHONE varchar(8),
CUS_BALANCE float(8)
);
INSERT INTO CUSTOMER
VALUES('10010','Ramas','Alfred','A','615','844-2573','0');
INSERT INTO CUSTOMER
VALUES('10011','Dunne','Leona','K','713','894-1238','0');
INSERT INTO CUSTOMER
VALUES('10012','Smith','Kathy','W','615','894-2285','345.86');
INSERT INTO CUSTOMER
VALUES('10013','Olowski','Paul','F','615','894-2180','536.75');
INSERT INTO CUSTOMER
VALUES('10014','Orlando','Myron','','615','222-1672','0');
INSERT INTO CUSTOMER
VALUES('10015','O''Brian','Amy','B','713','442-3381','0');
INSERT INTO CUSTOMER
VALUES('10016','Brown','James','G','615','297-1228','221.19');
INSERT INTO CUSTOMER
VALUES('10017','Williams','George','','615','290-2556','768.93');
INSERT INTO CUSTOMER
VALUES('10018','Farriss','Anne','G','713','382-7185','216.55');
INSERT INTO CUSTOMER
VALUES('10019','Smith','Olette','K','615','297-3809','0');
/*...
1 Transactions for April 2018 2 3 1 On April 1. 2018, Redmond Company, an information...
1 Transactions for April 2018 2 3 1 On April 1. 2018, Redmond Company, an information technology (IT) consulting company received $650 000 cash from the owner, Ron Larson 4 5 2 On April 3, Redmond paid $225,000 cash for land 6 7 3 Redmond purchased $1250 of office supplies on account on April 5. 8 9 4 On April 6, Redmond provided IT consulting services for a client and collected $12,000 cash, 10 11 5 Redmond provided IT consulting...
Am I missing anything? Prepare journal entries to record the following merchandising transactions of Cabela's, which...
Am I missing anything?
Prepare journal entries to record the following merchandising transactions of Cabela's, which uses the perpetual Inventory system and the gross method. Hint: It will help to identify each receivable and payable; for example, record the purchase on July 1 in Accounts Payable-Boden. July 1 Purchased merchandise from Roden Company for $6,000 under credit terns of 1/15, n/30, FOB shipping point, invoice dated July 1. 2 Sold merchandise to Creek Co. for $900 under credit terms of...
help with december 13th This problem is based on the transactions for the FastForward Company in...
help with december 13th
This problem is based on the transactions for the FastForward Company in your text. Prepare journal entries for each transaction and identify the financial statement impact of each entry. The financial statements are automatically generated based on the journal entries recorded. Dec. 1 On December 1, Chas Taylor forms a consulting business, named FastForward. FastForward receives $30,000 cash from Chas Taylor in exchange for common stock. Dec. 2 FastForward pays $2,500 cash for supplies. The company's...
Seeking help/ explanation for a SQL question. 1.) How many different customers have made orders? Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER...
Seeking help/ explanation for a SQL question.
1.) How many different customers have made
orders?
Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER (CustID, Cname, Cbirthdate, Cemail, Cstreet, Ccity, Cstate, Czip, CreditCard, CsignupDate) ORDER SHIPMENT (OrderShipiD, Ship:D, Po:D) PURORDER (POID, PurchaseDate, Shipoption, Quantity, CustID) SHIPMENT (ShipID, TrackingNum, Shipstreet, Shipcity, Shipstate, Shipzip, EstimateDeliveryDate, CustID) SUPPLIER (SID, Sname, Sstreet, scity, Sstate, Szip, Slicense) E-R Diagram: Implementation Model Quantity CLOTHES H SUPPLIER CUSTOMER Places 여 PURORDER Contains POID...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it to create tables and populate with the supplied data. If there are any errors in the script fix them. It is your job to find the errors and correct them. This is important. You will need correct data for future exercises in this module. Then answer all questions. Write the answer below each question then take screen shot of the result. This script builds...
Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell...
Jacket Frenzy is a small clothing manufacturer, specializing in creating custom, one-of-a-kind jackets. They exclusively sell their product through their online store. Jacket Frenzy is run by a team of three staff members: April, Beatrice, and Claudia. April and Beatrice work together to manufacture jackets. Claudia manages orders, sales and delivery. Jacket Frenzy receive requests through their online store, and Claudia responds with a quote, after consulting with a member of the manufacturing team. If the customer confirms their order,...
some of these are wrong but I'm not sure which, please help and show work. Thank...
some of these are wrong but I'm not sure which, please help and
show work. Thank you!
Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering,...
please correct the general journal transactions. i have completed most of the transactions. transactions 12, 20,...
please correct the general journal transactions. i have
completed most of the transactions. transactions 12, 20, 21, 27,
and 32 have issues. then record the closing entry for revenues,
expenses, and cash dividends for transactions 35,36, and 37 if
necessary
On July 1, 2021, Tony and Suzie organize their new company as a corporation, Great Adventures Inc. The articles of incorporation state that the corporation will sell 20,000 shares of common stock for $1 each. Each share of stock represents...
CUSTOMER EMP INVOICE LINE P CODE V CODE CUS CODE EMP CODE NV NUMBER NV NUMBER, LINE NUMBER Create SQL queries for displaying the following results 5. List the customers who have ordered product bearing product code "23109-HB. Display first names, last names of customers, invoice numbers and product codes 6. Display Vendor details (V_CODE, V NAME) and product details (P CODE, P DESCRIPT) and product quantity on hand in excess of product min quantity (give alias of Quantity above...
Create SQL statements based on the given tables:
Code to create the tables:
CREATE DATABASE LAB4DB;
USE LAB4DB;
CREATE TABLE CUSTOMER (
CUS_CODE int primary key,
CUS_LNAME varchar(15),
CUS_FNAME varchar(15),
CUS_INITIAL varchar(1),
CUS_AREACODE varchar(3),
CUS_PHONE varchar(8),
CUS_BALANCE float(8)
);
INSERT INTO CUSTOMER
VALUES('10010','Ramas','Alfred','A','615','844-2573','0');
INSERT INTO CUSTOMER
VALUES('10011','Dunne','Leona','K','713','894-1238','0');
INSERT INTO CUSTOMER
VALUES('10012','Smith','Kathy','W','615','894-2285','345.86');
INSERT INTO CUSTOMER
VALUES('10013','Olowski','Paul','F','615','894-2180','536.75');
INSERT INTO CUSTOMER
VALUES('10014','Orlando','Myron','','615','222-1672','0');
INSERT INTO CUSTOMER
VALUES('10015','O''Brian','Amy','B','713','442-3381','0');
INSERT INTO CUSTOMER
VALUES('10016','Brown','James','G','615','297-1228','221.19');
INSERT INTO CUSTOMER
VALUES('10017','Williams','George','','615','290-2556','768.93');
INSERT INTO CUSTOMER
VALUES('10018','Farriss','Anne','G','713','382-7185','216.55');
INSERT INTO CUSTOMER
VALUES('10019','Smith','Olette','K','615','297-3809','0');
/*...
1 Transactions for April 2018 2 3 1 On April 1. 2018, Redmond Company, an information technology (IT) consulting company received $650 000 cash from the owner, Ron Larson 4 5 2 On April 3, Redmond paid $225,000 cash for land 6 7 3 Redmond purchased $1250 of office supplies on account on April 5. 8 9 4 On April 6, Redmond provided IT consulting services for a client and collected $12,000 cash, 10 11 5 Redmond provided IT consulting...
Am I missing anything?
Prepare journal entries to record the following merchandising transactions of Cabela's, which uses the perpetual Inventory system and the gross method. Hint: It will help to identify each receivable and payable; for example, record the purchase on July 1 in Accounts Payable-Boden. July 1 Purchased merchandise from Roden Company for $6,000 under credit terns of 1/15, n/30, FOB shipping point, invoice dated July 1. 2 Sold merchandise to Creek Co. for $900 under credit terms of...
help with december 13th
This problem is based on the transactions for the FastForward Company in your text. Prepare journal entries for each transaction and identify the financial statement impact of each entry. The financial statements are automatically generated based on the journal entries recorded. Dec. 1 On December 1, Chas Taylor forms a consulting business, named FastForward. FastForward receives $30,000 cash from Chas Taylor in exchange for common stock. Dec. 2 FastForward pays $2,500 cash for supplies. The company's...
Seeking help/ explanation for a SQL question.
1.) How many different customers have made
orders?
Tables: CLOTHES ClOID, Type, Brand, Descript, Matrial, MadeInCountry, Size, Price, SID, POID) CUSTOMER (CustID, Cname, Cbirthdate, Cemail, Cstreet, Ccity, Cstate, Czip, CreditCard, CsignupDate) ORDER SHIPMENT (OrderShipiD, Ship:D, Po:D) PURORDER (POID, PurchaseDate, Shipoption, Quantity, CustID) SHIPMENT (ShipID, TrackingNum, Shipstreet, Shipcity, Shipstate, Shipzip, EstimateDeliveryDate, CustID) SUPPLIER (SID, Sname, Sstreet, scity, Sstate, Szip, Slicense) E-R Diagram: Implementation Model Quantity CLOTHES H SUPPLIER CUSTOMER Places 여 PURORDER Contains POID...
some of these are wrong but I'm not sure which, please help and
show work. Thank you!
Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering,...
please correct the general journal transactions. i have
completed most of the transactions. transactions 12, 20, 21, 27,
and 32 have issues. then record the closing entry for revenues,
expenses, and cash dividends for transactions 35,36, and 37 if
necessary
On July 1, 2021, Tony and Suzie organize their new company as a corporation, Great Adventures Inc. The articles of incorporation state that the corporation will sell 20,000 shares of common stock for $1 each. Each share of stock represents...
Most questions answered within 3 hours.
-
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 35 minutes ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 1 hour ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 2 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 2 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 3 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 5 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 5 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 5 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 5 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 5 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 5 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 5 hours ago