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.
What is the meaning of Data Independence ?
ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.
Consider a database application that deals with an Employee relation with information such as SIN, name, data of birth (DOB), and DID (the ID of the department at which the employe
Define Boyce codd normal form A relation schema R is in BCNF with respect to a set F of functional dependencies if, for all functional dependencies in F + of the form.α ->β.
How does a query tree represent a relational algebra expression? Discuss any three rules for query optimisation, giving example as to when should each rule be applied. Ans
(a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh
What is an ERD?
Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info
Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.
What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.
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