DAT 390 Wk 1 Discussion – Table Structures

Post a total of 3 substantive responses over 2 separate days for full participation (during a current week as only current week’s postings will be counted towards class participation for that week). This includes your initial post and 2 replies to classmates or your faculty member.

Due on Thursday, day 3 (7/7/2022)

Respond to the following in a minimum of 140 words (worth 20 points):

In this first week, you discuss four different types of table structures: heap table, sorted table, hash table, and a table cluster. These row-oriented storage options are used in databases for various reasons.

a) Select one type of table.

b) Provide an example of when it would be appropriate to use this table.

c) Explain why this type is better than another in this scenario.

Site your sources (references).

Due Monday (day 7)

Post 2 replies (60 words minimum per comment post) to classmates or your faculty member. Be constructive and professional and your comment should be relevant to the discussion topic. Each comment is worth up to 10 points.

Note 1: please avoid self-comments (as those will not be counted).

Note 2: posts that are made after the participation deadline in the current week will not be counted toward class participation points.

DAT 390 Wk 2 Discussion – Transaction Execution

Due on Thursday (day 3)

Respond to the following in a minimum of 140 words (worth 20 points):

Explain three common problems with concurrent transaction execution and how concurrency control can be used to avoid them. Describe an example that illustrates either:

A problem with concurrent transaction execution and its effects on the operational performance of the system

The effectiveness of concurrency control

Site your sources / references if used.

Due Monday (day 7)

Note 1: please avoid self-comments (as those will not be counted).

Note 2: posts that are made after the participation deadline in the current week will not be counted toward class participation points.

DAT 390 Wk 3 Discussion – Analytics Database vs. Data Warehouse

Due on Thursday (Day 3)

Respond to the following in a minimum of 140 words (worth 20 points):

IT professionals work with many non-IT business partners whose understanding and support are critical to ensuring that IT strategies are implemented and goals are attained. Imagine you are working with a non-IT partner who does not understand the differences between an analytics database and a data warehouse or the effect the differences have on how you approach data analytics.

Explain two key differences between an analytics database and a data warehouse and how those differences affect your selection of business intelligence tools and data analysis processes. Site your sources / references if used.

Due Monday (Day 7)

Post 2 replies (60 words minimum per comment post) to classmates or your faculty member. Be constructive and professional and your comment should be relevant to the discussion topic. Each comment is worth up to 10 points.

Note 1: please avoid self-comments (as those will not be counted).

Note 2: posts that are made after the participation deadline in the current week will not be counted toward class participation points.

DAT 390 Wk 4 Discussion – Data Types and Constraints

Due on Thursday (Day 3)

Respond to the following in a minimum of 140 words (worth 20 points):

Discuss two ways that data types and constraints work together to meet business requirements for a specific business scenario of your choice. Site your sources / references if used.

Due Monday

Note 1: please avoid self-comments (as those will not be counted).

Note 2: posts that are made after the participation deadline in the current week will not be counted toward class participation points.

DAT 390 Wk 5 Discussion – Languages

Due on Thursday (Day 3)

Respond to the following in a minimum of 140 words (worth 20 points):

Databases can be designed using different (programming) languages, and some may be better than others for your specific task. Select a language and explain three pros and three cons of using that language for database integration. Site your sources / references if used.

Due Monday

Note 1: please avoid self-comments (as those will not be counted).

Note 2: posts that are made after the participation deadline in the current week will not be counted toward class participation points.