Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

1. What does the term data independence mean, and why is it an important goal? 2. List 10 potential benefits of the database approach over

  1. 1. What does the term data independence mean, and why is it an important goal?

  1. 2. List 10 potential benefits of the database approach over conventional file systems.

  1. 3. List five costs or risks associated with the database approach.

  1. 4. In the three-tiered database architecture, is it possible for there to be no database on a particular tier? If not, why? If yes, give an example.

  1. 5. Name the five phases of the traditional systems development life cycle, and explain the purpose and deliverables of each phase.

  1. 6. In which of the five phases of the SDLC do database development activities occur?

  1. 7. Are there procedures and processes that are common to the use of SDLC, prototyping, and agile methodologies? Explain any that you can identify and then indicate why the methodologies are considered to be different even though fundamental procedures and processes are still included.

  1. 8. Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.

  1. 9. In the three-schema architecture:
    1. a)The view of a manager or other type of user is called the ______ schema.
    2. b)The view of the data architect or data administrator is called the ______ schema.
    3. c)The view of the database administrator is called the ______ schema.

10.Why might Pine Valley Furniture Company need a data warehouse?

Step by Step Solution

3.50 Rating (173 Votes )

There are 3 Steps involved in it

Step: 1

1 Data Independence is defined as a property of DBMS that helps you to change the Database schema at one level of a database system without requiring to change the schema at the next higher level Data ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students explore these related Programming questions

Question

25.0 m C B A 52.0 m 65.0 m

Answered: 3 weeks ago