Answered step by step
Verified Expert Solution
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. What does the term data independence mean, and why is it an important goal?
- 2. List 10 potential benefits of the database approach over conventional file systems.
- 3. List five costs or risks associated with the database approach.
- 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.
- 5. Name the five phases of the traditional systems development life cycle, and explain the purpose and deliverables of each phase.
- 6. In which of the five phases of the SDLC do database development activities occur?
- 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.
- 8. Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database.
- 9. In the three-schema architecture:
- a)The view of a manager or other type of user is called the ______ schema.
- b)The view of the data architect or data administrator is called the ______ schema.
- 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 ...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started