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

What are the advantages of relational data model, What are the advantages o...

What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer

DML complier, definition and its work

definition and its work

Adjustments are required to increase chances of inheritance, What types of ...

What types of adjustments are required to increase chances of inheritance. a) Some attributes can be added or ignored in the base class operation b) Some changes can be

Case tools, explain at least five widly used case tools

explain at least five widly used case tools

Why were functional methods fashionable in early days, Why were functional ...

Why were functional methods fashionable in early days? These are inspired directly by computer architecture and thus popular among computer scientist in early days. The divisio

In a hierarchical model of data records are organized, In a Hierarchical mo...

In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

Tables, does tables are called relations

does tables are called relations

Explain about sql server 2000, What is the difference between SQL Server 2...

What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of

Dbms, statical data

statical data

Database recovery and security, Database Recovery And Security Introdu...

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages