Midterm questions and answers graded A+ 202023/2024 verified to pass

Midterm algorithm - correct answer set of rules, calculations, and assumptions used to solve a problem big data - correct answer describes the large volume of 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