•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?
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 ...
An explanation of a database and its uses, including using subqueries and joins and effectiveness for both.
SQL 2005 stored procedures, sub query and join general question.
1. Stored procedures in SQL 2005 can be written in a variety of languages. Why is this important in the development of database systems? Provide an example of a stored procedure that a database designer might write to demonstrate why this capability is important. Please include references.
2. Which is better to use, a sub query or a join? Why? Please include example of each to support your reasoning. Also, please include references.View Full Posting Details