Find the names of suppliers who supply some red part

Assignment Help Computer Engineering

Reference no: EM132115936

Q1. Explain the difference among the terms Primary Key, Candidate Key and Super Key with suitable examples.

Q2. Consider the following schema:

Supplier(sid: integer, sname: string, address: string)

Part(pid: integer, pname: string, colour: string)

Catalog(sid: integer, pid: integer, cost: real)

The relation Supplier stores suppliers and the key of that relation is sid. The relation Part stores parts, and pid is the key of that relation.

Finally, Catalog stores which supplier supplies which part at which cost. The key is the combination of the two attributes sid and pid.

A. Write the queries in relational algebra for the following:

1. Find the names of suppliers who supply some red part.

2. Find the IDs of suppliers who supply some red or green part.

3. Find the IDs of suppliers who supply some red part or are based at 21 George Street.

4. Find the IDs of suppliers who supply some red part and some green part.

B. For each of the following relational algebra queries, write in English what they mean.

1. psname(scolour='red'(Part) scost<100 (Catalog) Supplier)

2. psname(psid(scolour='red'(Part) scost<100 (Catalog)) Supplier)

Reference no: EM132115936

Questions Cloud

Draw the uml diagram : Draw the UML diagram (sequence diagram and activity diagram(for airport check-in and security screening and write scenario for sequence and activity .

What is the comparison distribution for the sample : Clearly state null and research hypotheses in terms of the mean scores on distraction resistance, µ, of children with bilingual upbringing.

How many bits are there in the physical address : How many bits are there in the logical address? Draw the logical address format. How many bits are there in the physical address?

Comparison distribution for the sample z score : What is the comparison distribution for the sample's Z score?

Find the names of suppliers who supply some red part : Explain the difference among the terms Primary Key, Candidate Key and Super Key with suitable examples.

Identify which of the two annuities would be a better option : Your client has identified two annuities that are available for purchase. Identify which of the two annuities would be a better option for your client

Comparison distribution for the sample z score : What is the comparison distribution for the sample's Z score? What are the cut-off values for a test with significance level 0.05?

What is the difference between binary files and text files : What is the method you call at the end of all file I/O operations in java? Which type of files can be opened and viewed by a text editor ?

Reflect on how the washington : Review the information in the Washington Post article "Review of Prostate Cancer Drugs Provenge Renews Medical Cost-Benefit Debate" in the Learning Resources

User Account

All Pages