Generate queries for new database

Assignment Help Computer Engineering

Reference no: EM133215

Question

SQL Queries

Download Stoves.accdb Access database in Doc Sharing; it has following tables filled with data.

CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateofManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)

Given these tables, write down the SQL code to accomplish the following requests.

1. Show all data in each of the four tables.

2. List names and e-mail addresses of all customers who have had a stove fix that cost more than $50.

3. List all versions of stoves of type "Maytag" that have no record of being repaired.

You can view Microsoft tutorial, generate Queries for New Database, found in lecture to learn how to test your queries in Stoves.accdb. Don't worry about your SQL code being completely right. It's more significant for us to see different SQL code so we can evaluate and learn from the difference.

Reference no: EM133215

Questions Cloud

Introduce relationship sets or additional entity sets : Introduce relationship sets or additional entity sets

Problems on word processing application : Problems on word processing application

What is customer relationship management system : What is Customer Relationship management System (CRM)? How does such system add value to an organisation and to its consumers How does a Database Management System assist a business to improve centralisation, eliminate redundancy, and maintain re..

Write down program that models an employee : Write down program that models an employee

Generate queries for new database : Generate Queries for New Database

Separate following program into appropriate lexemes : Separate following program into appropriate lexemes

Write a java program that uses a two-dimensional array : Write a Java program that uses a two-dimensional array

Problem on sql statement : Problem on SQL statement

Identify and classify the it infrastructure components : Identify core and side business activities of UPS and explain how same are driven by technology, Identify and classify the IT infrastructure components available at UPS and its subsidiaries

User Account

All Pages