BIS 245 Week 4 Discussion 1 | Assignment Help | Devry University
- Devry University / BIS 245
- 12 Feb 2021
- Price: $8
- Other / Other
BIS 245 Week 4 Discussion 1 | Assignment Help | Devry University
WEEK 4: CREATING QUERIES FROM WOODCRAFT DATABASE (GRADED)
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 Week 4 Woodcraft Database and save
Woodcraft's database to your computer or space in our Lab environment. View the
content and structure of the database, and then choose one of the questions
that follow to answer.
Later in the week,
you may answer a second or third question, but let's start off with everyone
answering one at a time.
·
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.