1. Explain the advantage of database system over file processing system.
2. Explain what is mean by the following terms in DBMS, illustrate each one with an example.
a. Foreign key b. Primary key c. weak entity set d. Aggregation
3. Explain in detail all the fundamental operation of Relational Algebra.
4. Define the following terms with example.
(i) Candidate key. (ii) Weak entity set (iii) Aggression.
5. Consider the following scheme.
Supplier (sid, sname, address)
Parts (pid, pname, color)
Catalog (sid, pid, cost)
Write the following querries in relational algebra and SQL.
(i) Find the names of supplier who supplies some red parts.
(ii) Find the sids of supplier who supply every red or green part.
(iii) Find the pids of part that are supplied by at least two different suppliers.
6. What is view ? How is it created and stored? What are the benefits and limitation of views?
7. Construct an ER diagram for a hospital with a set of patients and set of medical doctors. Associate with each patient a log of various tests and examination conducted. Map this schema into relational schema by stating appropriate mapping rule, and specify all primary and foreign keys.
8. List the ACID properties. Explain the usefulness of each?
