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!
Discuss the problem of Spurious tuples and how we may prevent it.
Ans: A spurious tuple is, mainly, a record in a database that gets created while two tables are joined badly. In database-ese, spurious tuples are formed while two tables are joined on attributes which are neither primary keys nor foreign keys. To prevent spurious tuples, avoid joining relations that consist of matching attributes that are not (foreign key, primary key) combinations as joining on such attributes may generate spurious tuples.
Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse
explain cascading rollback
What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace
What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr
Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.
What are stored and derived attributes? Stored attributes: The attributes keeps in a data base are known as stored attributes. Derived attributes: The attributes that are de
User error : This contains errors in the program (e.g., Logical errors) with errors made by online users of database. These types of errors can be avoided by applying some check
Give an example of Object Representation For illustration, consider the implementation of a social security number within an employee object that is shown in Figure. The soci
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs
Define physical and logical data independence. How does this architecture help in achieving these? Data independence entails that change in one view must not need a change in t
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