CS6400 Database Study Set Questions and
Answers Verified 100% Correct
Integrity constraints - ✔✔limitations on what data can exist in the database
Data type integrity constraint - ✔✔specifies which data types are allowable for a
particular data element
Referential integrity constraint - ✔✔specifies that a record in one file must be related
to records in other files
Uniqueness constraint - ✔✔aka key constraint: specifies uniqueness on data item values
Business rule constraints - ✔✔constraints that are checked by update programs or at
the time of data entry
Inherent rules - ✔✔rules that pertain to a specific data model implicitly
Deductive database systems - ✔✔provide capabilities for defining deduction rules
for inferencing new information from the stored database facts
Deductive rule - ✔✔complex rules in the miniworld application
Trigger - ✔✔a form of a rule activated by updates to the table, which results in
performing some additional operations to some other tables, sending messages, and so on
Stored procedures - ✔✔More involved procedures to enforce rules; they become a part of
the overall database definition and are invoked appropriately when certain conditions are
met.
,Active database system - ✔✔provide active rules that can automatically initiate
actions when certain events and conditions occur
Data mining application - ✔✔analyze large amounts of data to search for the occurrences
of specific patterns or relationships, and for identifying unusual patterns in areas such as credit
card fraud detection
Spatial application - ✔✔store and analyze spatial locations of data, such as weather
information, maps used in geographical information systems, and automobile
navigational systems
Time series application - ✔✔store information such as economic data at regular points
in time, such as daily sales and monthly gross national product figures
Cloud computing - ✔✔Consist of thousands of large servers managing so-called big data
for users on the Web
Client module - ✔✔In a basic client/server DBMS architecture, handles user interaction and
provides the user-friendly interfaces such as apps for mobile devices, or forms- or menu-
based GUIs (graphical user interfaces) for PCs
Server module - ✔✔In a basic client/server DBMS architecture, typically handles
data storage, access, search, and other functions
Basic data model operations - ✔✔Generic operations to insert, delete, modify, or
retrieve any kind of object
Dynamic aspect/behavior - ✔✔Allows the database designer to specify a set of valid
user-defined operations that are allowed on the database objects
, Conceptual data model - ✔✔Provide concepts that are close to the way many users
perceive data
Low-level/physical data model - ✔✔Provide concepts that describe
the details of how data is stored on the computer storage media, typically magnetic
disks. Concepts provided by physical data models are generally meant for computer
specialists, not for end users
Representational
(or implementation) data models - ✔✔Provide concepts that may be easily
understood by end users but that are not too far removed from the way data is organized in
computer storage
Entity - ✔✔represents a real-world object or concept, such as an employee or a project
from the miniworld that is described in the database. Has an independence existence.
Represented as a single-border rectangle.
Attribute - ✔✔Represents some particular property of interest that further describes
an entity, such as the employee's name or salary. Represented as a single-border oval.
Relationship - ✔✔An association among two or more entities; for example, a works-on
relationship between an employee and a project. Represented as a single-border diamond.
Entity-relationship model - ✔✔A popular high-level conceptual data model
Relational data model - ✔✔the main data model used in many current commencial DBMSs
Network model - ✔✔represents data as record types and also represents a limited type
of 1:N relationship
Answers Verified 100% Correct
Integrity constraints - ✔✔limitations on what data can exist in the database
Data type integrity constraint - ✔✔specifies which data types are allowable for a
particular data element
Referential integrity constraint - ✔✔specifies that a record in one file must be related
to records in other files
Uniqueness constraint - ✔✔aka key constraint: specifies uniqueness on data item values
Business rule constraints - ✔✔constraints that are checked by update programs or at
the time of data entry
Inherent rules - ✔✔rules that pertain to a specific data model implicitly
Deductive database systems - ✔✔provide capabilities for defining deduction rules
for inferencing new information from the stored database facts
Deductive rule - ✔✔complex rules in the miniworld application
Trigger - ✔✔a form of a rule activated by updates to the table, which results in
performing some additional operations to some other tables, sending messages, and so on
Stored procedures - ✔✔More involved procedures to enforce rules; they become a part of
the overall database definition and are invoked appropriately when certain conditions are
met.
,Active database system - ✔✔provide active rules that can automatically initiate
actions when certain events and conditions occur
Data mining application - ✔✔analyze large amounts of data to search for the occurrences
of specific patterns or relationships, and for identifying unusual patterns in areas such as credit
card fraud detection
Spatial application - ✔✔store and analyze spatial locations of data, such as weather
information, maps used in geographical information systems, and automobile
navigational systems
Time series application - ✔✔store information such as economic data at regular points
in time, such as daily sales and monthly gross national product figures
Cloud computing - ✔✔Consist of thousands of large servers managing so-called big data
for users on the Web
Client module - ✔✔In a basic client/server DBMS architecture, handles user interaction and
provides the user-friendly interfaces such as apps for mobile devices, or forms- or menu-
based GUIs (graphical user interfaces) for PCs
Server module - ✔✔In a basic client/server DBMS architecture, typically handles
data storage, access, search, and other functions
Basic data model operations - ✔✔Generic operations to insert, delete, modify, or
retrieve any kind of object
Dynamic aspect/behavior - ✔✔Allows the database designer to specify a set of valid
user-defined operations that are allowed on the database objects
, Conceptual data model - ✔✔Provide concepts that are close to the way many users
perceive data
Low-level/physical data model - ✔✔Provide concepts that describe
the details of how data is stored on the computer storage media, typically magnetic
disks. Concepts provided by physical data models are generally meant for computer
specialists, not for end users
Representational
(or implementation) data models - ✔✔Provide concepts that may be easily
understood by end users but that are not too far removed from the way data is organized in
computer storage
Entity - ✔✔represents a real-world object or concept, such as an employee or a project
from the miniworld that is described in the database. Has an independence existence.
Represented as a single-border rectangle.
Attribute - ✔✔Represents some particular property of interest that further describes
an entity, such as the employee's name or salary. Represented as a single-border oval.
Relationship - ✔✔An association among two or more entities; for example, a works-on
relationship between an employee and a project. Represented as a single-border diamond.
Entity-relationship model - ✔✔A popular high-level conceptual data model
Relational data model - ✔✔the main data model used in many current commencial DBMSs
Network model - ✔✔represents data as record types and also represents a limited type
of 1:N relationship
