Case Study 2 - Perilous Printing
Perilous Printing Ltd is a small printing company that does work for book publishers. Its jobs consist of printing books or parts of books. The following data is held about the work:
(a) The company does work for many different publishing houses. The data on each publisher consists of a name, an address (street, town, city, and postcode), a telephone, and fax number.
(b) Each printing job consists of a due date, a description and a job type (rush job, normal job, or fill-in). Each printing job is associated with one or more members of staff.
(c) A printing job requires the use of several materials, such as paper and ink. The company holds details of the amount of stock of each type of material that they have on hand together with the price and a reorder level.
(d) Materials are assigned to a job via purchase orders. Each printing job may have several purchase orders assigned to it. Purchase orders identify a vendor and a date for the purchase.
(e) Likewise, each purchase order may contain several purchase order items, containing the quantity of material required.
(f) Company data consists of the name of the company, the technical head of staff, the administrative head of staff, the company's main address (street, town, city, and postcode), a telephone and fax number.
(g) Staff data consists of a name (first and last name), address, and a job title.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: 'List the surnames of all people associated with printing jobs for Addison Wesley Longman.'

Question

Case Study 2 - Perilous Printing
Perilous Printing Ltd is a small printing company that does work for book publishers. Its jobs consist of printing books or parts of books. The following data is held about the work:
(a) The company does work for many different publishing houses. The data on each publisher consists of a name, an address (street, town, city, and postcode), a telephone, and fax number. 
(b) Each printing job consists of a due date, a description and a job type (rush job, normal job, or fill-in). Each printing job is associated with one or more members of staff.
(c) A printing job requires the use of several materials, such as paper and ink. The company holds details of the amount of stock of each type of material that they have on hand together with the price and a reorder level. 
(d) Materials are assigned to a job via purchase orders. Each printing job may have several purchase orders assigned to it. Purchase orders identify a vendor and a date for the purchase.
(e) Likewise, each purchase order may contain several purchase order items, containing the quantity of material required. 
(f) Company data consists of the name of the company, the technical head of staff, the administrative head of staff, the company's main address (street, town, city, and postcode), a telephone and fax number. 
(g) Staff data consists of a name (first and last name), address, and a job title.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: 'List the surnames of all people associated with printing jobs for Addison Wesley Longman.'

Quizplus · Accepted Answer

The Answer of Case Study 2 - Perilous Printing
Perilous Printing Ltd is a small printing company that does work for book publishers. Its jobs consist of printing books or parts of books. The following data is held about the work:
(a) The company does work for many different publishing houses. The data on each publisher consists of a name, an address (street, town, city, and postcode), a telephone, and fax number. 
(b) Each printing job consists of a due date, a description and a job type (rush job, normal job, or fill-in). Each printing job is associated with one or more members of staff.
(c) A printing job requires the use of several materials, such as paper and ink. The company holds details of the amount of stock of each type of material that they have on hand together with the price and a reorder level. 
(d) Materials are assigned to a job via purchase orders. Each printing job may have several purchase orders assigned to it. Purchase orders identify a vendor and a date for the purchase.
(e) Likewise, each purchase order may contain several purchase order items, containing the quantity of material required. 
(f) Company data consists of the name of the company, the technical head of staff, the administrative head of staff, the company's main address (street, town, city, and postcode), a telephone and fax number. 
(g) Staff data consists of a name (first and last name), address, and a job title.
-Write the following query in the Object Query Language (OQL) of the ODMG object model: 'List the surnames of all people associated with printing jobs for Addison Wesley Longman.'