Question: 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  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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!