Find the ids of suppliers who supply some red or green part

Assignment Help Computer Engineering

Reference no: EM132115949

Answer the following Question :

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. (0.25)

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

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

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

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

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

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

Reference no: EM132115949

Questions Cloud

What is the morality of posting an encryption key : Discuss your answer using Act utilitarianism while taking into account the harms and benefits.

Name of java class for creating a window with a title : Name of Java class that is a layout manager for placing components sequentially (left to right) in the order they were added?

Implement the vertex cover problem : Implement the Vertex Cover problem; that is, given graph G and integer k, answer the question of whether or not there is a vertex cover of size k or less.

Average of two defects per mile after being used : The roads recently paved by low bidding company revealed an average of two defects per mile after being used for one year. Using a Poisson distribution

Find the ids of suppliers who supply some red or green part : Find the names of suppliers who supply some red part. Find the IDs of suppliers who supply some red or green part.

Was slavery premised on racism or did slavery cause racism : HIST 316-11SS African American History Assignment- Based on the development of colonial slave codes - Was slavery premised on racism or did slavery cause racism

Calculate total degree of freedom : Calculate total degree of freedom. Calculate the pooled variance. (Round the answer to 2 decimal places)

List four different types of network segments : The systems development lifecycle (SDLC) provides a standardized process for all phases of any system development.

What is the total number of blocks that were released : A user opens a file containing an image of size 640 × 640; the color of each pixel is coded on 32 bits.

User Account

All Pages