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 is the difference between WHERE and HAVING clauses?. Predicates in the WHERE clause applies to every tuple while the predicate in the HAVING clause applies to groups.

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

Define deadlock prevention. Deadlock prevention is a set of methods for ensuring that at least one of the four essential conditions like mutual exclusion, hold and wait, no pre

An object-oriented design process  1. Define the context and modes 2. Designs the system architecture 3. Identifies the principal system objects 4. Identifies concurrency in

List and also explain the dissimilar stages of DDLC ?

how oracle can be used

Q.1 Briefly discuss the different layers of ANSI SPARC architecture. Ans: The three layers of ANSI SPARC architecture are like this: 1. Internal view is at the lowest leve

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

E-R model uses this symbol to represent weak entity set ? A Doubly outlined rectangle symbol is used to represent weak entity set.