Database Processing Fundamentals, Design, and Implementation, 14th e BY David M. Kroenke
Email: richard@qwconsultancy.com
Database Processing, 14e (Kroenke) Chapter 1: Introduction 1) The purpose of a database is to help people keep track of things. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 2) In a database, each table stores data about a different type of thing. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 3) Like a database table, a spreadsheet has rows and columns. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept 4) In every database, not just the databases discussed in this book, table names are capitalized. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the nature and characteristics of databases Classification: Concept 5) A database shows data in tables and the relationships among the rows in those tables. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To gain a general understanding of tables and relationships Classification: Concept 6) Data is recorded facts and figures; information is knowledge derived from data. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept
1 ..
7) Databases record data in such a way that they can produce information. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 8) Enterprise Resource Planning (ERP) is an example of a data mining application. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept 9) Databases are a key component of e-commerce order entry, billing, shipping and customer support. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To survey some important and interesting database applications Classification: Concept 10) The largest databases in e-commerce are the order entry databases. Answer: FALSE AACSB: Information Technology Difficulty: Difficult LO: To survey some important and interesting database applications Classification: Concept 11) The e-commerce companies use Web activity databases to determine which items on a Web page are popular and successful. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To understand the importance of databases in Internet Web applications and smartphone apps Classification: Concept 12) Small databases typically have simple structures. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To gain a general understanding of tables and relationships Classification: Concept
2 ..
13) A database system is typically defined as its four components: users, database applications, the DBMS and the databases. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 14) Databases based on the CODASYL standard are based on the network data model. Answer: TRUE AACSB: Information Technology Difficulty: Moderate LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 15) Applications are computer programs used directly by users. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 16) Applications usually write data directly to the database. Answer: FALSE AACSB: Information Technology Difficulty: Easy LO: To understand the nature and characteristics of databases Classification: Concept 17) Sequenced Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. Answer: FALSE AACSB: Information Technology Difficulty: Moderate LO: To understand the history and development of database processing Classification: Concept 18) In database systems, indexes are held in the database. Answer: TRUE AACSB: Information Technology Difficulty: Difficult LO: To define the term database and describe what is contained within the database Classification: Concept
3 ..
19) A database management system (DBMS) creates, processes and administers databases. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 20) The database management system (DBMS) is responsible for inserting, modifying, reading, and deleting data. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 21) The database application is responsible for concurrency control. Answer: FALSE AACSB: Information Technology Difficulty: Difficult LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 22) The database management system (DBMS) is responsible for enforcing referential integrity constraints. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database management system (DBMS) and describe the functions of a DBMS Classification: Concept 23) Referential integrity constraints are rules about what data values are allowed in certain columns. Answer: TRUE AACSB: Information Technology Difficulty: Easy LO: To define the term database and describe what is contained within the database Classification: Concept
4 ..