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
explain normalization,and give the examples 1NF,2NF,3NF,BCNF.AND FUNCTIONAL DEPANDENACY AND DECOMPOSITION TECHNIQUES.

What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

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

Need a sample of a clinic database relationships