Consider the following relational schema:


Supplier(Name,Part)
Project(Name,Part)


A tuple, n,p, in the ?rst relation means that supplier n has part p. A tuple n,p in the second relation means that the project named n uses part p. Write the following query in tuple and domain relational calculi: Find the names of suppliers who have a part, that is used by every project .



{SN|? Part( Supplier(SN,Part) AND
? Prj ? Project.Name Project(Prj,Part))}
{ S.Name | Supplier(S) AND
?S1?Supplier(S1) ( S.Part = S1.Part
AND ?P?Project ?P1?Project
( P1.Name = P.Name AND P1.Part = S1.Part)) }

Computer Science & Information Technology

You might also like to view...

The four Report views are Report view, _________, Layout view, and Design view

Fill in the blank(s) with correct word

Computer Science & Information Technology

Identify the letter of the choice that best matches the phrase or definition.

A. A global network made up of millions of smaller computer networks that are all connected together B. Identifies a Web site and is chosen by the site owner C. A series of computers that are connected together to share information and resources D. The information presented on a Web page E. A node that provides the ability to cross-reference information within a document or a Web page and enables the user to move from one document or Web page to another F. The computer an individual uses to access information, via the Internet G. A set of technical specifications that defines a format for sharing information H. A series of characters that the server administrator assigns to the Web server I. The software installed on your Web client that allows users to view Web pages J. The name you give a Web page K. Usually a graphic used by a company for the purposes of brand identification L. A scripting language that works with HTML

Computer Science & Information Technology

You can quickly format a table by applying a Table ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

A ________ is an object that holds specific content such as text or images

A) style B) template C) placeholder D) layout

Computer Science & Information Technology