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

Difference among a database schema and a database state, What is the differ...

What is the difference among a database schema and a database state? The collection of information stored in database at particular moment in time is known as database state a

Explain sequential file organization, Question 1 What do you mean by datab...

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

Define the third normal form, Define the Third Normal Form: The third ...

Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

A database administrator'', A database administrator''s responsibilities an...

A database administrator''s responsibilities and data contents

ER diagram, construct an er diagram for a hospital with a set of patients a...

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d

What are the four main characteristics of the database, What are the four m...

What are the four main characteristics of the database approach? The four major characteristics of the database approach are: 1. Self-describing nature of a database system. 2.

The logical dbms architecture, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE

List the data structures implemented by the storage manager, List the data ...

List the data structures implemented by the storage manager. The storage manager executes the following data structure a) Data files b) Data dictionary c) indices

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