Module 10 Study Questions
Technology in Action (6th Ed.)
Pages 472 to 485 & Pages 530 to 565
Be able to define the following key terms:
Artificial Intelligence
Click-stream data
Data integrity
Database
Database administrator
Database query
Expert system
Export
Foreign key
Information systems
Primary key
Real-time processing
Referential integrity
Relational database
SQL (structured query language)
Validation
After reading the Careers in IT section on pages 472 to 485, which IT job is the most interesting to you? Include a brief explanation of why this job appeals to you and perform an Internet search to find the salary you could expect to be paid. Cite the Internet source you used to find this salary using either the MLA or APA styles shown on page 124.
NOTE: Another name computer people use for a list is flat file.
Identify two problems associated with maintaining data as multiple lists.
What are three advantages and three disadvantages associated with databases?
What are the three main components of a database?
Identify and describe seven common data types that can be assigned to a field.
What are the four main operations of a database management system (DBMS)?
NOTE: Many software applications can import data created by other applications. The means the data is formatting so it can be easily incorporated in files used and saved by the receiving software application.
Identify two ways data can be entered into a new database.
Briefly describe five types of validation checks that can be performed on database data and be able to give examples of each type of check.
What are the four functions that every information system performs?
Identify and describe five categories of information systems.
What did you find interesting in this week’s reading that was not part of a study guide question?