1. a) Briefly discuss the TWO major components of SQL and what function they service?
b) What are the advantages and disadvantages of SQL?
c) With the help of a suitable example, explain the function of each of the clauses in the SELECT  statement
d) Explain how GROUPED BY clause works.
e) Define the TWO Principal Integrity rules of the relational model why it is desirable to enforce  these rules.

2. a) Describe the purpose of Normalization. Provide definitions for the first three normal forms.

b) Normalize the following form up to third normal form.