Chattahoochee Technical College

CIST 1001

DISCOVERING COMPUTERS: TECHNOLOGY IN A WORLD OF COMPUTERS, MOBILE DEVICES, AND THE

INTERNET

CHAPTER ELEVEN: INFORMATION AND DATA MANAGEMENT END OF CHAPTER SOLUTIONS

STUDY GUIDE

1)Define these terms: database, data, and database software.

2. Explain the importance of data integrity. GIGO stands for                         .

3. List steps that you should take if you experience identity theft.

3. Identify characteristics of data that contribute to its value.

5. Identify the role of a file, record, and field in the hierarchy of data in a database.

6. In the ASCII coding scheme, each byte represents a single      .

7. Define these terms: field, field name, and data type. List common data types.

8. Identify what is stored in a record. Explain the importance of a primary key.

9. Define the term, data file. Identify what is involved in file maintenance.

10. Explain the issues surrounding function creep.

11. Explain how a user might add a record to a database or modify a record.

12. Explain how a DBMS might manage deleted records.

13. Define the term, validation. Explain the role of a validity check.

14. List types of validity checks and explain what occurs in each.

15. Explain the disadvantages of typical file processing systems.

16. Describe the database approach to storing data. Differentiate between a front-end and back-end program.

17. [EB] Explain the innovations of forensic databases.

18. Identify the uses of data and databases in the 1000 Genomes Project.

19. Explain how the database approach affects data integrity.

20. Explain the issues surrounding sharing of criminal databases.

21. Explain how access privileges contribute to data security. Identify differences between the security policies for a database administrator and a typical user.

22. List methods to restore a database. Differentiate between rollforward and rollback recovery.

23. List methods to back up a database. Explain why a business might choose continuous backup.

24. A(n)                    defines how users view the organization of the data. List three popular data models.

25. Define the term, relational database.

26. [EB] Identify the contributions of Larry Ellison and E.F. Codd with respect to databases.

27. Define the term, object-oriented database.

28. Describe how multidimensional databases store data.

29. Define the following terms: data warehouse, distributed database, data mining, and data mart.

30. Explain how you access data in a web database.

31. Identify steps to use a research database.

32. Explain what is meant by the term, Big Data.

33. Describe the roles of the database analyst and the database administrator.

34. List guidelines for maintaining a database.

35. Explain issues surrounding accidental access of confidential data.

36. Identify how to determine the organization and structure of a database.

37. Define the term, information system. List examples of information systems that support activities of several functional units.

38. Explain whether a company is responsible for protecting customer data.

39. Explain the role of a content management system.

40. List activities associated with a transaction processing system.

41. Define the terms: management information system, decision support system, expert system, and artificial intelligence.

42. Explain how the sports industry uses technology.