1 discussion thread and 1 individual project

ssignment Details

Unit 3 – Discussion Board (75 points)

Due: Thu, Feb 26 |

Description

Primary Response is due by Thursday (11:59:59pm Central), Peer Responses are due by Saturday (11:59:59pm Central).

Primary Response: Within the Discussion Board area, write 500700 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.

For this Discussion Board, please complete the following:

Transaction management and concurrency control are the two most important functions of database management systems (DBMS) to ensure that the database remains in a consistent state when many users concurrently access the database, or when any system component (hardware, software, or both) experiences a failure.

Study the relevant content in the course materials and investigate the Library and Internet for the definitions and functions of transaction management and concurrency control. Then, based on the results of your research, answer the questions below. Assume that the nested transaction is used in your database.

  • What will be the pros and cons in the following cases?
    • The conservative concurrency control method is used.
    • The optimistic concurrency control method is used.
  • Provide examples as necessary.

Responses to Other Students:

Respond to at least 2 of your fellow classmates with at least a 200-word reply about their Primary Task Response regarding items you found to be compelling and enlightening. To help you with your discussion, please consider the following questions:

  • How would you justify a different perspective from your classmates on the topic?
  • How, additionally, would you defend your classmates position?
  • What critique do you offer your classmate in regard to clarity and thoroughness of their post?
  • Please address all prompts. When offering counterargument or justification, consider practice, theory, and examples from your own experience, reading, or current events in presenting your position.

For assistance with your assignment, please use your textbook, all course resources, and any external research and resources you have gathered.

Discussion Board Rubric

Expectation

Points Possible

Points Earned

Comments

Application of Learning Material Content: Initial post demonstrates understanding of Learning Material content.

25

Application of Course Knowledge: Initial post contributes unique perspectives or insights gleaned from text/learning resources, or specified by assignment.

25

DB Responses: Responds substantively to two posts. Responses encourage interaction in the Discussion Board and classroom community.

10

Academic Writing: Initial post presents information logically and is clearly relevant to discussion topic. Posts contain accurate grammar, spelling, and/or punctuation with few or no errors. All resources should be cited in current APA format.

15

Total Points

75

Total Points Earned

Assignment Details

Unit 3 – Individual Project (125 points)

Due: Sun, Mar 1 |

Description

Assignment Details:

Study the relevant content in the course materials and investigate the Library and Internet for information about the issues in database theory and practice. Then, based on the results of your research, identify 2 issues as the discussion subjects in your short research paper. You need to address the following for each issue under the discussion:

  • Evaluate the context or triggers surrounding the issue.
  • Evaluate the symptom and root cause associated with the issue.
  • Present at least one specific example to evaluate the impact of the problem.
  • Analyze the root cause of the problem.
  • Present a high-level solution to address the root cause of the problem.

List at least 5 references (textbooks can be used as references, too).

Individual Project Rubric

The Individual Project (IP) Grading Rubric is a scoring tool that represents the performance expectations for the IP. This Individual Project Grading Rubric is divided into components that provide a clear description of what should be included within each component of the IP. Its the roadmap that can help you in the development of your IP.

Expectation

Points Possible

Points Earned

Comments

Student identifies 2 issues in database theory and practice.

30

Student evaluates the context surrounding the issue as well as the symptoms and root cause.

30

Student presents at least one example to evaluate the impact of the problem as well as the solution.

30

Paper contains at least 5 references.

10

Professional Language: Assignment contains accurate grammar, spelling, and/or punctuation with few or no errors. (APA formatting is required or style specified in assignment).

25

Total Points

125

Total Points Earned

Requirements: see instrucitons

WRITE MY PAPER