COP 4710 CH.1
Database - correct answer ✔collection of related data
Data - correct answer ✔known facts that can be recorded and have explicit
meaning
Database implicit properties - correct answer ✔1- represents some aspects
of the real world (mini-world or universe of discourse (UoD)
2- logically coherent collection of data with some inherent meaning
3- designed, built, and populated with data for a specific purpose
Database Management System (DBMS) - correct answer ✔- computerized
system that enables users to create and maintain a database
- facilitates the process of defining, constructing, manipulating, and sharing
databases among various users and apps
- protects and maintains databases
Defining (a database) - correct answer ✔specifying data types, structures,
and constraints of the data
Meta-data - correct answer ✔The database definition or descriptive
information is also stored by the DBMS in the form of a database catalog or
dictionary
Constructing (a database) - correct answer ✔process of storing the data on
some storage medium that is controlled by the DBMS
, Manipulating (a database) - correct answer ✔includes functions such as
querying the database to retrieve specific data, updating the database to
reflect changes in the mini-world, and generating reports from the data.
Sharing (a database) - correct answer ✔allows multiple users and programs
to access the database simultaneously.
Protecting (a database) - correct answer ✔system protection against
hardware or software malfunction (or crashes) and security protection against
unauthorized or malicious access
Maintaining (a database) - correct answer ✔allowing the system to evolve as
requirements change over time
Application Program - correct answer ✔Accesses the database by sending
queries or requests for data to the DBMS
Query - correct answer ✔typically causes some data to be retrieved
Database System - correct answer ✔database and DBMS software together
EXAMPLE OF A DATABASE - correct answer ✔University Database:
database is organized as 5 files each of which stores data records of the
same type. The STUDENT file stores data on each student, the COURSE file
stores data on each course, the SECTION file stores data on each section of
a course, the GRADE_REPORT file stores the grades that students receive in
the various sections they have completed, and the PREREQUISITE file stores
the prerequisites of each course.
1- DEFINE:
Database - correct answer ✔collection of related data
Data - correct answer ✔known facts that can be recorded and have explicit
meaning
Database implicit properties - correct answer ✔1- represents some aspects
of the real world (mini-world or universe of discourse (UoD)
2- logically coherent collection of data with some inherent meaning
3- designed, built, and populated with data for a specific purpose
Database Management System (DBMS) - correct answer ✔- computerized
system that enables users to create and maintain a database
- facilitates the process of defining, constructing, manipulating, and sharing
databases among various users and apps
- protects and maintains databases
Defining (a database) - correct answer ✔specifying data types, structures,
and constraints of the data
Meta-data - correct answer ✔The database definition or descriptive
information is also stored by the DBMS in the form of a database catalog or
dictionary
Constructing (a database) - correct answer ✔process of storing the data on
some storage medium that is controlled by the DBMS
, Manipulating (a database) - correct answer ✔includes functions such as
querying the database to retrieve specific data, updating the database to
reflect changes in the mini-world, and generating reports from the data.
Sharing (a database) - correct answer ✔allows multiple users and programs
to access the database simultaneously.
Protecting (a database) - correct answer ✔system protection against
hardware or software malfunction (or crashes) and security protection against
unauthorized or malicious access
Maintaining (a database) - correct answer ✔allowing the system to evolve as
requirements change over time
Application Program - correct answer ✔Accesses the database by sending
queries or requests for data to the DBMS
Query - correct answer ✔typically causes some data to be retrieved
Database System - correct answer ✔database and DBMS software together
EXAMPLE OF A DATABASE - correct answer ✔University Database:
database is organized as 5 files each of which stores data records of the
same type. The STUDENT file stores data on each student, the COURSE file
stores data on each course, the SECTION file stores data on each section of
a course, the GRADE_REPORT file stores the grades that students receive in
the various sections they have completed, and the PREREQUISITE file stores
the prerequisites of each course.
1- DEFINE:
