Write names and e-mail addresses showing foreign key columns

Assignment Help Database Management System

Reference no: EM1386021

Suppose the 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 down the SQL code to complete the following requests.

1. Illustrate all the data in each of four tables. Don't show foreign key columns.
2. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.
3. Write all \versions of stoves which are of a type "Maytag" and they have not spent any money on repairs.

Reference no: EM1386021

Questions Cloud

Analogue of max flow min cut theorem-capacitated network : Explain how to define the s-t cut on node capacitated network as opposed to edge capacitated network, and how would one illustrate that analogue of the max flow min cut theorem.

Compute the recipe to make desired solution : You require to prepare 200 uL of each protein at a concentration of 1mg/mL for an upcoming experiment. Compute the recipe to make each desired solution at the above concentration and volume.

Problem related to national exercise rate : A researcher believes that the percentage of people who exercise in California is greater than the national exercise rate. The national rate is 20%. The researcher gathers a random sample of 120 individuals who live in the California and finds tha..

Efficiency of biological oxidation of glucose by respiration : G for complete oxidation of glucose is -686 Kcal/Mole. According the G for ATP and number of ATP's produced from the complete oxidation of glucose calculate the efficiency of biological oxidation of glucose by respiration.

Write names and e-mail addresses showing foreign key columns : Illustrate all the data in each of four tables. Don't show foreign key columns. Write down the names and e-mail addresses for all customers who have had stove repair which cost more than $50.

Which approaches to employee development are used : Which approaches to employee development are used at Patagonia? How does employee development at Patagonia contribute to the company's strategies relating to employee retention

Regression equation to explain outcomes : At times we can generate a regression equation to explain outcomes. For example, an employee's salary can often be explained by their pay grade, appraisal rating, education level, etc.

Theorist and sources of the theories : Determine two key theories in your field. Determine the theorist(s) and sources of the theories (key articles or books) in your discipline. Explain the basic tenets of these theories.

Describing the change management approach : Describing the change management approach and recommended action steps you would advise for minimizing adverse impact on the organization and its people.

User Account

All Pages