Answered: Create a temporary table for V1 b)…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

One implementation technique of a view is as a temporary table. That creates the challenge for the system to keep the temporary table up-to-date as modifications are done in the base table(s). Consider this example: create table R (a int, b int, primary key(a,b)); create view V1 as select A+B as S, A-B as D from R where A between 1 and 10;

a) Create a temporary table for V1

b) Create the appropriate trigger(s) on R that will keep V1 current on inserts and deletes

c) Provide sufficient test cases to demonstrate the correctness of your solution.

Expert Solution

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions