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!
Explain the Object-oriented decomposition
Object-oriented decomposition targets at identifying individual sovereign objects that encapsulate both a state and certain behaviour. Each main components of the system is known as subsystem. Then communication between these objects leads to the required solutions. Decomposition of the system in function-data model (SAD) and the object oriented decomposition are given below. Although solutions help deal with complexity, you have reasons to believe that an object-oriented decomposition is favourable since, the object-oriented approach provides for a semantically richer framework which leads to decompositions which are more closely related to entities from real world. Moreover, the recognition of abstractions supports heaving solutions to be reused and object-oriented approach supports evolution of systems better, as those ideas that are more likely to change can be hidden within objects.
Which database level is closest to the users? External database level is closest to the users.
Whenever the LIMIT clause will be used? LIMIT is used for the following kinds of problems: 1) Answering questions about first or last and largest or smallest 2) Splitting
What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.
Which database object does not physically exist? A view database object does not physically exist.
Define multivalued dependency and 4NF. Ans: Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency α →→β holds o
Explain recovery process after system failure using checkpoint. Ans: Checkpoint scheme or method is an extra component of the log based recovery system. This scheme is used to
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
What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM
Define the Canonical cover Ans: A canonical cover F c for F is a set of dependencies like F logically implies all dependencies in F c , and F c logically entails all dependen
Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b
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