1. a) Briefly discuss the TWO major components of SQL and what function they service? b) What...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Investment Analysis and Portfolio Management
ISBN: 978-0538482387
10th Edition
Authors: Frank K. Reilly, Keith C. Brown
Posted Date: