Create a database for managing our business

Assignment Help Basic Computer Science

Reference no: EM13167817

Evaluate the given statement and discuss some approaches to address the issue: "We spent several million dollars a few years ago to create a database for managing our business. In the past several months, we acquired a new business but its data does not fit in our current system. What can we do to solve this problem?"

Discuss some possible solutions and strategies for improving the performance of SQL queries and their ability to provide data to users:

Identify the performance or usability issues that need to be addressed.

Outline a possible solution for each issue. Use supporting examples, if necessary.

Briefly describe how you would implement your solutions.

Discuss how cardinality affects database design? Provide an example to support your answer.

Discuss the importance of triggers and some risks associated with their use.

In your opinion, state when using triggers makes the most sense. Why? When should you not use them? Why?

Reference no: EM13167817

Questions Cloud

State eye of a hurricane is less than atmospheric pressure : The pressure in the eye of a hurricane is less than atmospheric pressure. Which one of the following pressure readings could not have been taken

How much chocolate would you have to consume : A 1.0 ounce piece of chocolate contains 15 of caffeine, and a 6.0 ounce cup of regular coffee contains 105 of caffeine.How much chocolate would you have to consume to get as much caffeine as you would from 5.0 cups of coffee?

Program that prompts the user to enter grades in a loop : Write a main program that prompts the user to enter grades in a loop, ending on a negative number, stores the grades in a vector, and asks the user for a passing grade. Ten pass the grade vector and passing cutoff to the function and print the per..

Compute the expectations of x and y : One of the 4 bus drivers is also randomly selected. Let Y denote the number of students on his bus. Compute the expectations of X and Y:

Create a database for managing our business : Evaluate the given statement and discuss some approaches to address the issue: "We spent several million dollars a few years ago to create a database for managing our business. In the past several months, we acquired a new business but its data does ..

Compute the required quantity of each reagent : Describe the preparation of 12 mL of a 0.050 M solution of each of the halogens, using the reactions in the preceding question. Available to you are solid Ca(OCl)2

What are venn diagrams : Imagine you are talking about your college math class over the family dinner table with your father, and he asks, "What are Venn diagrams?" Describe how you would explain them to him.

The concentration of medication in the blood declines : After a dose, the concentration of medication in the blood declines due to metabolic processes. The half-life of a medication is the time required after an initial dosage for the concentration to be reduced by one-half.

How many are taking english : In a group of 97 students, the number taking English is twice the number of those taking Math. 53 students are taking one of these subjects and 15 are taking neither. How many students are taking math? How many are taking English?

User Account

All Pages