K201 Lecture Exam 1 (Multiple Choice
Questions) And All Correct Answers
2026.
In the five-component framework of an information system, which is the most important? -
Answer People
Each Information System is comprised of five components. Match the component with the
order in which it appears in the Five-Component Model. - Answer 1-Hardware
2-Software
3-Data
4-Procedures
5-People
True/False: The number of components in the Five Component Model increases in proportion to
an Information System's complexity and/or size. - Answer False
If it is on a piece of paper or on a digital screen it is________ if it is in the mind of a human it is
__________ - Answer Data and Information
True/False In order for data to be considered timely it must be delivered in real time. - Answer
False
True/False Good data are always worth the cost, no matter how expensive. - Answer False
Keeping track of data involving multiple themes such as employees, transactions, customers,
supplies, etc. should be done with...? (Spreadsheet, relational database or a flat file system) -
Answer Relational database
The data displayed in Design View of a table in an Access database is an example of ______ -
Answer Metadata
True/False A database is simply a group of tables or files. - Answer False
, Tables-File
Records-Row
How many primary functions does a database management system (DBMS) have? - Answer
3 primary functions (to create the database and its structures, to process the database, and to
administer the database)
Which of the following is an international standard language for processing a database?
(Paradox, DB2, MS Access, or SQL) - Answer SQL
True/False The lost-update problem can be resolved by implementing multi-user database
processing. - Answer False (actually caused by multi-user database processing. Some type of
locking must be used to coordinate activities among the multiple users)
True/False Microsoft Access is a database - Answer False
A ___________ makes databases more useful for obtaining information. - Answer database
application
A ________ describes the data and relationships that will be stored in a database. - Answer
data model
Which of the following relationship types is described in the attached image?
->------<- (three prong to three prong) - Answer Many-to-many
True/False A table containing normalized data should have 3 or fewer themes - Answer False
(A normalized table should contain data with one and only one theme)
True/False N:M relationships should be represented in a data model the same way a 1:N
relationship is represented. - Answer False
Which of the following should be responsible for signing off on the data model before a
database is developed? (end users, project manager, CEO, development team) - Answer end
users
Questions) And All Correct Answers
2026.
In the five-component framework of an information system, which is the most important? -
Answer People
Each Information System is comprised of five components. Match the component with the
order in which it appears in the Five-Component Model. - Answer 1-Hardware
2-Software
3-Data
4-Procedures
5-People
True/False: The number of components in the Five Component Model increases in proportion to
an Information System's complexity and/or size. - Answer False
If it is on a piece of paper or on a digital screen it is________ if it is in the mind of a human it is
__________ - Answer Data and Information
True/False In order for data to be considered timely it must be delivered in real time. - Answer
False
True/False Good data are always worth the cost, no matter how expensive. - Answer False
Keeping track of data involving multiple themes such as employees, transactions, customers,
supplies, etc. should be done with...? (Spreadsheet, relational database or a flat file system) -
Answer Relational database
The data displayed in Design View of a table in an Access database is an example of ______ -
Answer Metadata
True/False A database is simply a group of tables or files. - Answer False
, Tables-File
Records-Row
How many primary functions does a database management system (DBMS) have? - Answer
3 primary functions (to create the database and its structures, to process the database, and to
administer the database)
Which of the following is an international standard language for processing a database?
(Paradox, DB2, MS Access, or SQL) - Answer SQL
True/False The lost-update problem can be resolved by implementing multi-user database
processing. - Answer False (actually caused by multi-user database processing. Some type of
locking must be used to coordinate activities among the multiple users)
True/False Microsoft Access is a database - Answer False
A ___________ makes databases more useful for obtaining information. - Answer database
application
A ________ describes the data and relationships that will be stored in a database. - Answer
data model
Which of the following relationship types is described in the attached image?
->------<- (three prong to three prong) - Answer Many-to-many
True/False A table containing normalized data should have 3 or fewer themes - Answer False
(A normalized table should contain data with one and only one theme)
True/False N:M relationships should be represented in a data model the same way a 1:N
relationship is represented. - Answer False
Which of the following should be responsible for signing off on the data model before a
database is developed? (end users, project manager, CEO, development team) - Answer end
users
