Examine how views can affect database usability

Assignment Help Computer Engineering

Reference no: EM133361747

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

Using the Internet, 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?

Reference no: EM133361747

Questions Cloud

Compare processing data using apache spark and hive sql : Compare processing data using Apache Spark and Hive SQL. Provide a detailed explanation of how these systems are used with big data processing.

Identify academic articles that make the theory : CCJ 3680 Criminology, William Paterson University - Identify academic articles that make the theory-crime connections (i.e., one for each)

What advantages could time dilation have for interstellar : What advantages could time dilation have for interstellar travel? What could be some disadvantages? How did observation and deduction help Watney figure out

Create sql function that returns the number : Create SQL function that returns the number of additional DVDs that a customer may receive before they reach the limits of their contract.

Examine how views can affect database usability : Discuss the benefits of views. Examine how views can affect database usability by considering both positive and negative aspects. Provide examples

What are vaccines and what are serums : What are vaccines and what are serums? What is the purpose of your administration? How would you justify the use of serums and vaccines in drug therapies?

Quantitative and qualitative research designs : What are some other examples of similarities between quantitative and qualitative research designs?

Describe two public health issues : Describe two public health issues that one of these early public health nurses tried to address in her time.

How can a linux distro increase its user base : How can a Linux distro increase its user base? Building on our discussion from before let's talk about some individual distributions.

User Account

All Pages