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!
Object-oriented decompositions
Object-oriented decompositions of systems better are able to cope with change. Each subsystem has a well-defined interface which communicates with remaining system. All of these interfaces define all form of interaction which is required for proper functioning of whole system, but internal implementations are left to sub-system itself. This is since they manage to encapsulate those items which are likely to change (for example functionality, sequence of behaviour and attributes) within an object and hide them from outside world. The benefit is that the outside cannot see them, and thus cannot be dependent on them and does not need to get changed if these items change. Also, object-oriented decompositions are nearer to the problem domain, because they directly represent real-world entities in their structure and behaviour. The abstraction primitives built into reuse have a massive potential of reuse as commonalities among similar objects can be factored out and then, the solutions can be reused.
Figure: OO Decomposition (OOD)
Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera
Differentiate between natural join and outer join? Natural join is a binary operator which is written as (R * S) where as R and S are relations. The output of the natural join
Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External
Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000. CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA
Describe briefly models which define the operations on classes. The three models which are used to define operations on classes are as: Object Model = data dictionary + Obje
List any eight applications of DBMS. a) Universities b) Airlines c) Banking d) Credit card transactions e) Tele communication f) Sales g)Finance h) Manufac
Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O
Give the two reasons for allowing concurrency
Database Errors: An error is said to have occurred if the implementation of a command to manipulate the database cannot be successfully finished either due to inconsistent data or
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