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
Create a Student database and Retrieve the names of all students majoring in ‘CS' Consider the following relational database: STUDENT (name, student#, class, major) COURSE (co

What is a view in SQL? When can views be updated? A view is a virtual table which consists of columns from one or more tables. Through it is same to a table; it is stored in

Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

Question: (a) What are decision support systems, and what role do they play in the business environment? (b) Data mining is a knowledge discovery process of automated extr

Which is an advantage of view? The Advantages of view is Data security, Derived columns and Hiding of complex queries

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additi

Waterfall model is the linear model. The process is completed by step by step. We couldn't stop in between of the process. Prototype model: after get the model by low cost budget o

Define average latency time. The average latency time of the disk is one-half the time for a full rotation of the disk.

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w