Unit 2

DATABASE DESIGN &SQL

1. Explain producer problems in detail.
2. Write and explain armstrong’s inference rules.
3. If R= {A,B,C,D,E} F=(A B, BC E, EDA). List all candidate keys for R.
4. What is data redundancy? Explain.
5. Explain normalization and its different forms.
6. Explain various SQL joins.
7. Explain the use of union and intersection operator giving examples.
8. Provide proper syntax for:

• SELECT
• INSERT
• VALUES

9.     Write and explain SQL data types.

10. Write short note on decomposition.