Benefits of views-data control, Database Management System

Benefits:

  • It limits data access.
  • It makes difficult queries look easy.
  • It permits data independence.
  • It presents dissimilar views of the similar data.

 

Posted Date: 3/11/2013 1:20:37 AM | Location : United States







Related Discussions:- Benefits of views-data control, Assignment Help, Ask Question on Benefits of views-data control, Get Answer, Expert's Help, Benefits of views-data control Discussions

Write discussion on Benefits of views-data control
Your posts are moderated
Related Questions
Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous

The following data are required to be stored by a family physician. Family#, FamilyAddress, Patient#, PatientName, ServiceCode, ServiceFee, ServiceDate A family can have seve

Sub query in the UPDATE command : Example :  //Double  the  commission  for  employees,  who  have  got  at  least  2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE

What are the advantages of object ID? The main advantages of Object IDs are as below: i) IDs are not changing  ii) IDs are completely independent of the changes in data v

Briefly explain each of the following database terms. Use no more than 2-3 lines for each term. 1. DBMS 2. Update Anomaly 3. Alias (referring to tables in SQL queries)

Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

Give a sample of the Dynamic Model. The sample of dynamic model is given below:  Dynamic model for the car: Brake and Accelerator            Brake or Applies Accelerator