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!
Define the five basic operators of relational algebra?
Five basic operators of relational algebra are:1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both of them. The duplicate tuples are eliminated.R = P ∪ Q2. Minus (-) - Removes generally common tuples from the first relation.R = P - Q3. Cartesian Product or Cross Product (××××) - The cartesian product of two relations is the concatenation of tuples belonging to the two relations and consisting of all probable combination of the tuples.R = P × Q 4. Projection (ππππ) - The projection of a relation is described as a projection of all its tuples over a few set of attributes, i.e., it yields a vertical subset of the relation. It is used to either decrease the number of attributes (degree) in the resultant relation or to reorder attributes. The projection of a relation T on the attribute A is denoted through πA(T).5. Selection (σσσσ) - Selects only some of the tuples, those satisfy given criteria, from the relation. It yields a horizontal subset of a given relation, i.e., the action is defined over a complete set of attribute names but just a subset of the tuples are involved in the result.R = σB(P)
XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v
What are the aggregate objects in the data dictionary? Views Match codes Lock objects.
What is Normalization? Database normalization is a data design and organization method applied to data structures based on rules that help building relational databases. In rel
To eliminate duplicate rows (distinct operator) Example: SELECT DISTINCT DEPTNO FROM EMP;
List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view. Ans: The two restrictions are: 1. If a view
what are the purposes of dbms in details
10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet
Explain the ANSI SPARC architecture The three-schema architecture is as well known as ANSI SPARC architecture. The aim of the three-schema architecture is to separate the user
What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e
Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.
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