Define a view and a trigger, Database Management System

Assignment Help:

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNAME renamed as SNO,  NAME, PNO,  PNAME.

View - A view is a virtual table that is based on the one or more physical tables and/or views. Instead, a  view  is  a  named  table  which  is represented,  not  through  its  own physically separate stored data, but through its definition in terms of other named tables (base tables or views).

Trigger - A trigger is a procedure which is automatically invoked through the DBMS in the response to specified modification to the database. Triggers might be used to supplement declarative referential integrity, to enforce multifaceted business rules or to audit changes to data.

Command:

CREATE VIEW SUP_PART (SNO, NAME, PNO, PNAME) AS

SELECT S.S#, SNAME, P.P#, PNAME

FROM S, SP, P

WHERE S.S# = SP.S# AND P.P# = SP.P#

 


Related Discussions:- Define a view and a trigger

What is average response time, What is average response time? The avera...

What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

Find out the names of all employees from database, Find out the names of al...

Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';

DW, #ques Define a job scheduling strategy that will meet business requirem...

#ques Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a p

E - r schema with weak entity, Consider the E/R schema with weak entity set...

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

Explain the cartesian product, Explain the Cartesian product:  The Cart...

Explain the Cartesian product:  The Cartesian product operation does not need relations to union-compatible.  The meaning of this is that the involved relations may have dissim

Normalization, Normalize the given relation to 3NF, justifying each step

Normalize the given relation to 3NF, justifying each step

In which format database schema is written, In which format database schema...

In which format database schema is written ? Data base schema is written in the DDL format.

A Biological Database on Viruses, How to create a biological database based...

How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Define database management system, Define database management system? D...

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

What are the parts of sql language, What are the parts of SQL language? ...

What are the parts of SQL language? The SQL language has various parts: data - definitition language  Data manipulation language  View definition  Transaction contr

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd