Object query language and odmg schema , Database Management System

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL).

1178_data base table.png

(b)   Based on the above object database, write the following queries in the Object Query language (OQL):

  1. List the addresses of employees who work in a given department.
  2. List the departments with the number of employees who work in those departments:
  3. List the articles located at more than one department and their prices in each department.
Posted Date: 3/11/2013 1:13:56 AM | Location : United States







Related Discussions:- Object query language and odmg schema , Assignment Help, Ask Question on Object query language and odmg schema , Get Answer, Expert's Help, Object query language and odmg schema Discussions

Write discussion on Object query language and odmg schema
Your posts are moderated
Related Questions
What Command You Use What Day of the week were you born

Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

The Form input elements are:             Reporter name                                                text type input             Password

How does the two phase protocol ensure serializability in database schedules?   Ans:  A transaction is termed to follow the two-phase locking protocol if all locking operations

Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

Niles Video Inc. wants to create a website for online sales of movies (DVD and videotapes). People will be allowed to register as customers on the website and to update their store

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the