Lamar University MISY 5300 Mid-term
integrity
When all data in a database satisfies all established integrity constraints.
integrity constraint
A rule that must be followed by data in a database.
many-to-many relationship
A relationship between three entities in which each occurrence of each entity can be
related to many occurrences of each of the other entities.
metadata
Information about information. also descriptive data stored with input sources.
NoSQL
A database management system such as MongoDB that uses a document model made
up of collections and documents to store data.
one-to-many relationship
A relationship between two entities in which each occurrence of the first entity is related
to many occurrences of the second entity, and each occurrence of the second entity is
related to at most one occurrence of the first entity.
data analyst
A person who uses tools and algorithms to mine a database for answers, information,
trends, and insights in internal organization data.
data file
A file that stores data about a single entity in one table or list.
,Data Indepenedence
A quality that allows you to change the structure of a database without requiring you to
make major changes to the programs that access the database.
data redundancy
The duplication of data, or the storing of the same data in more than one places
data security
Protection of data from threats including the prevention of unauthorized access to the
database, encryption of data as it travels through a network, protection against data
corruption, and protection against all other electronic and physical attacks to the data.
database
A collection of data organized in a manner that allows access, retrieval, and use of that
data.
database administration (DBA)
The person or group of people in charge of a database.
database administrator (DBA)
The person or group of people in charge of a database. Also called database
administration (DBA).
database design
The process of creating the entities, attributes, and relationships between tables of data.
Database management system (DBMS)
A program through which users interact with the data stored in a database.
encryption
Converting the data in a database to a format that is indecipherable by anyone other
than an authorized user.
, algorithm
A defined set of steps to solve a problem
attribute
A characteristic or property of an entity; also called a column or field
Big Data
The large volume of data produced by every digital process, system, sensor, mobile
device, and even social media exchange
Column
A characteristic of property of an entity, also called an attribute or a field
entity
A person, place, event, item, or other transaction for which you want to store and
process data. Also called a table.
entity-relationship (E-R) diagram
A graphic model for database design in which entities are represented as rectangles and
relationships are represented as either arrows or diamonds connected to the entities
they relate.
field
A character or property of an entity; also called an attribute or column.
flat file
A file that stores data in lists that have no relationship to other lists.
form
A screen object used to maintain and view data from a database.
integrity
When all data in a database satisfies all established integrity constraints.
integrity constraint
A rule that must be followed by data in a database.
many-to-many relationship
A relationship between three entities in which each occurrence of each entity can be
related to many occurrences of each of the other entities.
metadata
Information about information. also descriptive data stored with input sources.
NoSQL
A database management system such as MongoDB that uses a document model made
up of collections and documents to store data.
one-to-many relationship
A relationship between two entities in which each occurrence of the first entity is related
to many occurrences of the second entity, and each occurrence of the second entity is
related to at most one occurrence of the first entity.
data analyst
A person who uses tools and algorithms to mine a database for answers, information,
trends, and insights in internal organization data.
data file
A file that stores data about a single entity in one table or list.
,Data Indepenedence
A quality that allows you to change the structure of a database without requiring you to
make major changes to the programs that access the database.
data redundancy
The duplication of data, or the storing of the same data in more than one places
data security
Protection of data from threats including the prevention of unauthorized access to the
database, encryption of data as it travels through a network, protection against data
corruption, and protection against all other electronic and physical attacks to the data.
database
A collection of data organized in a manner that allows access, retrieval, and use of that
data.
database administration (DBA)
The person or group of people in charge of a database.
database administrator (DBA)
The person or group of people in charge of a database. Also called database
administration (DBA).
database design
The process of creating the entities, attributes, and relationships between tables of data.
Database management system (DBMS)
A program through which users interact with the data stored in a database.
encryption
Converting the data in a database to a format that is indecipherable by anyone other
than an authorized user.
, algorithm
A defined set of steps to solve a problem
attribute
A characteristic or property of an entity; also called a column or field
Big Data
The large volume of data produced by every digital process, system, sensor, mobile
device, and even social media exchange
Column
A characteristic of property of an entity, also called an attribute or a field
entity
A person, place, event, item, or other transaction for which you want to store and
process data. Also called a table.
entity-relationship (E-R) diagram
A graphic model for database design in which entities are represented as rectangles and
relationships are represented as either arrows or diamonds connected to the entities
they relate.
field
A character or property of an entity; also called an attribute or column.
flat file
A file that stores data in lists that have no relationship to other lists.
form
A screen object used to maintain and view data from a database.
