CS6400-Exam1 Exam fully solved & updated 2025-2026(latest version
verified for accuracy)| 2024\2025 Latest!!
1. DBMS (Data- is a computerized system that enables users to create and maintain a database
base Manage-
ment System)
2. Meta Data The database definition or descriptive information is also stored by the DBMS in
the form of a database catalog or dictionary
3. transaction an executing program or process that includes one or more database accesses,
such as reading or updating of database records
4. requirements The first phase in the design of the new application for an existing database or
specification and design of a brand-new database
analysis
5. Conceptual De- Overview of the system, does not include hardware or software choices
sign
6. Logical Design A stage in the design phase that matches the conceptual design to the require-
ments of the selected DBMS and is therefore software-dependent. It is used to
translate the conceptual design into the internal model for a selected database
management system.
7. Physical Design translates the logical design into physical components. The database design is
implemented, populated with actual data, and continuously maintained to reflect
the state of the miniworld.
8. self-describing includes the data item names and data values together in one structure
data
9. Data Modeling Defining a database so that it faithfully represents all key components of an
organization's environment. The objective is to explicitly capture and store data
about every business activity the organization wishes to plan, control, or evaluate.
, CS6400-Exam1 Exam fully solved & updated 2025-2026(latest version
verified for accuracy)| 2024\2025 Latest!!
10. operation (also called a function or method)
-The interface (or signature)
-The implementation
11. program-opera- User application programs can operate on the data by invoking these operations
tion through their names and arguments, regardless of how the operations are im-
independence plemented
12. Data Abstraction allows program-data independence and program-operation independence
13. view subset of the database or it may contain virtual data that is derived from the
database files but is not explicitly stored.
14. Concurrency A method of dealing with a situation in which two or more users or applications
Control need to access the same record at the same time.
15. OLTP (online Database design used for browsing and manipulating business transaction activ-
transaction pro- ity
cessing)
16. Isolation ensures that each transaction appears to execute in isolation from other transac-
tions, even though hundreds of transactions may be executing concurrently
17. atomicity ensures that either all the database operations in a transaction are executed or
none are
18. Database Admin- the person responsible for coordinating, controlling, and managing the database
istrator (DBA)
19. Database design- are responsible for identifying the data to be stored in the database and for
ers choosing appropriate structures to represent and store this data
20. End users
, CS6400-Exam1 Exam fully solved & updated 2025-2026(latest version
verified for accuracy)| 2024\2025 Latest!!
are the people whose jobs require access to the database for querying, updating,
and generating reports; the database primarily exists for their use.
21. Parametric End Their main job function revolves around constantly querying and updating the
Users database, using standard types of queries and updates
22. Sophisticated include engineers, scientists, business analysts, and others who thoroughly famil-
end users iarize themselves with the facilities of the DBMS in order to implement their own
applications to meet their complex requirements.
23. Standalone users maintain personal databases by using ready-made program packages that pro-
vide easy-to-use menu-based or graphics-based interfaces. An example is the
user of a financial software package that stores a variety of personal financial data.
24. Casual end users occasionally access the database, but they may need different information each
time.
25. System analysts determine the requirements of end users, especially naive and parametric end
users, and develop specifications for standard canned transactions that meet
these requirements.
26. Application pro- implement these specifications as programs; then they test, debug, document,
grammers and maintain these canned transactions.
27. redundancy storing the same data multiple times
28. data normaliza- database design that stores each logical data item—such as a student's name or
tion birth date—in only one place in the database.
29. Controlled Re- maintains replicas or exact copies.
dundancy
30. Denormalization
verified for accuracy)| 2024\2025 Latest!!
1. DBMS (Data- is a computerized system that enables users to create and maintain a database
base Manage-
ment System)
2. Meta Data The database definition or descriptive information is also stored by the DBMS in
the form of a database catalog or dictionary
3. transaction an executing program or process that includes one or more database accesses,
such as reading or updating of database records
4. requirements The first phase in the design of the new application for an existing database or
specification and design of a brand-new database
analysis
5. Conceptual De- Overview of the system, does not include hardware or software choices
sign
6. Logical Design A stage in the design phase that matches the conceptual design to the require-
ments of the selected DBMS and is therefore software-dependent. It is used to
translate the conceptual design into the internal model for a selected database
management system.
7. Physical Design translates the logical design into physical components. The database design is
implemented, populated with actual data, and continuously maintained to reflect
the state of the miniworld.
8. self-describing includes the data item names and data values together in one structure
data
9. Data Modeling Defining a database so that it faithfully represents all key components of an
organization's environment. The objective is to explicitly capture and store data
about every business activity the organization wishes to plan, control, or evaluate.
, CS6400-Exam1 Exam fully solved & updated 2025-2026(latest version
verified for accuracy)| 2024\2025 Latest!!
10. operation (also called a function or method)
-The interface (or signature)
-The implementation
11. program-opera- User application programs can operate on the data by invoking these operations
tion through their names and arguments, regardless of how the operations are im-
independence plemented
12. Data Abstraction allows program-data independence and program-operation independence
13. view subset of the database or it may contain virtual data that is derived from the
database files but is not explicitly stored.
14. Concurrency A method of dealing with a situation in which two or more users or applications
Control need to access the same record at the same time.
15. OLTP (online Database design used for browsing and manipulating business transaction activ-
transaction pro- ity
cessing)
16. Isolation ensures that each transaction appears to execute in isolation from other transac-
tions, even though hundreds of transactions may be executing concurrently
17. atomicity ensures that either all the database operations in a transaction are executed or
none are
18. Database Admin- the person responsible for coordinating, controlling, and managing the database
istrator (DBA)
19. Database design- are responsible for identifying the data to be stored in the database and for
ers choosing appropriate structures to represent and store this data
20. End users
, CS6400-Exam1 Exam fully solved & updated 2025-2026(latest version
verified for accuracy)| 2024\2025 Latest!!
are the people whose jobs require access to the database for querying, updating,
and generating reports; the database primarily exists for their use.
21. Parametric End Their main job function revolves around constantly querying and updating the
Users database, using standard types of queries and updates
22. Sophisticated include engineers, scientists, business analysts, and others who thoroughly famil-
end users iarize themselves with the facilities of the DBMS in order to implement their own
applications to meet their complex requirements.
23. Standalone users maintain personal databases by using ready-made program packages that pro-
vide easy-to-use menu-based or graphics-based interfaces. An example is the
user of a financial software package that stores a variety of personal financial data.
24. Casual end users occasionally access the database, but they may need different information each
time.
25. System analysts determine the requirements of end users, especially naive and parametric end
users, and develop specifications for standard canned transactions that meet
these requirements.
26. Application pro- implement these specifications as programs; then they test, debug, document,
grammers and maintain these canned transactions.
27. redundancy storing the same data multiple times
28. data normaliza- database design that stores each logical data item—such as a student's name or
tion birth date—in only one place in the database.
29. Controlled Re- maintains replicas or exact copies.
dundancy
30. Denormalization
