Devry BIS245 Complete Course Latest 2021 July

BIS245 Database Essentials for Business With Labs

Week 1 Discussion

Gathering Requirements and Choosing Database Solution

Why are databases important to business? How do databases generate sales and 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?

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?

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?

BIS245 Database Essentials for Business With Labs

Week 2 Discussion

Applying Design to Entity Relationship (ER) Modeling

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.

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. How would you approach the diagramming process?

BIS245 Database Essentials for Business With Labs

Week 3 Discussion

Requirements Analysis and Conceptual Design (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.

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?

BIS245 Database Essentials for Business With Labs

Week 4 Discussion

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 (Links to an external site.) 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.

BIS245 Database Essentials for Business With Labs

Week 5 Discussion

Creating Advanced Queries and Reports (graded)

Building from week 4 discussion, use Woodcraft Database for this discussion too and 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 (Links to an external site.) and save Woodcraft's database to your computer or space in our Lab environment. View the content and structure of the database, and then answer the questions.

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.

Create a sub query as learned in Chapter 6 and describe why you chose these attributes to query and post a screenshot of your query design.

BIS245 Database Essentials for Business With Labs

Week 6 Discussion

Creating and Using Forms and Reports

Forms in Access are like display cases in stores that make it easier to view or get the items that you want. Since forms are objects through which you or other users can add, edit, or display the data stored in your Access database, then why is the design of a form important?

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?

BIS245 Database Essentials for Business With Labs

Week 7 Discussion

Integrated Applications

When a business/firm grows and has their data in different places and on different documents/spreadsheets, why is integrating data so important to the business/firm?

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 security and restrict access?

BIS245 Database Essentials for Business With Labs

Week 8 Discussion

Reflection

Class, looking back over the Course Objectives for this course, what are you looking forward to learning more about throughout your education and career? Have you already been able to apply course concepts where you work?

BIS245 Database Essentials for Business With Labs

Week 1 Lab

Complete Lab 1—Introduction to MS Visio and MS Access. Detailed instructions and requirements can be found in the Lab area for this week.

BIS245 Database Essentials for Business With Labs

Week 2 Lab

Complete Lab 2—Skills Development in Visio, creation of an MS Access 2019 database. Detailed instructions and requirements can be found in the Lab area for this week.  Don't forget to submit your lab for grading.

In an effort to improve your success in this course, you have the opportunity to resubmit your response to this assignment for a better grade if you show proof of Tutor.com usage within a week after your original grade is posted. Tutor.com is an online tutoring service that provides 24/7 assistance to you, at no additional cost. You can access Tutor.com in the course menu at the left-hand side of your screen

BIS245 Database Essentials for Business With Labs

Week 3 Lab

Complete Lab 3—Database design using Visio based on data requirements and business rules. Detailed instructions and requirements can be found in the Lab area for this week.

BIS245 Database Essentials for Business With Labs

Week 4 Case Study Milestone 1

Scenario

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:

Patients can have many doctors and many doctors can see many patients.

Patients can have many procedures and many procedures are done on patients.

Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added).

Requirements

Please identify the attributes and primary keys needed for each of the entities.

Identify the data types you would use for each of the attributes.

Determine the relationships between the entities and find the one-to-many and many-to-many relationships.

Create an ER diagram using Visio include the associative tables based on your analysis.

Identify all foreign keys needed in the database design.

Create the database and relationships in Access and populate the tables using the spreadsheets (unless your Professor wants you to type the data into the tables).

Write a 3-5-page APA paper discussing the following topics:

Discuss Database impact on the workplace,

Discuss database benefits when businesses use querie,

Forms, and reports.

Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.

Milestone 1 - Due Week 4 - 50 Points

Step       Task       Points

1a           Primary key identified for each entity (four tables): patients, doctors, procedures and appointments      5

1b           Attributes identified for each entity (four tables): patients, doctors, procedures and appointments         5

2              Data Types

2a           Identified data types      5

3              Relationships

3a           Identify one-to-many relationships         5

3b           Identify many-to-many relationships      5

4              Foreign Keys

4a           Add foreign keys to tables as needed     10

5              ER Diagrams

5a           Create an ER diagram using Visio               15

BIS245 Database Essentials for Business With Labs

Week 8 Case Study Milestone 2

Scenario

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:

Patients can have many doctors and many doctors can see many patients.

Patients can have many procedures and many procedures are done on patients.

Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables need to be added).

Requirements

Please identify the attributes and primary keys needed for each of the entities.

Identify the data types you would use for each of the attributes.

Determine the relationships between the entities and find the one-to-many and many-to-many relationships.

Create an ER diagram using Visio include the associative tables based on your analysis.

Identify all foreign keys needed in the database design.

Create the database and relationships in Access and populate the tables using the spreadsheets (unless your Professor wants you to type the data into the tables).

Write a 3-5-page APA paper discussing the following topics:

Discuss Database impact on the workplace,

Discuss database benefits when businesses use querie,

Forms, and reports.

Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.

Step       Task       Points

6              Create and Populate the Database

6a           Create the tables and relationships in Access      15

6b           Integrate the data from the spreadsheets           20

6c            Create query 1 - Create an Action query 1 - Action queries can delete records, update data, append data from one or more tables to another table, and make a new table. See your professor        10

6d           Create query 2. - Multiple criterion query             10

6e           Create query 3. - Crosstab query              10

7              Written report

7a           Discuss database benefits when businesses use queries, forms, and reports       10

7b           Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues                10

7c            Edit, spellcheck, and list references         5