Question
Think of a principle for creating a database and illustrate the database. Clarify why you would want to use a database for this purpose.
1. What instance could you offer that would demonstrate using a subquery?
2. What illustration could you offer that would demonstrate using a join?
3. In your view, would you prefer using subqueries, or joins, and why?
4. What are a number of performance considerations while determining whether to use subqueries or joins?