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:
What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers
what is Mapping Constraints? with examples
Differance between Unordered and ordered file ? Unordered file do no has any sequence although ordered file has arranged in a few sequence and data are assigned in ordered form
Define rotational latency time. The time spent waiting for the sector to be accessed to appear under the head is known as the rotational latency time.
explain in detail about crash recovery
Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a
What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical
What is known as clustering file organization? In the clustering file organization, records of several dissimilar relations are stored in the similar file.
A database to track your progress in your college program will track your progress towards graduation! A database that has information containing the classes that you have taken, c
There are three main sources of utilities and applications for a DBMS: a. Vendor applications and utilities are given for working with or maintaining the database, and generally
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