Reference no: EM1354524
Q1) Assume a database has the following tables;
CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateofManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)
Write the SQL code to accomplish the following requests.
1. Show all the data in each of the four tables. Do not show foreign key columns.
2. List the names and e-mail addresses for all customers who have had a stove repair that cost more than $50.
3. List all the versions of stoves that are of a type "Maytag" and they have not spent any money on repairs.
|
Explain how can tax cuts help revive the economy
: Aggregate Demand-some-not all--of these and/or other terms from this week. Explain how can tax cuts help revive the economy.
|
|
Find the interest amount earn on the investment
: Technical College earned $3,445,553 in state aid on September 15 for the fall academic semester. The Vice-president for finance decided to invest $2,000,000 in a two month investment that pays 11.5 percent simple interest.
|
|
Writing a confrontation statement
: Using the following statement: "My daughter and I don't get along well. I feel that I am really trying, but she doesn't respond. Only last week I brought her a present, but she just ignored it" write a confrontation statement.
|
|
Explain high-voltage electric transmission wire
: Explain While adjusting a television antenna beside his mobile home and underneath a high-voltage electric transmission wire Prince received an electric shock resulting in personal injury
|
|
Write names-e-mail addresses for all customers from table
: Show all the data in each of the four tables. Do not show foreign key columns. Write names and e-mail addresses for all customers who have had a stove repair that cost more than $50.
|
|
How can maintain eco-friendly operations internationally
: Explain how Can Carter Inc. manage to maintain its eco-friendly operations internationally
|
|
Loss contingencies
: During an audit engagement, Harper CPA has satisfactorily completed an examination of accounts payable and other liabilities and now plans to determine whether there are any loss contingencies arising from litigation, claims, or assessments
|
|
Why counseling is emphasized in literature
: Can you help me gain a better understanding of why group counseling is emphasized in literature?
|
|
Elucidate what is the lerner index for this industry
: Suppose the demand curve for a monopolist is q=500-p, and the marginal revenue function is mr=500-2q. The monopolist has a constant marginal and average total cost of $50 per unit. Elucidate what is the lerner index for this industry.
|