10/10/25, 1:10 PM Fundamentals of Database Systems
Fundamentals of Database Systems COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+||BRAND NEW!!!!
a collection of logically coherent related data with some
inherent meaning. designed, built, and populated with
Database
data for a specific purpose.
has an intended group of users and some preconceived
applications in which these users are interested.
NOT a random assortment of data.
Data known facts that can be recorded and that have implicit meaning
Miniworld, or universe of database representation of the real world. changes to the
discourse (UoD) miniworld are reflected in the database.
computerized system that enables users to create and maintain
a database. the DBMS is a general-purpose software system that
Database Management facilitates the processes of defining, constructing, manipulating,
System (DBMS) and sharing databases among various users and applications.
Defining a database involves specifying the data types, structures, and constraints of
the data to be stored in the database.
/ 1/24
,10/10/25, 1:10 PM Fundamentals of Database Systems
descriptive information stored by the DBMS in the form
Metadata
of a database catalog or dictionary.
Constructing the database process of storing the data on some storage medium that is
controlled by the DBMS
includes functions such as querying the database to
Manipulating the database retrieve specific data, updating the database to reflect
changes in the miniworld, and generating reports from
the data.
Sharing a database allows multiple users and programs to access the database
simultaneously.
Application program accesses the database by sending queries or requests for data to
the DBMS
causes some data to be retrieved. originally meaning a
Query question or an inquiry, is sometimes loosely used for all
types of interactions with databases, including
modifying data.
Transaction may cause some data to be read and some data to be written
into the database.
includes system protection, against hardware or
Database Protection
software malfunction (or crashes) and security
protection against unauthorized or malicious access.
Database Maintenance allowing the system to evolve as requirements change over time.
stored data, informally in a file. at a conceptual level, a
Data records
file is a collection of records that may or may not be
ordered.
Data elements elements within a database
Data type the categorical type of the data. integers, names, strings, etc.
Requirements specification First phase when designing a new database
and analysis
Meta-data Information about stored data
Tuple A row in formal relational model terminology
Attribute A column header in formal relational model terminology
Relation A table of values in formal relational model terminology.
The data type, or format, in formal relational model
terminology. A set of atomic values. Atomic meaning
Domain, D
each value in the domain is indivisible.
Example: Usa_phone_numbers. The set of ten-digit phone
numbers valid in the United States.
/ 2/24
, 10/10/25, 1:10 PM Fundamentals of Database Systems
R(A1, A2, A3, ..., An) made up of a relation name R and
Relation Schema, or Relation a list of attributes. Each attribute, Ai, is the name of a
Scheme
role played by some domain, D, in the relation schema,
R.
Degree, or Arity, of a schema The number of attributes, n, of its relation schema.
denoted by r(R), is a set of n-tuples r = {t1, t2, t3, ..., tm}.
Relation, or Relation State Each n-tuple t is an ordered list of n-values t=<v1, v2, v3,
..., vn> Where each value vi, 1 <= i <= n, is an element of
dom(Ai) or is a special NULL value.
when the attribute name and value are included together in a
Self-describing data
tuple, the description
of each value is included in the tuple.
constraints that are inherent in the data model
Inherent mode-based
constraints, or implicit
constraints
constraints that can be directly expressed in the schemas of the
Schema-based constraints or
data model, typically by specifying them in the DDL (data
explicit constraints
definition language)
constraints that cannot be directly expressed in the schemas of
Application-based or
the data model, and hence must be expressed and enforced by
semantic constraints, or even
the application programs or in some other way.
business rules
A collection of tables
Relational Database
/ 3/24
Fundamentals of Database Systems COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED ANSWERS)
|ALREADY GRADED A+||BRAND NEW!!!!
a collection of logically coherent related data with some
inherent meaning. designed, built, and populated with
Database
data for a specific purpose.
has an intended group of users and some preconceived
applications in which these users are interested.
NOT a random assortment of data.
Data known facts that can be recorded and that have implicit meaning
Miniworld, or universe of database representation of the real world. changes to the
discourse (UoD) miniworld are reflected in the database.
computerized system that enables users to create and maintain
a database. the DBMS is a general-purpose software system that
Database Management facilitates the processes of defining, constructing, manipulating,
System (DBMS) and sharing databases among various users and applications.
Defining a database involves specifying the data types, structures, and constraints of
the data to be stored in the database.
/ 1/24
,10/10/25, 1:10 PM Fundamentals of Database Systems
descriptive information stored by the DBMS in the form
Metadata
of a database catalog or dictionary.
Constructing the database process of storing the data on some storage medium that is
controlled by the DBMS
includes functions such as querying the database to
Manipulating the database retrieve specific data, updating the database to reflect
changes in the miniworld, and generating reports from
the data.
Sharing a database allows multiple users and programs to access the database
simultaneously.
Application program accesses the database by sending queries or requests for data to
the DBMS
causes some data to be retrieved. originally meaning a
Query question or an inquiry, is sometimes loosely used for all
types of interactions with databases, including
modifying data.
Transaction may cause some data to be read and some data to be written
into the database.
includes system protection, against hardware or
Database Protection
software malfunction (or crashes) and security
protection against unauthorized or malicious access.
Database Maintenance allowing the system to evolve as requirements change over time.
stored data, informally in a file. at a conceptual level, a
Data records
file is a collection of records that may or may not be
ordered.
Data elements elements within a database
Data type the categorical type of the data. integers, names, strings, etc.
Requirements specification First phase when designing a new database
and analysis
Meta-data Information about stored data
Tuple A row in formal relational model terminology
Attribute A column header in formal relational model terminology
Relation A table of values in formal relational model terminology.
The data type, or format, in formal relational model
terminology. A set of atomic values. Atomic meaning
Domain, D
each value in the domain is indivisible.
Example: Usa_phone_numbers. The set of ten-digit phone
numbers valid in the United States.
/ 2/24
, 10/10/25, 1:10 PM Fundamentals of Database Systems
R(A1, A2, A3, ..., An) made up of a relation name R and
Relation Schema, or Relation a list of attributes. Each attribute, Ai, is the name of a
Scheme
role played by some domain, D, in the relation schema,
R.
Degree, or Arity, of a schema The number of attributes, n, of its relation schema.
denoted by r(R), is a set of n-tuples r = {t1, t2, t3, ..., tm}.
Relation, or Relation State Each n-tuple t is an ordered list of n-values t=<v1, v2, v3,
..., vn> Where each value vi, 1 <= i <= n, is an element of
dom(Ai) or is a special NULL value.
when the attribute name and value are included together in a
Self-describing data
tuple, the description
of each value is included in the tuple.
constraints that are inherent in the data model
Inherent mode-based
constraints, or implicit
constraints
constraints that can be directly expressed in the schemas of the
Schema-based constraints or
data model, typically by specifying them in the DDL (data
explicit constraints
definition language)
constraints that cannot be directly expressed in the schemas of
Application-based or
the data model, and hence must be expressed and enforced by
semantic constraints, or even
the application programs or in some other way.
business rules
A collection of tables
Relational Database
/ 3/24
