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!
Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows:
σ AGE <=30 (PERSON)
The resultant relation will be as shown:
PERSON_ID
NAME
AGE
ADDRESS
2
Sharad Gupta
30
Pocket 2, Mayur
Vihar.
Note:
1) Select operation is commutative; i.e.,
σ (σ (R)) = σ (σ (R))
Therefore, series of select can be applied in any order
2) More than one condition can be applied using Boolean operators OR & AND etc.
Sub query in the UPDATE command : Example : //Double the commission for employees, who have got at least 2 increments. UPDATE EMP SET COMM = COMM * 2 WHERE
What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.
Explain the term - Handling Boundary Condition These are some circumstances that to be handled in any system initialization and termination. Describes how system is bro
The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat
Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application
Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people
What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC
The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an
A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame
What are the components of storage manager? The storage manager components include a) Authorization and integrity manager b) Transaction manager c) Buffer manager d
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd