For purposes of this discussion, assume that Woodcraft is an online store that sells wooden craft...

Question

For purposes of this discussion, assume that Woodcraft is an online store that sells wooden craft kits to churches, scouting organizations, and other groups that need crafts for children. Download the attachmentand save Woodcraft's database to your computer. View the content and structure of the database, and then answer the following minimum of 1-2 paragraph answers per question.   	1. What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business? ( 1 paragraph answer) 	2. Describe what information you might want to select from the database in the form of a query, and list the specific columns and data that the query would produce. ( 1 paragraph answer) 	3.Assume that they have hundreds of customers, rather than the short list found in the database file. (1 paragraph answer) 	4. Suggest additional tables and information that you would like to see in a database like this, the kinds of queries that it would facilitate, and how such queries would help the company improve its business goals of profitability, cost reduction, or other business strategies. (2 paragraph answer) 	5. Research one new feature that you haven't studied as it relates to query generation, and show how you could use that feature to create a useful query. Use the Woodcraft database to showcase this query-generation technique and post it in this discussion. (1 paragraph answer)

David · Accepted Answer

What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, 
relationship with its customers, or other aspects of its business? 
1. Improving Sales: 
Using the given database, first of all,

For purposes of this discussion, assume that Woodcraft is an online store that sells wooden craft kits to churches, scouting organizations, and other groups that need crafts for children. Download the...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment