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!
A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time.
A relation state r of the relation schema R (A1,A2,..........AN), also denoted by r(R) is a set of n-tuples
r = {t1,t2,............tm}
Where each n-tuple is an ordered list of n values
t = 1,v2,........, vn>
where every vi belongs to domain (Ai) or includes null values.
The relation schema is also known as 'intension' and relation state is also known as 'Extension'.
Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship
Type of database technology
explain at least five widly used case tools
Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio
What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.
Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.
Explain cursors in SQL? Cursors in SQL - An object used to store the output of a query for row-through-row processing through the application programs. Cursors are constructs
explain exhausitively the problems associated with er diagrams with ellustrations
Advantages of Data Distribution The primary benefit of distributed database systems is the ability to access and share data in a reliable and efficient manner.
When every condition appears with equality condition (=) only. c) Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha
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