Q1.
a) Consider the given schema:
Suppliers(sid: integer, sname: string, address: string)
Parts(pid: integer, pname: string, color: string)
Catalog(sid: integer, pid: integer, cost: real)
Here, sid is the key for the Suppliers, pid is the key for Parts, and sid and pid altogether form the key for Catalog.
Write down an expression in SQL for each of the given queries:
a) Determine sids of suppliers who supply some green or red part.
b) Determine the sids of suppliers who supply every red part.
c) Determine the sids of suppliers who supply just red part.
d) Determine the sids of suppliers who supply some green part and some red part.
Q2. Describe the two tier architecture of the DBMS.
Q3. Illustrate the responsibilities of the Database Administrator (or DBA)?