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!
Question :
Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriented Database or OODB is defined as a persistent and sharable collection of objects defined by an OODM.
(i) OODBMSs were developed due to some of the inadequacies of the existing database technology. One of the inadequacies refers as Impedance mismatch problem. Explain what is meant by impedance mismatch, in the context of relational database system.
(ii) Give example of Four Advanced Database Applications and discuss their general characteristics. Explain why these applications are not suitable for a relational database.
(iii) Define each of the following concepts in the context of an object-oriented data model:
a. Abstraction. b. Objects and attributes. c. Methods and messages. d. Classes, subclasses and superclasses.
Explain Growing Phase of locking Growing Phase: In this phase the transaction can only obtain locks, but cannot release any lock. The transaction enters the growing phase as so
Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A
#questiontypes of keys examples..
Law Associates is a large legal practice based in Sydney. You have been asked to design a data model for the practice based upon the following specification: The practice employs
What is Alternate Key Alternate Key: This is the candidate key which is not taken as the primary key of the table. They are named so because although not the primary key, the
Foreign Keys and NULL Let us take the relation: DEPT DEPT ID DNAME BUDGET D1 M
Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)
Compare wait-die deadlock prevention scheme with wait-wound scheme Ans: Wait-Die Scheme a) Based upon a nonpreemptive technique. b) If Pi requests a resource present
Explain TPS concurreny executions stating their advantages in online business advancement
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