Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

only do question 1,3,6,9,10,15 specialist data quality data redundancy data type data warehouse database database design database management system (DBMS) metadata multiuser database NoSQL online

only do question 1,3,6,9,10,15 image text in transcribed
image text in transcribed
specialist data quality data redundancy data type data warehouse database database design database management system (DBMS) metadata multiuser database NoSQL online analytical processing (OLAP) online transaction processing (OLTP) database operational database (SQL) transactional database unstructured data workgroup database XML database Review Questions 1. Define each of the following terms: a data b. field C record d. file 2. What is data redundancy, and which characteristics of the file system can lead to it? 3. What is data independence, and why is it lacking in file systems? 4. What is a DBMS, and what are its functions? 5. What is structural independence, and why is it important 6. Explain the differences among data, information, and a database. 7. What is the role of a DBMS, and what are its advantages? What are its disadvantages? ase Concepts 8. List and describe the different types of databases. 9. What are the main components of a database system? 10. What is metadata? 11. Explain why database design is important. 12. What are the potential costs of implementing a database system? 13. Use examples to compare and contrast unstructured and structured data. Which type is more prevalent in a typical business environment? 14. What are some basic database functions that a spreadsheet cannot perform? 15. What common problems do a collection of spreadsheets created by end users share with the typical file system? 16. Explain the significance of the loss of direct, hands-on access to business data that end users experienced with the advent of computerized data repositories. 17. Explain why the cost of ownership may be lower with a cloud database than with a traditional, company database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

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

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions

Question

It is relatively easy to obtain an application uniformity of 100%

Answered: 1 week ago

Question

What is the most important part of any HCM Project Map and why?

Answered: 1 week ago