What do you understand by a view, Database Management System

Assignment Help:

What do you understand by a view? What does WITH CHECK OPTION clause for a view do?

- A view is a virtual table which comprises fields from one or more real tables.

- It is generally used to join multiple tables and get the data.

- WITH CHECK OPTION for a view prevents any modification to the data that doesn't confirm to WHERE clause of the view definition.

- This allows data belonging to the view to be updated through view.

Related Discussions:- What do you understand by a view

Relationship, What is multiple relationship ?

What is multiple relationship ?

Column constraints, Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY K...

Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On delete Cascade : Using this key whenever a parent row is removed in a referenced

Define the concept of design documentation, Design Documentation The ...

Design Documentation The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

Data management, Develop a database broker framework to implement a persist...

Develop a database broker framework to implement a persistence mechanism for the domain objects involved in the use case dealt with in Question 2. a. Specify the attribute type

Entity relationship, how to write tables and drow E-R diagrams for hosiptal...

how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?

Create table employee and enter employee data in sql, Create table employee...

Create table employee and enter employee data in SQL? Consider the following relational schemas: EMPLOYEE (EMPLOYEE_NAME, STREET, CITY) WORKS (EMPLOYEE_NAME, COMPANYNAME, SAL

Explain the functions of data manager, Explain the functions of data manage...

Explain the functions of data manager? Functions of Data Manager : - Convert operations in user's queries coming directly through query processor or indirectly in an applicatio

ERD DIAGRAM, Law Associates is a large legal practice based in Sydney. You...

Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs

Database for online assignment system, i want to database for online assign...

i want to database for online assignment submission system

Determine the subsystem design issue, Determine the Other System Design Iss...

Determine the Other System Design Issue How to realise subsystems; through hardware or software? How is object model mapped on chosen hardware software? Mapping

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages