Answer All the Questions
1. What are the limitations of conventional approach of managing data? Explain.
2. For what record size will clustering be of no benefit to improve performance? Can a table have clustering on multiple fields simultaneously?
3. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls?
4. With a necessary example explain (i) Basic Constructs of E-R Modeling (ii) E-R Notations.