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!
Define the concept of aggregation. Give two examples where this concept is useful.
Ans: Aggregation transforms a relationship among the objects into a higher-level object. A new data type known as aggregate is developed which, under specific criteria of "well-definedness," defines aggregation abstractions. Relational databases illustrated as collections of aggregates are structured like a hierarchy of n-ary relations. To keep well-definedness, update operations on such type of databases must keep two invariants. Well-defined relations are different from relations in third normal form. It is displayed that these notions are complementary and both are significant in database design. A top-down method for database design is described that separates decisions concerning aggregate structure from decisions concerning key identification. It is suggested that aggregate types, and other sorts which support real-world abstractions with no introducing Key identification.
Define null values. In some cases a certain entity may not have an applicable value for an attribute or if we do not know the value of an attribute for a certain entity. In the
What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.
Greater potential for bugs: Since the sites of a distributed system operate simultaneously, it is more complex to ensure the correctness of algorithms. The art of constructing dis
What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
What is data definition language? Explain it in detail? The SQL DDL allows specification of not only a set of relations, but also information after each relation, containing
State about the Use Case Diagram A use case diagram represents a set of use cases, actors and their relationships. These diagrams shall be used to model context or requirement
Example- Search the salary of employees who are not 'ANALYST' but get a salary below than or equal to any people employed as 'ANALYST'. SELECT EMPNO, ENAME, JOB, SAL FROMEMP
While using extract datasets it is required to have a special workarea for interface False. It is not required to have a special workarea for interface
Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.
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