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.
What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th
Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult
State the Steps of Object Design Object design is a very iterative process in which various classes, relationships among objects are added when you move from one level to
What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base
What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.
Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO
Question 1 Draw a Data Flow Diagram for a University scenario Question 2 Discuss the following with suitable examples Relational Algebra Operators Database Pla
Explain the concept of Modeling With Objects A model is a conceptual representation of a specification, design or system from a particular point of view. A modelling language
Identify the need and use of data control through problem solving, illustration
Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher
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