SNHU DAD 220 MODULE 5
COMPREHENSIVE ACTIVITY ANALYSIS
REVIEW WITH COMPLETE SOLUTIONS
●● Information
Answer: Data that has been processed to give the facts meaning
●● Three common sources of data
Answer: Social networks, business systems, internet of things
●● Database
Answer: A collection of data in a structured format that correlates related
data values. The database structure enables fast storing, retrieving,
updating, and deleting of data.
●● Database Management System (DBMS)
Answer: Commonly called a database system. A software application
used to support data organization in a database. It provides additional
functionality to secure data and ensure data is accurate.
●● Application
Answer: Software used to interact with database system to access data in
a database.
,●● Database Administrator (DBA)
Answer: Responsible for securing the database system against
unauthorized users. DBA's enforce procedures for end user access and
database system availability.
●● Database Designer
Answer: Defines a database's tables, views, constraints, and indexes. It
supports data storage, retrieval, modification, and deletion actions.
●● End User
Answer: Consumer of data in a database. End users request, update, or
use stored data to generate reports or information.
●● Data sharing
Answer: Databases allow end users to update and share data at the same
time. A text file being edited by one user may be unavailable to others
●● Data Duplication
Answer: Shared data in databases reduces data duplication. Text files are
easily shared, so multiple versions of the data may exist.
●● Data Security
, Answer: Databases ensure only certain users may edit or read stored
data, but text files lack the ability to limit who can edit or read portions
of a text file.
●● Data Interaction
Answer: Databases provide simpler methods to access and combine
stored data, which may lead to increased user productivity. Reading and
combining data from multiple text files is cumbersome and may
decrease user productivity.
●● Data Corruption
Answer: Databases ensure stored data is valid based on the database
design and can recover from file system errors. Text files may contain
invalid data or be corrupted when the file system fails.
●● Performance
Answer: How quickly data is returned from database after query.
●● Factors that affect performance
Answer: 1. Workload
2. Throughput
3. Resources
4. Query optimization
5. Data contention
COMPREHENSIVE ACTIVITY ANALYSIS
REVIEW WITH COMPLETE SOLUTIONS
●● Information
Answer: Data that has been processed to give the facts meaning
●● Three common sources of data
Answer: Social networks, business systems, internet of things
●● Database
Answer: A collection of data in a structured format that correlates related
data values. The database structure enables fast storing, retrieving,
updating, and deleting of data.
●● Database Management System (DBMS)
Answer: Commonly called a database system. A software application
used to support data organization in a database. It provides additional
functionality to secure data and ensure data is accurate.
●● Application
Answer: Software used to interact with database system to access data in
a database.
,●● Database Administrator (DBA)
Answer: Responsible for securing the database system against
unauthorized users. DBA's enforce procedures for end user access and
database system availability.
●● Database Designer
Answer: Defines a database's tables, views, constraints, and indexes. It
supports data storage, retrieval, modification, and deletion actions.
●● End User
Answer: Consumer of data in a database. End users request, update, or
use stored data to generate reports or information.
●● Data sharing
Answer: Databases allow end users to update and share data at the same
time. A text file being edited by one user may be unavailable to others
●● Data Duplication
Answer: Shared data in databases reduces data duplication. Text files are
easily shared, so multiple versions of the data may exist.
●● Data Security
, Answer: Databases ensure only certain users may edit or read stored
data, but text files lack the ability to limit who can edit or read portions
of a text file.
●● Data Interaction
Answer: Databases provide simpler methods to access and combine
stored data, which may lead to increased user productivity. Reading and
combining data from multiple text files is cumbersome and may
decrease user productivity.
●● Data Corruption
Answer: Databases ensure stored data is valid based on the database
design and can recover from file system errors. Text files may contain
invalid data or be corrupted when the file system fails.
●● Performance
Answer: How quickly data is returned from database after query.
●● Factors that affect performance
Answer: 1. Workload
2. Throughput
3. Resources
4. Query optimization
5. Data contention
