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!
What are the types of reference?explain it with suitable examples?
Object oriented language given the ability to refer the object attribute of the type can be referred to the specified type. We can describe the type dept with a field name and a field head which is reference to the type person and a table dept of the type dept as followed
Create type dept(
Name varchar(20),
Head ref(person)scope people
)
Create table dept of dept
The table definition must state that the reverence is derived and must still state a self referential attribute name. When interesting a tuple for dept we can then use
Insert into dept
Values('CS','john')
Determine the term- Active values An active value is that has dependent values. Every dependent value registers itself with active value that contains a set of dependent values
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
Which language has presently become the defacto standard for interfacing application programs along with relational database system? The language which has recently become the
how many hourse have been spent on a certain project
Write a Query that uses the UNION Operator 1. Use the Software Experts database to: a. Display the first and the last name of all consultants who worked on any projects f
Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.
Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o
What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide
What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac
Define multivalued dependency and 4NF. Ans: Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency α →→β holds o
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