Application Processing

No need for long essay. Just answer Accurately

The discussion assignment provides a forum for discussing relevant topics for this week based on the course competencies covered

For this assignment, make sure you post your initial response to the Discussion Area by the due date assigned.

To support your work, use your course and text readings and also use outside sources. As in all assignments, cite your sources in your work and provide references for the citations in APA format.

Start reviewing and responding to the postings of your classmates as early in the week as possible. Respond to at least two of your classmates. Participate in the discussion by asking a question, providing a statement of clarification, providing a point of view with a rationale, challenging an aspect of the discussion, or indicating a relationship between two or more lines of reasoning in the discussion. Complete your participation for this assignment by the end of the week.

Data Modeling

In this assignment, you will study data modeling. In addition, you will learn about the benefits of SQL for application processing.

research the following:

• Data modeling
• Benefits of SQL for application processing

Based on your research and understanding, complete the following discussions:

• Discuss the benefits of views. Examine how views can affect database usability by considering both positive and negative aspects. Provide examples from business cases to support your response.
• Evaluate and discuss the given comment: “The database is slow and does not provide the data I need. Using this system makes my job harder.”
  • Based on your evaluation, answer the following questions:
    • What could be the possible reasons behind the problems the user has described?
    • What would be your recommendations for addressing these problems? Why?
• Consider how business processes can change over time. Discuss the effects of these changes on database design and ongoing development in the area. Research and include at least two examples to support your claims.
• Consider the given statement: “When I provided the business requirements to the database development team, the team confirmed that it understood what I needed. However, the entity-relationship (E-R) model does not support the business requirements, and I now have to redesign the system.” How would you resolve this issue? What are some possible solutions to the stated problem?