Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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:
Difference between LEFT OUTER JOIN and RIGHT OUTER JOIN In left outer join tuples from the left-hand-side relation which do not match any tuple in the right-hand-side relation
Explain the Query Processing Data Query Processing permits a user to report or analyze structured and unstructured data pulled from multiple data sources.
How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct
The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASS
Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that
How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.
#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by
Explain sorted File with advantages? Sorted file The sort utility shall perform one of the subsequent functions: 1.Sort lines of all the named files together and write the
In order to keep pace with competitors, Space Ltd has decided to implement an ERP system in order to replace its old legacy and manual systems. Management does not have much knowle
gyan gurukul is a software company that provides software related solution.
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd