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)
Describe the difference between a one-to-many and a many-to-many relationship. Which logical data structures comprise one-to-many and which comprise many-to-many relationship?
Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t
Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR
Explain the disadvantages of creating a temporary table? If you have already created a temporary table with a shown name and attempting to create a second one with that nam
Define Join and Outer Join and differentiate between them. Ans: Join - It generates all the combinations of tuples from two relations which satisfy a join condition. Oute
Explain the Strategy of Database Planning ?
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record
Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O
Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver
Explain how you can define an object model of a system. A list of terms that shall be used by end users to describe state and behaviour of objects in system. Different use
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