What types of relationships are possible in a database

Assignment Help Database Management System

Reference no: EM13814837

1. Based on the examples in the text, if you were asked to formulate a plan for a regional drive-in restaurant chain's efforts to use information technology to attract customers, what would be the best use of information technology from the list below?

- Use IT to increase supplier loyalty.

- Use IT to increase operational efficiency.

- Use IT to create new products and business models.

- Use IT to help survive government reporting requirements. Use IT to achieve customer intimacy.

2. For which of the following industries has the Internet as a whole been a disruptive technology?

- bill payments

- air travel

- books

- real estate

3. The difference between a data warehouse and a data mart is

- a data warehouses tend to serve an entire enterprise and a data mart a single department.

- a data warehouse is historical data only and a data mart is the most recent transactions.

- a data mart requires normalized data, whereas a data warehouse does not.

- They are different names for the same thing.

4. Define operational excellence. How can information systems help achieve it?

5. List three organizational factors that can prevent a firm from fully realizing the benefits of a new information system, and provide examples of each.

6. What types of relationships are possible in a relational database? Describe and give an example of each.

- In a Relational database a tables can be combined easily to deliver data required by users, provided that any two tables share a common data element.

- Suppose we wanted to find in this database the names of suppliers who could provide us with part number 137 or part number 150.

- We would need information from two tables: the SUPPLIER table and the PART table. Note that these two files have a shared data element: Supplier Number.

- In a relational database, three basic operations, are used to develop useful sets of data select, join.( 12th Edition. Pearson Learning Solution.

Reference no: EM13814837

Questions Cloud

Why you think that worlds musics impact culture differently : Why do you think that the world's musics can impact cultures so differently? Listen to the examples of traditional musical sounds from different cultures and try to identify a common similarity.

Who are incarcerated for drug offenses : Prisons are overloaded with inmates who are incarcerated for drug offenses. What is an alternative to incarcerating them? Describe how you would handle this type of problem without incarceration, and give reasons supporting why your solution would..

Write about a popular television show wonder woman : write about a popular television show Wonder Woman, which reflected the changing role of women in American culture. Discuss your findings.

External memo of law and an internal memo of law : Explain the difference between an external memo of law and an internal memo of law

What types of relationships are possible in a database : Define operational excellence. How can information systems help achieve it? What types of relationships are possible in a relational database? Describe and give an example of each.

Embellish the facts to fully develop your arguments : Bear in mind that you do not have access to the trial court record for this assignment, which would not be the case in an actual law office setting. Therefore, you may embellish the facts as necessary to fully develop your arguments

Annotated outline and annotated bibliography : Annotated Outline and Annotated Bibliography

How does the industry structure affect the strategies : How does the industry structure affect the strategies used by the company you are evaluating - Identify the market structure (perfect competition, monopolistic competition, oligopoly, or monopoly) that best characterizes the company you are evaluat..

Response plan as a member of the emergency management team : Develop the response plan as a member of the emergency and crisis management team for your chosen scenario. Determine at least two (2) federal agencies that should assist in the response plan for the disaster scenario and summarize their duties, r..

User Account

All Pages