Summary Handbook Statistics Final Exam (CIS) 2023 Questions and Answers [Level A+]

Attributes - -data elements associated with an entity -Record - -a collection of related data elements -Primary Key - -A field (or group of fields) that uniquely identifies a given entity in a table -Foreign Key - -A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables -entity - -stores information about a person, place, thing, transaction, or event -relation between entities and attributes in a relational database - -each attribute of an entity occupies a separate column of a table -identity management - -a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity -Data field and Data Element - -represent the smallest or basic unit of information -data models - -logical data structures that detail the relationships among data elements using graphics or pictures -Metadata - -provides details about data -data dictionary - -compiles all of the metadata about the data elements in the data model -relational database model - -stores information