algorithm - correct answer set of rules, calculations, and assumptions used to solve a problem
big data - correct answer describes the large volume of
... [Show More] data produced by every digital process, system, sensor, mobile device, and even social media exchange
data independence - correct answer 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 - correct answer the duplication of data, or the storing of the same data in more than one place
data security - correct answer 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 management system - correct answer a program through which users interact with the data stored in a database
encryption - correct answer converting the data in a database to a format that is indecipherable by anyone other than an authorized user
flat file - correct answer a file that stores data in lists that have no relationship to other lists
form - correct answer a screen object used to maintain and view data from a database
integrity - correct answer a database has this is the data in it satisfies all established integrity constraints
metadata - correct answer information about information; also descriptive data stored with input sources
noSQL - correct answer 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 - correct answer a relationship between two entities in which each occurrence of the first entity is related to one occurrence of the second entity, and each occurrence of the second entity is related to at most one occurrence of the first entity
orphan record - correct answer a record in the "many" table that has no match in the "one" table in a one-to-many relationship
redundancy - correct answer the duplication of data, or the storing of the same data in more than one place.
referential integrity - correct answer a relationship database concept that sets rules called integrity constraints on table relationships primarily to prevent the creation of orphan records
structured data - correct answer data that is traditional in its retrieval and storage in database management systems
unstructured data - correct answer data not organized or easily interpreted by traditional or data models, which may involve a lot of text and metadata.
action query - correct answer a query that changes data in a batch process
aggregate function - correct answer part of an expression used to calculate the number of entries, the sum or average of all entries in a given column, or the largest or smallest of the entries in a given column; also called function
attribute - correct answer a characteristic or property of an entity; also called column or field
batch update - correct answer to modify several records in a single process [Show Less]