ISDS 3003 MIDTERM CH 1-5 QUESTIONS & ANSWERS
1. Data- Answer - numeric, textual, visual, or audio information that describes real-world systems
2. Analog- Answer - Historically, data was mostly, analog, encoded as continuous variations on various physical media
3. Database- Answer - A collection of data in a structured format. In principle, they can be stored on paper or
even clay tablets. In practice, this modern tool is mainly stored on a computer
4. Database system/ database management system. DBMS- Answer - a database
system, aka DBMS, is software that reads and writes data in a database. It ensures that data is secure,
internally consistent,
and always available. These functions are challenging for large databases with many users, so database systems are
complex.
5. query- Answer - is a request to retrieve or change data in a database
6. query language- Answer - a specialized programming language, designed specifically for database systems
7. database application- Answer - a database application is software that helps business users interact with
database system
8. Database administrator- Answer - responsible for securing the database system against unauthorized
availability
9. Database designer- Answer - determines the format of each data element and the overall database
structure. They must balance several priorities, including storage, response time, and support for rules that govern
the data. Since these priorities often conflict, database design is technically challenging.
10. Database programmer- Answer - develops computer programs that utilize a database
11. Database user- Answer - A consumer of data in a database. Database users request, update, or use
stored data to generate reports or information. Database users usually access the database via applications but can
also submit queries directly to the database system
12. Where would a bank customer's account data be directly stored?- Answer -
In the Bank database
1/6
, 13. Which manages the Bank database- Answer - the banking database system
14. Which would prevent unauthorized access to the Bank database- Answer
- the bank database system
15. How would a bank customer access their bank data?- Answer - through the customer
banking application
16. Database roles- Answer - 1. The database designer establishes the structure of the database and
determines the data to be collected and stored.
2. The database administrator ensures the database is available and secure.
3. A database programmer uses query languages and programming languages to develop applications for database
2/6
1. Data- Answer - numeric, textual, visual, or audio information that describes real-world systems
2. Analog- Answer - Historically, data was mostly, analog, encoded as continuous variations on various physical media
3. Database- Answer - A collection of data in a structured format. In principle, they can be stored on paper or
even clay tablets. In practice, this modern tool is mainly stored on a computer
4. Database system/ database management system. DBMS- Answer - a database
system, aka DBMS, is software that reads and writes data in a database. It ensures that data is secure,
internally consistent,
and always available. These functions are challenging for large databases with many users, so database systems are
complex.
5. query- Answer - is a request to retrieve or change data in a database
6. query language- Answer - a specialized programming language, designed specifically for database systems
7. database application- Answer - a database application is software that helps business users interact with
database system
8. Database administrator- Answer - responsible for securing the database system against unauthorized
availability
9. Database designer- Answer - determines the format of each data element and the overall database
structure. They must balance several priorities, including storage, response time, and support for rules that govern
the data. Since these priorities often conflict, database design is technically challenging.
10. Database programmer- Answer - develops computer programs that utilize a database
11. Database user- Answer - A consumer of data in a database. Database users request, update, or use
stored data to generate reports or information. Database users usually access the database via applications but can
also submit queries directly to the database system
12. Where would a bank customer's account data be directly stored?- Answer -
In the Bank database
1/6
, 13. Which manages the Bank database- Answer - the banking database system
14. Which would prevent unauthorized access to the Bank database- Answer
- the bank database system
15. How would a bank customer access their bank data?- Answer - through the customer
banking application
16. Database roles- Answer - 1. The database designer establishes the structure of the database and
determines the data to be collected and stored.
2. The database administrator ensures the database is available and secure.
3. A database programmer uses query languages and programming languages to develop applications for database
2/6
