Write names-e-mail addresses for customers by foreign key

Assignment Help Database Management System

Reference no: EM1384497

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

1. Illustrate all data in each of the 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 that are of type "Maytag" and they have not spent any money on repairs.

Reference no: EM1384497

Questions Cloud

Compute the mean and sd of the probability : Compute the mean and SD of the probability of the mean and determine the test statistic

Supervisors technicians and skiled workers in dangerous work : As a project manager on site where work for 3 km long tunnel has been undertaken the site is remote and takes about 2 days to travel to nearest town supervisors technicians and skiled workers in dangerous work.

Illustrate what does a flow chart tell us : Jack shows us a flow chart of the new warehouse system this week. Illustrate what does a flow chart tell us? Elucidate how can we use which information.

Management evolving in today business environment : Elucidate how are the functions of management evolving in today's business environment. Are the functions of management currently evolving in your project company? In illustrate what way(s)?

Write names-e-mail addresses for customers by foreign key : Illustrate all data in each of the 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.

How to spend her marketing time and budget : Advise a friend who wants to open a coffee shop in a popular neighbourhood which currently does not have a coffee shop on elucidate how to spend her marketing time and budget.

Price and output determination : Evaluate the impact of the proposal to cut prices on total revenue, totalcost, and total profits - Price and Output Determination:Monopoly and Dominant Firms

Same sex couples and law : Should same-sex couples receive constitutional protection? In what way and to what extent is the criminal law an appropriate mechanism to deal with personal choices people make?

Microbiolgy question : A casino paid 28,000 for a grilled cheese sandwich that was purported to have an image of the Virgin Mary on it.

User Account

All Pages