DeVrY BIS 245 All Discussions Question -
Graded
IF You Want To Purchase A+ Work
Then Click The Link Below , Instant Download
WEEK 1
Databases
and Gathering Requirements (graded)
Why are databases important to business? How do databases
generate sales and-or profits? What databases do you interact with, and how do
they benefit you?
What is meant by requirements gathering, and
why is it important to clearly define the data requirements of a database
before creating it?
Read the General Business Example on page 7 of the Frost
section of the text. This page describes how to categorize data requirements
from a form used by a company called Reading Fool. Turn to page 12 of the text,
and pick one of the practice exercises: 1, 2, 3, 4, or 5. Present your solution
here. List the category first, and then put all of the data items in
parentheses after the category.
|
Choosing
a Database (graded)
|
Microsoft Access is one of the most popular database
platforms on the market. However, there are many competitors. Why do you think
that Access is so popular? What are some of the other types of databases
available?
Discuss the differences between Access and its
competitors. Are there truly any differences or are they the same technology
implemented in different ways?
Do you think that Access can serve as a corporate
database solution, or is it strictly a personal database solution? What might
be the difference between a personal and corporate database solution?
WEEK 2
|
Entity
Relationship (ER) Modeling (graded)
|
What role does the entity-relationship (ER)
diagram play in the design process? Discuss the different types of information
represented in the ER diagram and the symbols used to represent them. Discuss
the meaning of an entity as related to ER diagrams. How would you approach the
diagramming process?
|
This section lists options that can be used to
view responses.
|
Database
Table Design (graded)
|
When designing database tables, the difference
between a good design and a bad design can be a few seconds in response time
and several minutes. You may think that this is not a huge difference, but
imagine waiting several minutes on a web page for your results to load. How
long would you wait? A slow database can mean the loss of customers. So let's
begin by discussing some of the common elements of tables and how you would
approach the table design. What would you do to ensure that your page loads in
a few seconds? Discuss the relationship types and how they affect your design.
WEEK 3
Conceptual Database Design (graded)
Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?
Requirements Analysis (graded)
Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.
WEEK 4
Conceptual Database Design (graded)
Why do you think organizing data into tables and relationships is a good way to design a database? How do related tables improve the accuracy of data in a database?
Requirements Analysis (graded)
Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.
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. Save Woodcraft's
database to your computer or space in our iLab environment; it's found at this
link: Week 4 Woodcraft Database. The database is also found in the first page
of Doc Sharing. 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.
a. 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.
b. 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.
c. 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.
d. 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.
Later in the week, you may answer a second or third question, but let's start off with everyone answering one at a time.
a. 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.
b. 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.
c. 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.
d. 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.
|
Creating
Queries from Northwind Database (graded)
|
In Doc Sharing, you will find an Access
database labeled Week 4 Discussion Northwind. Save the database to your
computer and open the database using Access. Answer the questions below. Please
assist one another.
a. View the design of the database in the Database Tools-Relationships window. Describe some queries that would be useful to Northwind Traders as it strives to increase sales, profits, or reduce expenses. Be specific, listing the tables, columns, and data that you would extract from the Northwind Database. Also, indicate why such queries are useful from a business standpoint.
b. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document
c. Create a few queries that allow you to practice concepts from the Lab. Please, don't simply post queries from this week's lab assignment! Post a screenshot of the query design and the results set in a Word document. Also, describe how this query could help managers make a business decision.
d. Relying on the textbook, the lecture, or Internet research, describe query generation techniques that you haven't yet applied in this week's lab. Describe what the querying technique is and how it is useful. For example, you might research the concept of a parameter query, describe what it is, and then create such a query in the Northwind database. Post a screenshot of the
WEEK 5
a. View the design of the database in the Database Tools-Relationships window. Describe some queries that would be useful to Northwind Traders as it strives to increase sales, profits, or reduce expenses. Be specific, listing the tables, columns, and data that you would extract from the Northwind Database. Also, indicate why such queries are useful from a business standpoint.
b. In Microsoft Access, create some original queries, posting a screenshot of your query design and query results in an MS Word document
c. Create a few queries that allow you to practice concepts from the Lab. Please, don't simply post queries from this week's lab assignment! Post a screenshot of the query design and the results set in a Word document. Also, describe how this query could help managers make a business decision.
d. Relying on the textbook, the lecture, or Internet research, describe query generation techniques that you haven't yet applied in this week's lab. Describe what the querying technique is and how it is useful. For example, you might research the concept of a parameter query, describe what it is, and then create such a query in the Northwind database. Post a screenshot of the
WEEK 5
|
Data
Normalization (graded)
|
Explain the difference between good and bad
table structures. How do you recognize the difference between good and bad
structures? What role does normalization play in good and bad table structures,
and why is normalization so important to a good table structure?
Data
Validation (graded)
What is the importance of data validation? How
can we avoid data-entry errors? How can forms help us reduce data-entry errors?
What features does Access offer to help validate data? What are the different
kinds of validations that are required?
WEEK 6
WEEK 6
|
Data
Reporting (graded)
|
Database reports provide us with the ability
to further analyze our data and provide it in a format that can be used to make
business decisions. Discuss the steps that you would take to ensure that we
create an effective report. What questions would you ask of the users?
|
This section lists options that can be used to
view responses.
Presenting
Data Effectively (graded)
Data presentation should be designed to
display correct conclusions. What issues should we think about as we prepare
data for presentation? Discuss the different methods that we can use to present
data in a report. What role does the audience play in selecting how we present
the data?
WEEK 7
WEEK 7
Database
Navigation (graded)
Finding information in a database can be
difficult unless you know what information you need and how to look for it.
Creating a navigation system or menu allows Access to act like a
point-and-click system. What are some of the types of navigation that you can
create in Access 2010? How should we approach the design of the menu?
|
Database
Security (graded)
|
Why is data security important now more than
ever? What are some of the steps that we can take to ensure that our database
is protected and secure? How can you use user views to enhance s
No comments:
Post a Comment