Share
Explore BrainMass

Database, subqueries, and joins

•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?

Solution Preview

Outlined the guidance using the questions supplied.

Think of a purpose for creating a database and describe the database. Explain why you would want to use a database for this purpose.
A database to track the purchases of commercial customers and residential customers. The database would have the products purchased, the type of payment used, the sales person involved for commercial sales, and the CS representative for residential, type of contact, general information about address/phone/type of business or residential customer, how many times the customer has ordered, variations in products requested, and information about the products. There would also be a section that is specific to products including type, color, general information, inventory on hand, production expectations regarding inventory.
From this the company ...

Solution Summary

An explanation of a database and its uses, including using subqueries and joins and effectiveness for both.

$2.19