Discuss the below:
• Think of a purpose for creating a database and describe the database. Explain why you would want to use a database for this purpose.
• What example could you offer that would demonstrate using a subquery?
• What example could you offer that would demonstrate using a join?
• In your view, would you prefer using subqueries, or joins, and why?
What are some performance considerations when determining whether to use subqueries or joins?