Write names and e-mail addresses from database

Assignment Help Database Management System

Reference no: EM1348009

Q1) Suppose a database has tables given below;

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. Write 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.

Reference no: EM1348009

Questions Cloud

Management and leadership-defining relationship : What are the roles of individuals in the above scenarios? Are they managers, leaders, or both? What distinguishes management from the leadership and managers from leaders? The nature of relationship between leadership and management remains a top..

Improving the organizations financial position : The purpose of the Session Long Project is to give you the opportunity to explore the applicability of the Module to your own life, work, and place in space and time,

Explain how does the economist''s use of the term rent : Explain how does the economist's use of the term rent differ from everyday usage.

Impact of compensation on organizational performance : Discuss the impact of compensation on organizational performance and do we have any evidence that there is any impact

Write names and e-mail addresses from database : Suppose a database has tables given below. Write the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

Determine sources of operating and financial leverage : You have created the given income statement for the Hugo Bass Company. It represents the most recent year's operations, which ended by tomorrow.

Relevant and sunk costs : Karen's Cookie Company is considering replacing its giant cookie mixer with the new one. The following data has been compiled to measure the function:

Compute the initial energy of the crate : A bucket filled with water has a mass of 54 kg and is hanging from a rope that is wound around .050 m radius stationary cylinder. if the cylinder does not rotate and bucket hangs straight down, what is the magnitude of the torque the bucket produc..

Organizational reward systems : Compare two different views on motivation and examine the implications of these approaches for organizational reward systems.

User Account

All Pages