Object query language and odmg schema , Database Management System

Assignment Help:

(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):

List the addresses of employees who work in a given department.
List the departments with the number of employees who work in those departments:
List the articles located at more than one department and their prices in each department.

Related Discussions:- Object query language and odmg schema

Develop a fragment of a hypothetical system, The objectives of this assignm...

The objectives of this assignment are: - to develop skills in the design of database driven applications - to develop skills in applying SQL to implement the relational and

Define deadlock prevention, Define Deadlock prevention These protocols...

Define Deadlock prevention These protocols make sure that the system will never enter a deadlock state. There are two methods to deadlock prevention. One approach makes sure t

What is indexed sequential file organization, What is indexed sequential fi...

What is indexed sequential file organization? What are the applications of this organization? Ans: An index file can be employed to effectively overcome the problem of storing

Sparse and dense indexes, Sparse and Dense Indexes These indexes in pri...

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

Query evolution, what is query processing ,query optimization and performan...

what is query processing ,query optimization and performance turring?

What are the disadvantages of file-processing system, What are the disadvan...

What are the disadvantages of file-processing system? Ans: The Disadvantages of File-Processing System a. Data redundancy and inconsistency - Data redundancy means not nece

The concurrent transactions, The Concurrent Transactions Almost every ...

The Concurrent Transactions Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make

Misuse of data or a database, As with other software, databases can potenti...

As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe

ANSI SPARC architecture, explain ANSI SPARC architecture

explain ANSI SPARC architecture

What is serialization and where it is used, What is serialization? Where it...

What is serialization? Where it is used and why? Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages