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
Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

Describe queries with complex types? The present extension of the SQL query language deal with the complex type Let us start with the simple example: Find the title and t

define anomalies and different types of anomalies with example

Explain the shadow paging recovery technique.  Ans: Shadow paging is a method used to acquire atomic and durable transactions, and provides the capability to manipulate pages i

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a

What is the error handling Traditionally, bits have been sent over line lacking any error correcting scheme in physical layer. The presence of the CPU in each modem makes it po

From SAD to OOAD (Structured Analysis and Design (SAD) to Object Oriented Analysis and Design (OOAD). We will find here how we can map various models in SAD to different model

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou