$02000$CST$204052101$

Module $-2$

$13$ a$)$ Consider the following schema,

$8$

Suppliers $($sid $,$ sname, address$)$

Parts $($pid$,$ pname, color$)$

Catalog $($sid$,$ pid, cost$)$

The primary key fields are underlined.

Write relational algebra expressions for the following queries:

b$)$ Find the name of parts supplied by supplier with sid$=105$

ii$)$ Find the names of suppliers supplying some green part for less than Rs $1000$

iii$)$ Find the IDs of suppliers who supply some red or green part

iv$)$ Find the names of suppliers who supply some red part

b$)$ Differentiate between the following SQL statements

$6$

b$)$ DROP and DELETE

ii$)$ ALTER and UPDATE

$14$ a$)$ Write SQL DDL statements based on the following database schema $($Assume

$8$

suitable domain types$)$:

Employee $($eid$,$ name, designation, salary, comp$\_$id$)$

Company $($comp id$,$ cname, address, turnover$)$