What are the general transformation rules, Database Management System

Assignment Help:

What are the General Transformation Rules for Relational operations? 

Ans: The transformation rules transform one relational algebra expression to AN

EQUIVALENT ONE 

1. Employed by the query optimizer to optimize query tree 

2. Any type of rule, if applied, ensures that the resultant tree is equivalent → resulting execution plan is equivalent 

 General Transformation Rules is as follow:

1. Commutativity of s: The s operation is commutative: 

  • sc1 (sc2(R)) = sc2 (sc1(R))
  • More selective selections first

Related Discussions:- What are the general transformation rules

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

What are the advantages of dbms, What are the advantages of DBMS ? 1. ...

What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

In a relational model how relations are termed, In a relational model how r...

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

Sql, sql is relationally complete-justify

sql is relationally complete-justify

The third normal form (3nf), The Third Normal Form (3NF) Even though, t...

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

Create table, What are the advantages of creating a table from existing tab...

What are the advantages of creating a table from existing table?

Database errors, Database Errors: An error is said to have occurred if the ...

Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or

Digital, #floating point representation is used to store

#floating point representation is used to store

Data warehouse, #queDefine a job scheduling strategy that will meet busines...

#queDefine 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 pic

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