BIS245 Course Discussions Week 4


BIS245 Course Discussions Week 4
Query is used to describe a question or request that is made by a user, computer, or device…

SKU: BIS 245 Creating Queries From Woodcraft Database Categories: , Tags: , , ,


BIS245 Course Discussions Week 4

BIS245 Course Discussions Week 4

Creating Queries From Woodcraft Database

Week 4 All Students Posts – 52 Pages 

  • 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? 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. Assume that they have hundreds of customers, rather than the short list found in the database file.
  • 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.
  • Using the Woodcraft database file, create some queries that use concepts found in the textbook, as well as this week’s lab. Post a screenshot of your query design and result set in a Word document.
  • 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.

My opinion is that google is like a query as to how when you type in what you want to search it breaks it down to your criteria. Using query you can tell it what you want to look for like, who, what, when and where of just exactly what you want to find easily by narrowing down your search.  So when you go to google to search for a specific thing you can make it do the exact same thing as a query…