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 database academic assignment, Develop Database academic assignment ...

Develop Database academic assignment Project Description: For a provided set of instructions in a case study design Entity Relationship Diagram. - Entity Relationship Diag

When is update_statistics command used, When is UPDATE_STATISTICS command u...

When is UPDATE_STATISTICS command used? - When processing of large data is done, this command is used. - Whenever large number of modification, deletions or copy takes place

ER diegrams, How to draw an ER diagram to a finance companz

How to draw an ER diagram to a finance companz

What is relational algebra, What is Relational Algebra? Relational algebr...

What is Relational Algebra? Relational algebra is a Procedural query Language?

Set concept is used in which type of modelling, SET concept is used in whic...

SET concept is used in which type of modelling? SET concept is used in Network Model.

What is the main advantage of the object model, What is the main advantage ...

What is the main advantage of the object model? What are its different components? The object model focuses on the logical data structures. Each object model comprises of many

Create a view that finds the student name, Section A: Use the following ta...

Section A: Use the following tables to create a database called College. Use SQL commands. Student stuid(primary) lastName firstName

What is nested trigger, What is Nested Trigger? A trigger can also havi...

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano

Whta is the advantage of the database management approach, Whta is the adva...

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

What is message switching, What is Message switching Message switching ...

What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages