Purchase Solution

Creating Views using SQL statements

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.

D. Suppose that FiredUp has the rule that a customer's record can be deleted only if TotalPaid is equal to TotalCost in all repair records. Explain how you would use a trigger to enforce this rule. What type of trigger would you use? On which table would you place the trigger? Show the SQL statements that you would code, but write the rest of the trigger in generic code.

Purchase this Solution
Solution Summary

This deals with creation of views using SQL statements. Also some other operations involving views are included.

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

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.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Networking Questions

This quiz consists of some basic networking questions.

C++ Operators

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

View More Free Quizzes
Related BrainMass Solutions

  • Structured Query Language (SQL) in Practice

    What are the advantages of using stored procedures? 1. Briefly explain the use of views. Views are used to hide columns or rows, show the results of computed columns, hide complicated SQL syntax.

  • features and uses of SQL

    You might also see weird names of the indexes created by SQL for UNIQUE and PRIMARY KEY attributes, but you will not be able to drop these indexes. Views: SQL supports physical and logical views.

  • SQL Server Database for Kudler Fine Foods/Service

    133760 SQL Server Database for Kudler Fine Foods/Service Create the following two tables using the following fields: Note: Supply the appropriate SQL Server data types when creating the tables.

  • Creating a databse using Microsoft SQL Server

    247889 Creating a databse using Microsoft SQL Server Using Microsoft SQL Server CREATE DATABASE, CREATE TABLE, and SQL INSERT statements. Use the CREATE DATABASE statement to create a SQL Server database for Kudler Fine Foods.

  • create views using SQL scripts

    162902 create views using SQL scripts Using the ITD410_P1 database attached, I need to write scripts in a file called ITD410_P3.SQL to create the following views.

  • Maintenance Tools in MS SQL 2005

    , creating SQL Server Agent jobs, and scheduling backups.

  • SQL Statements to Move the Foreign Key to T1

    Then you need to extract the primary key from T2 and make a corresponding enter in T1 as a foreign key values This response provides a tutorial on creating SQL statements to move a foreign key from one table to another.

  • Write SQL SELECT, UPDATE, and DELETE statements

    250887 Write SQL SELECT, UPDATE, and DELETE statements Write SQL SELECT, UPDATE, and DELETE statements. Using the database and tables from Week Three, write queries using the SQL SELECT statement.

  • Kudler Fine Foods- Complete Database SQL Queries

    Create the following two tables using the following fields: Note: Supply the appropriate SQL Server data types when creating the tables.

View More Related Solutions