Types of relationships is important for database designers

Assignment Help Basic Computer Science

Reference no: EM132410650

Discuss the differences between storing data in a spreadsheet verses storing data in a database.

In what business scenarios might one approach be superior to the other?

What are the pros and cons of each approach?

Why do you think many businesses today use both spreadsheets and databases to manage their data?

Share at least one real-world example of the following types of data relationships:

1:1

1:M

M:N (many-to-many)

Your example can be from work, school, a hobby, or daily life.

Discuss why you think making the distinction between these types of relationships is important for database designers. How does each of these types of relationships affect the complexity of storing and retrieving data? How do database architects apply the concepts of primary and foreign keys to each type of data relationship?

Reference no: EM132410650

Questions Cloud

How might the sentiment apply to all of us : Kepler saw astronomers as "priests of Almighty God" who have "the honor of standing guard...at the door of the shrine at whose high altar Copernicus performs.

Prepare outline for research paper about customer service : Prepare a full sentence outline for research paper about customer service. The outline should include a cover page and list of references

Leaders make in treating adaptive challenges : What is the biggest error that leaders make in treating adaptive challenges?

List the types of input stakeholders may have in decision : What key stakeholder groups would you include in the reference group? List the types of input these stakeholders may have in the decision.

Types of relationships is important for database designers : Discuss why you think making the distinction between these types of relationships is important for database designers.

Why the decisions you make should reflect organisation : In your response, provide the consequences of not considering these aspects.

To what area of philosophy does the topic belong : PHIL 1500 - What is the author's topic? To what area of philosophy does that topic belong? What is the author's claim with respect to his chosen topic?

Identify the type of analysis that is appropriate : Some critics of big business argue that CEOs are overpaid and that their compensation is not related the performance of their company. To test this theory

Define the objectives or goals of the data analysis : Data Mining Assignment - Define the objectives or goals of the data analysis. Describe the benefits of using the tool you have chosen for extracting data

User Account

All Pages