,Solution manual for MIS, 11th Edition Hossein
Bidgoli
Notes
1- The file is chapter after chapter.
2- We have shown you 10 or five pages.
3- The file contains all Appendix and Excel
sheet if it exists.
4- We have all what you need, we make
update at every time. There are many
new editions waiting you.
5- If you think you purchased the wrong file
You can contact us at every time, we can
replace it with true one.
Our email:
, Solution and Answer Guide: Bidgoli, MIS 2024,
Solution and Answer Guide
BIDGOLI, MIS 2024, 9780357883860; MINDTAP USE IT ACTIVITIES
TABLE OF CONTENTS
Module 01 – Use It.......................................................................................................................1
Module 02 – Use It.......................................................................................................................5
Module 03 – Use It.......................................................................................................................7
Module 04- Use It.......................................................................................................................10
Module 05 – Use It.....................................................................................................................14
Module 06 – Use It.....................................................................................................................18
Module 07 – Use It.....................................................................................................................21
Module 08 – Use It.....................................................................................................................25
Module 09 – Use It.....................................................................................................................29
Module 10 – Use It.....................................................................................................................33
Module 11 – Use It.....................................................................................................................37
Module 12 – Use It.....................................................................................................................42
Module 12 – Use It.....................................................................................................................45
Module 14 – Use It.....................................................................................................................50
MODULE 01 – USE IT
1. Manager:
I think we need to provide some guidance on how this works. Most people haven’t heard of a
personal fitness challenge like this before.
You:
I think we can make a video that will explain the basic idea and even show examples of people
working out on their own or with friends. We could post the video on __________.
Answer: YouTube
Explanation: YouTube is a popular video-sharing site where users can upload and share
video clips via Web sites, mobile devices, blogs, e-mails, and social media.
2. Manager:
That sounds good. We’ll have some prizes and also give awards at the run/walk for the most
proactive participants, based on the photos and reports they send in. How can we help people
stay focused on their goals?
You:
I think regular reminders will be helpful. And lots of opportunities for them to post about their
progress and get support from friends. Maybe we can use a daily thread on ___________ that
participants can reply to and report their activities.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 1
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: Facebook
Explanation: Facebook is a social networking site where users can post updates and
receive responses and likes from their friends. Businesses often use Facebook to
connect with their community, fans, and customers.
3. Manager:
It’s going to be a real challenge to keep track of all the moving pieces here.
You:
No worries. I’ll post reminders and appointments on ____________.
Answer: Google Calendar
Explanation: Google Calendar is used to coordinate events, can be shared with various
people, and can send notifications for appointments and tasks.
4. Identify which major component of an information system is being used in each scenario.
Answer:
Term Scenario
Data Gina transcribes notes from the doctor regarding a patient’s
physical examination.
Database Dr. Michaels reviews a patient’s historical test results to look for
trends.
Process Raul generates reports that will be mailed to insurance companies.
Information Dr. Baggett checks the Emergency Department’s tracking board to
determine which patient to see next.
Explanation:
- Data is the input to a system, such as notes transcribed from a patient’s physical
examination.
- A database is a collection of all relevant data organized into a series of integrated
files, such as patients’ test results collected over time.
- A process generates useful information for making decisions, such as reports
collecting relevant data on patients to send to insurance companies.
- Information is the output of an information system and consists of facts that have
been analyzed to provide useful guidance to a decision maker, such as a
prioritized list of patients on an Emergency Department’s tracking board.
5. Identify the type of information system most relevant to each scenario.
Answer:
Term Scenario
MKIS Latoya’s marketing team uses a CRM tool
to manage communications with her
company’s new customers around the
country.
FIS Cam’s financial management company
subscribes to a carefully researched
combination of databases and analyst
reports.
SMIS Reginald relies on a crowdsourced online
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 2
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
video library to research how to perform
maintenance and troubleshooting tasks
on networking equipment his company
recently installed in their data center.
HRIS Shanna helps to manage updates for her
company’s mobile time tracking app that
employees use to report their hours
worked.
Explanation:
- An MKIS (marketing information system) helps an organization grow leads,
opportunities, or revenue, such as Latoya’s CRM (customer relationship
management) tool that she uses to manage communications with new
customers.
- An FIS (financial information system) provides information to financial executives
in a timely manner to support quick financial decision-making, such as the
databases and analyst reports that Cam’s company relies on.
- An SMIS (social media information system) relies on crowdsourced information,
such as the online videos posted by users of the networking equipment Reginald
works on.
- An HRIS (human resources information system) provides information that can
help with scheduling and compensating employees, such as the mobile time
tracking app Shanna manages.
6. Which competitive force has Naomi capitalized on to benefit her company’s manufacturing
processes?
Answer: d
Explanation: Rivalry among existing competitors is high when many competitors occupy
the same market-place position and is low when there are few competitors. In a highly
competitive environment, companies are constantly looking for ways to differentiate their
services and products, or at the least, to minimize advantages of competitors’ services or
products. This is an important factor to consider when new technologies emerge that
might give a competitor an edge in the market.
7. Naomi’s company is able to implement the new dye technique before competitors discover and
implement similar techniques, thus increasing her company’s ____________.
Answer: Supplier Power
Explanation: Supplier power is high when customers have fewer options and low when
customers have more options. Organizations offer unique products with highly
desirable features to reduce the threat of competition.
8. CEO:
I like the idea of developing this app in-house. Let’s talk about who we want to assign to the team
for this project. You’ve got the HR expertise. But who should take charge of converting your ideas
into a workable design?
You:
I’m thinking Natalie can take point on this. She’s got a __________ background and helped with
this kind of thing at her prior company where she developed the initial design for some
bookkeeping software.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 3
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: systems analyst
Explanation: Systems analysts are responsible for the design and implementation of
information systems. They consult with management and users to define the scope of
and requirements for new information systems. They then convey system requirements
to people in more technical roles for implementation.
9. CEO:
Okay, that’s good. I don’t think she knows coding, though. We need a __________. Got anyone
in mind?
You:
Yes, let’s ask Miguel. He knows several coding languages and writes gaming software in his
spare time as a hobby.
Answer: computer programmer
Explanation: Computer programmers convert a program design developed by a systems
analyst into a working program written in one of many computer languages. To do this,
they must write, debug, and test the program to ensure it will operate in a way that will
meet users’ needs.
10. CEO:
I don’t think they know each other yet, but I think it’ll work. What about the user interface? We’ll
host the app on our intranet. I want to make sure it’s got a clean layout with easy navigation
through the site.
You:
Right—we can develop a web-hosted front-end for users to interact with. Zahira is our
_________. I’ll ask her to jump in as well.
Answer: webmaster
Explanation: Webmasters design and maintain Web sites, including site layout and
function, to meet the organization’s requirements. The creative side of the job includes
creating a user-friendly design, ensuring easy navigation, organizing content, and
integrating graphics and audio.
MODULE 02 – USE IT
1. Davey:
Speed is important to me for this computer. I use graphic software to create some of my designs,
and I’m always under a time crunch. How can I make sure the computer I buy will be fast?
You:
To maximize speed, you definitely want a ___________. And make sure it’s 64-bit so it will
support more RAM.
Answer: quad-core processor
Explanation: A quad-core processor contains four cores and performs better than a single or
dual core processor.
2. Davey:
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 4
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Okay, that makes sense. I’ll also have to store a lot of very large files. How can I make sure I’ve
got enough space?
You:
You’ll want at least a 1 terabyte ___________ for storage, and maybe even 2 terabytes.
Answer: disk drive
Explanation: A disk drive is a peripheral device for recording, storing, and retrieving
information.
3. Davey:
Oh, I saw some drives listed at that size, so that’s good. I’ll also need to connect a printer and a
drawing tablet. What will I need for those?
You:
Check the _______ options to make sure they’re compatible with your peripheral devices. Most of
those devices use a standard USB connection.
Answer: bus
Explanation: A bus is the link between devices connected to the computer, such as an
external bus that communicates with USB peripheral devices.
4. Identify the prefix equivalent for each measurement.
Answer:
Left Column Right Column
Kilo 1,000 bytes
Mega 1,000 kilobytes
Giga 1,000 megabytes
Tera 1,000 gigabytes
Peta 1,000 terabytes
Explanation:
- A kilobyte is 1,000 bytes.
- A megabyte is 1,000 kilobytes.
- A gigabyte is 1,000 megabytes.
- A terabyte is 1,000 gigabytes.
- A petabyte is 1,000 terabytes.
5. Identify the type of hardware needed for each scenario.
Answer:
Left Column Right Column
Input Edgardo needs to take inventory by
scanning bar codes of all appliances in
stock in his department.
Output Gretchen needs to display her
presentation to the marketing team at her
company.
Memory Susan needs to make modifications to her
laptop so it will work faster.
Storage Hussein needs to create backup copies of
his tax returns.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 5
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Explanation:
- Input devices, such as a barcode scanner, send data and information to a
computer.
- Output devices, such as a projector for presentations, are used to represent
visual, audio, or digital information from a computer.
- Memory, which plays a major role in a computer’s performance, stores data on a
computer while it’s being used.
- Storage devices, sometimes called secondary memory devices, are used for
storing large volumes of data for long periods, such as file backups.
6. Which storage type is the best solution for Lexie’s purposes?
Answer: c
Explanation: Network-attached storage (NAS) is essentially a network-connected
computer dedicated to providing file-based data storage services to other network
devices. NAS can incorporate backup solutions and remote access to data, and works
well for providing access to a relatively small number of people in a small office
environment.
7. As Lexie is setting up her new storage space, she’s given the option to configure ____________
backup.
Answer: RAID
Explanation: RAID (redundant array of independent disks) is a collection of disk drives
used for fault tolerance and improved performance. Most enterprise-grade NAS devices
include RAID capabilities for backup.
8. Lexie decided to host her web server in the cloud so it will be more easily accessible for clients.
Where is her web server physically located?
Answer: c
Explanation: Cloud storage involves multiple virtual servers that are usually hosted by
third parties at a remote data center.
9. HR:
My staff is a little nervous about having to learn how to use new computers. Can you give me
some tips on what kinds of changes to expect?
You:
Your current computers use Windows, which is the ______________. The new computers will
have an upgraded version of Windows.
Answer: operating system
Explanation: Windows is a type of operating system, which is a set of programs for controlling
and managing computer hardware and software.
10. HR Director:
That sounds easy enough. What about our database software?
You:
You’re currently using __________, and we can easily install an updated version of that same
application.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 6
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: Access
Explanation: Access is the database application in the Microsoft Office suite of
productivity tools.
11. HR Director:
Will all of this still interact well with Accounting’s __________ software?
You:
Definitely. Actually, the data syncing should flow even more smoothly than it has been.
Answer: Quickbooks
Explanation: Quickbooks is a popular accounting software package.
MODULE 03 – USE IT
1. Client:
I’m trying to understand how all this will work—how the app and the database will work together.
Where will you get the information for the database?
You:
This data is specific to your company, so it’s called ____________ data. Your customers will
enter their personal information when they create their accounts. Then sales transactions will
continue to add data about each customer over time.
Answer: internal
Explanation: Internal data is collected from within an organization’s own business
processes and can include transaction records, sales records, personnel records, and
customer-reported information.
2. Client:
That sounds like a lot of data. Won’t the database get too big to find information quickly?
You:
Good question. We can build in a(n) __________ or two to help speed up queries. It will take up a
bit more space, but will greatly increase efficiency for user interactions.
Answer: index
Explanation: An index lists an indexed value and a pointer to the disk location of the
record matching that value. An index speeds up data access in a database, and can be
designed to accelerate the most commonly used database queries.
3. Client:
I suppose “users” include customers and employees. Will they all see the same information about
each account?
You:
No, we’ll design separate ____________ for each type of user so the user gets exactly the
needed information and nothing more. This is especially important when considering customer
privacy.
Answer: logical views
Explanation: A logical view determines how information appears to users and how it can
be organized and retrieved.
4. Identify the data model used in each scenario.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 7
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer:
Left Column Right Column
Relational A database of contestants in a dog show
where each dog, owner, and competition
is identified by a primary key
Object-oriented A database used to catalog types of
architecture, geographical features, and
sociological characteristics in various
parts of the world
Hierarchical A database that stores detailed
information on the taxonomy of living
things found in a geographical area,
including the categories of kingdom,
phylum, class, order, family, genus, and
species
Network A database used to cross-reference
actors who have performed in various
movies with directors, writers, and other
support staff for those movies
Explanation:
- A relational database uses two-dimensional tables of rows (records) and columns
(fields), where each record, such as dogs, owners, and competitions in a dog
show, is uniquely identified by a primary key.
- An object-oriented database uses database objects to represent complex
information about real-world entities where there might not be much consistency
in the data from object to object, such as the variable information that might be
collected on architecture, geographical features, and sociological characteristics
of different geopolitical areas throughout the world.
- A hierarchical database shows relationships among records in a treelike structure
(hierarchy), such as the taxonomy of living things where a species is part of a
genus, which is part of a family, which is part of an order, etc.
- A network database can show multiple parent and child records for each record,
such as when an actor has appeared in multiple movies, and each movie results
from the work of multiple actors, writers, and other support staff.
5. Which tables will you need in your database for the purposes of this app? Choose two.
Answer: a, c
Explanation: While you’ll likely need several tables in the app’s database, of the possible
tables listed here, you’ll need a Transactions table and a Customers table.
6. Which of the following fields should be included in the Customers table? Choose two.
Answer: a, d
Explanation: Each field should identify a simple and complete attribute directly relevant
to that record. From these examples, Last_Name and Customer_ID meet these
requirements. The Address field is not specific enough; it should be broken into separate
fields, such as Street_Address, City, State, and Zip_Code. The Transaction_Date field
belongs in the Transactions table.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 8
website, in whole or in part.
Bidgoli
Notes
1- The file is chapter after chapter.
2- We have shown you 10 or five pages.
3- The file contains all Appendix and Excel
sheet if it exists.
4- We have all what you need, we make
update at every time. There are many
new editions waiting you.
5- If you think you purchased the wrong file
You can contact us at every time, we can
replace it with true one.
Our email:
, Solution and Answer Guide: Bidgoli, MIS 2024,
Solution and Answer Guide
BIDGOLI, MIS 2024, 9780357883860; MINDTAP USE IT ACTIVITIES
TABLE OF CONTENTS
Module 01 – Use It.......................................................................................................................1
Module 02 – Use It.......................................................................................................................5
Module 03 – Use It.......................................................................................................................7
Module 04- Use It.......................................................................................................................10
Module 05 – Use It.....................................................................................................................14
Module 06 – Use It.....................................................................................................................18
Module 07 – Use It.....................................................................................................................21
Module 08 – Use It.....................................................................................................................25
Module 09 – Use It.....................................................................................................................29
Module 10 – Use It.....................................................................................................................33
Module 11 – Use It.....................................................................................................................37
Module 12 – Use It.....................................................................................................................42
Module 12 – Use It.....................................................................................................................45
Module 14 – Use It.....................................................................................................................50
MODULE 01 – USE IT
1. Manager:
I think we need to provide some guidance on how this works. Most people haven’t heard of a
personal fitness challenge like this before.
You:
I think we can make a video that will explain the basic idea and even show examples of people
working out on their own or with friends. We could post the video on __________.
Answer: YouTube
Explanation: YouTube is a popular video-sharing site where users can upload and share
video clips via Web sites, mobile devices, blogs, e-mails, and social media.
2. Manager:
That sounds good. We’ll have some prizes and also give awards at the run/walk for the most
proactive participants, based on the photos and reports they send in. How can we help people
stay focused on their goals?
You:
I think regular reminders will be helpful. And lots of opportunities for them to post about their
progress and get support from friends. Maybe we can use a daily thread on ___________ that
participants can reply to and report their activities.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 1
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: Facebook
Explanation: Facebook is a social networking site where users can post updates and
receive responses and likes from their friends. Businesses often use Facebook to
connect with their community, fans, and customers.
3. Manager:
It’s going to be a real challenge to keep track of all the moving pieces here.
You:
No worries. I’ll post reminders and appointments on ____________.
Answer: Google Calendar
Explanation: Google Calendar is used to coordinate events, can be shared with various
people, and can send notifications for appointments and tasks.
4. Identify which major component of an information system is being used in each scenario.
Answer:
Term Scenario
Data Gina transcribes notes from the doctor regarding a patient’s
physical examination.
Database Dr. Michaels reviews a patient’s historical test results to look for
trends.
Process Raul generates reports that will be mailed to insurance companies.
Information Dr. Baggett checks the Emergency Department’s tracking board to
determine which patient to see next.
Explanation:
- Data is the input to a system, such as notes transcribed from a patient’s physical
examination.
- A database is a collection of all relevant data organized into a series of integrated
files, such as patients’ test results collected over time.
- A process generates useful information for making decisions, such as reports
collecting relevant data on patients to send to insurance companies.
- Information is the output of an information system and consists of facts that have
been analyzed to provide useful guidance to a decision maker, such as a
prioritized list of patients on an Emergency Department’s tracking board.
5. Identify the type of information system most relevant to each scenario.
Answer:
Term Scenario
MKIS Latoya’s marketing team uses a CRM tool
to manage communications with her
company’s new customers around the
country.
FIS Cam’s financial management company
subscribes to a carefully researched
combination of databases and analyst
reports.
SMIS Reginald relies on a crowdsourced online
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 2
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
video library to research how to perform
maintenance and troubleshooting tasks
on networking equipment his company
recently installed in their data center.
HRIS Shanna helps to manage updates for her
company’s mobile time tracking app that
employees use to report their hours
worked.
Explanation:
- An MKIS (marketing information system) helps an organization grow leads,
opportunities, or revenue, such as Latoya’s CRM (customer relationship
management) tool that she uses to manage communications with new
customers.
- An FIS (financial information system) provides information to financial executives
in a timely manner to support quick financial decision-making, such as the
databases and analyst reports that Cam’s company relies on.
- An SMIS (social media information system) relies on crowdsourced information,
such as the online videos posted by users of the networking equipment Reginald
works on.
- An HRIS (human resources information system) provides information that can
help with scheduling and compensating employees, such as the mobile time
tracking app Shanna manages.
6. Which competitive force has Naomi capitalized on to benefit her company’s manufacturing
processes?
Answer: d
Explanation: Rivalry among existing competitors is high when many competitors occupy
the same market-place position and is low when there are few competitors. In a highly
competitive environment, companies are constantly looking for ways to differentiate their
services and products, or at the least, to minimize advantages of competitors’ services or
products. This is an important factor to consider when new technologies emerge that
might give a competitor an edge in the market.
7. Naomi’s company is able to implement the new dye technique before competitors discover and
implement similar techniques, thus increasing her company’s ____________.
Answer: Supplier Power
Explanation: Supplier power is high when customers have fewer options and low when
customers have more options. Organizations offer unique products with highly
desirable features to reduce the threat of competition.
8. CEO:
I like the idea of developing this app in-house. Let’s talk about who we want to assign to the team
for this project. You’ve got the HR expertise. But who should take charge of converting your ideas
into a workable design?
You:
I’m thinking Natalie can take point on this. She’s got a __________ background and helped with
this kind of thing at her prior company where she developed the initial design for some
bookkeeping software.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 3
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: systems analyst
Explanation: Systems analysts are responsible for the design and implementation of
information systems. They consult with management and users to define the scope of
and requirements for new information systems. They then convey system requirements
to people in more technical roles for implementation.
9. CEO:
Okay, that’s good. I don’t think she knows coding, though. We need a __________. Got anyone
in mind?
You:
Yes, let’s ask Miguel. He knows several coding languages and writes gaming software in his
spare time as a hobby.
Answer: computer programmer
Explanation: Computer programmers convert a program design developed by a systems
analyst into a working program written in one of many computer languages. To do this,
they must write, debug, and test the program to ensure it will operate in a way that will
meet users’ needs.
10. CEO:
I don’t think they know each other yet, but I think it’ll work. What about the user interface? We’ll
host the app on our intranet. I want to make sure it’s got a clean layout with easy navigation
through the site.
You:
Right—we can develop a web-hosted front-end for users to interact with. Zahira is our
_________. I’ll ask her to jump in as well.
Answer: webmaster
Explanation: Webmasters design and maintain Web sites, including site layout and
function, to meet the organization’s requirements. The creative side of the job includes
creating a user-friendly design, ensuring easy navigation, organizing content, and
integrating graphics and audio.
MODULE 02 – USE IT
1. Davey:
Speed is important to me for this computer. I use graphic software to create some of my designs,
and I’m always under a time crunch. How can I make sure the computer I buy will be fast?
You:
To maximize speed, you definitely want a ___________. And make sure it’s 64-bit so it will
support more RAM.
Answer: quad-core processor
Explanation: A quad-core processor contains four cores and performs better than a single or
dual core processor.
2. Davey:
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 4
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Okay, that makes sense. I’ll also have to store a lot of very large files. How can I make sure I’ve
got enough space?
You:
You’ll want at least a 1 terabyte ___________ for storage, and maybe even 2 terabytes.
Answer: disk drive
Explanation: A disk drive is a peripheral device for recording, storing, and retrieving
information.
3. Davey:
Oh, I saw some drives listed at that size, so that’s good. I’ll also need to connect a printer and a
drawing tablet. What will I need for those?
You:
Check the _______ options to make sure they’re compatible with your peripheral devices. Most of
those devices use a standard USB connection.
Answer: bus
Explanation: A bus is the link between devices connected to the computer, such as an
external bus that communicates with USB peripheral devices.
4. Identify the prefix equivalent for each measurement.
Answer:
Left Column Right Column
Kilo 1,000 bytes
Mega 1,000 kilobytes
Giga 1,000 megabytes
Tera 1,000 gigabytes
Peta 1,000 terabytes
Explanation:
- A kilobyte is 1,000 bytes.
- A megabyte is 1,000 kilobytes.
- A gigabyte is 1,000 megabytes.
- A terabyte is 1,000 gigabytes.
- A petabyte is 1,000 terabytes.
5. Identify the type of hardware needed for each scenario.
Answer:
Left Column Right Column
Input Edgardo needs to take inventory by
scanning bar codes of all appliances in
stock in his department.
Output Gretchen needs to display her
presentation to the marketing team at her
company.
Memory Susan needs to make modifications to her
laptop so it will work faster.
Storage Hussein needs to create backup copies of
his tax returns.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 5
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Explanation:
- Input devices, such as a barcode scanner, send data and information to a
computer.
- Output devices, such as a projector for presentations, are used to represent
visual, audio, or digital information from a computer.
- Memory, which plays a major role in a computer’s performance, stores data on a
computer while it’s being used.
- Storage devices, sometimes called secondary memory devices, are used for
storing large volumes of data for long periods, such as file backups.
6. Which storage type is the best solution for Lexie’s purposes?
Answer: c
Explanation: Network-attached storage (NAS) is essentially a network-connected
computer dedicated to providing file-based data storage services to other network
devices. NAS can incorporate backup solutions and remote access to data, and works
well for providing access to a relatively small number of people in a small office
environment.
7. As Lexie is setting up her new storage space, she’s given the option to configure ____________
backup.
Answer: RAID
Explanation: RAID (redundant array of independent disks) is a collection of disk drives
used for fault tolerance and improved performance. Most enterprise-grade NAS devices
include RAID capabilities for backup.
8. Lexie decided to host her web server in the cloud so it will be more easily accessible for clients.
Where is her web server physically located?
Answer: c
Explanation: Cloud storage involves multiple virtual servers that are usually hosted by
third parties at a remote data center.
9. HR:
My staff is a little nervous about having to learn how to use new computers. Can you give me
some tips on what kinds of changes to expect?
You:
Your current computers use Windows, which is the ______________. The new computers will
have an upgraded version of Windows.
Answer: operating system
Explanation: Windows is a type of operating system, which is a set of programs for controlling
and managing computer hardware and software.
10. HR Director:
That sounds easy enough. What about our database software?
You:
You’re currently using __________, and we can easily install an updated version of that same
application.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 6
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer: Access
Explanation: Access is the database application in the Microsoft Office suite of
productivity tools.
11. HR Director:
Will all of this still interact well with Accounting’s __________ software?
You:
Definitely. Actually, the data syncing should flow even more smoothly than it has been.
Answer: Quickbooks
Explanation: Quickbooks is a popular accounting software package.
MODULE 03 – USE IT
1. Client:
I’m trying to understand how all this will work—how the app and the database will work together.
Where will you get the information for the database?
You:
This data is specific to your company, so it’s called ____________ data. Your customers will
enter their personal information when they create their accounts. Then sales transactions will
continue to add data about each customer over time.
Answer: internal
Explanation: Internal data is collected from within an organization’s own business
processes and can include transaction records, sales records, personnel records, and
customer-reported information.
2. Client:
That sounds like a lot of data. Won’t the database get too big to find information quickly?
You:
Good question. We can build in a(n) __________ or two to help speed up queries. It will take up a
bit more space, but will greatly increase efficiency for user interactions.
Answer: index
Explanation: An index lists an indexed value and a pointer to the disk location of the
record matching that value. An index speeds up data access in a database, and can be
designed to accelerate the most commonly used database queries.
3. Client:
I suppose “users” include customers and employees. Will they all see the same information about
each account?
You:
No, we’ll design separate ____________ for each type of user so the user gets exactly the
needed information and nothing more. This is especially important when considering customer
privacy.
Answer: logical views
Explanation: A logical view determines how information appears to users and how it can
be organized and retrieved.
4. Identify the data model used in each scenario.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 7
website, in whole or in part.
, Solution and Answer Guide: Bidgoli, MIS 2024,
Answer:
Left Column Right Column
Relational A database of contestants in a dog show
where each dog, owner, and competition
is identified by a primary key
Object-oriented A database used to catalog types of
architecture, geographical features, and
sociological characteristics in various
parts of the world
Hierarchical A database that stores detailed
information on the taxonomy of living
things found in a geographical area,
including the categories of kingdom,
phylum, class, order, family, genus, and
species
Network A database used to cross-reference
actors who have performed in various
movies with directors, writers, and other
support staff for those movies
Explanation:
- A relational database uses two-dimensional tables of rows (records) and columns
(fields), where each record, such as dogs, owners, and competitions in a dog
show, is uniquely identified by a primary key.
- An object-oriented database uses database objects to represent complex
information about real-world entities where there might not be much consistency
in the data from object to object, such as the variable information that might be
collected on architecture, geographical features, and sociological characteristics
of different geopolitical areas throughout the world.
- A hierarchical database shows relationships among records in a treelike structure
(hierarchy), such as the taxonomy of living things where a species is part of a
genus, which is part of a family, which is part of an order, etc.
- A network database can show multiple parent and child records for each record,
such as when an actor has appeared in multiple movies, and each movie results
from the work of multiple actors, writers, and other support staff.
5. Which tables will you need in your database for the purposes of this app? Choose two.
Answer: a, c
Explanation: While you’ll likely need several tables in the app’s database, of the possible
tables listed here, you’ll need a Transactions table and a Customers table.
6. Which of the following fields should be included in the Customers table? Choose two.
Answer: a, d
Explanation: Each field should identify a simple and complete attribute directly relevant
to that record. From these examples, Last_Name and Customer_ID meet these
requirements. The Address field is not specific enough; it should be broken into separate
fields, such as Street_Address, City, State, and Zip_Code. The Transaction_Date field
belongs in the Transactions table.
© 2024 Cengage. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible 8
website, in whole or in part.
