Purchase Solution

Database Diagram

Not what you're looking for?

Ask Custom Question

Assume that FiredUp has created a database with the following tables:
CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateOfManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, TotalCost, TotalPaid, CustomerSK)

A. Create a view called RepairSummary that shows only RepairInvoiceNumber, TotalCost, and TotalPaid.

B. Show a SQL statement to retrieve all RepairSummary data sorted by TotalCost.

C. Create a view called CustomerRepair that shows CUSTOMER.Name and STOVE_REPAIR.SerialNumber, Date, Description, and TotalDue, where TotalDue is the difference between TotalCost and TotalPaid.

Purchase this Solution

Solution Summary

The expert assumes that FireUp has created a database with a table. A database Diagram is emphasized.

Solution Preview

A. Create a view called RepairSummary that shows only RepairInvoiceNumber, TotalCost, and TotalPaid.

____________________________-

CREATE VIEW [dbo].[RepairSummary]
AS

SELECT RepairInvoiceNumber, TotalCost, TotalPaid
FROM ...

Purchase this Solution


Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Javscript Basics

Quiz on basics of javascript programming language.