1NF (First Normal Form) - correct answer table is in this form when it does not contain repeating groups, each column contains atomic values and no
... [Show More] duplicate records
2NF - correct answer is a progression beyond 1NF that organizes the columns into smaller relation, no partial dependencies
3NF - correct answer include rules of 2NF but also exclude transitive dependencies. - No transitive dependencies exist
4NF - correct answer all requirements meet of 3NF
Further data integrity rules have been applied to remove all potential data modification anomalies
algoirthm - correct answer defined set of steps to solve a problem
atomic value - correct answer is a piece of data that cannot be meaningfully divided.
Boyce-Codd Normal Form (BCNF) - correct answer A special type of third normal form (3NF) in which every determinant is a candidate key
candidate key - correct answer An attribute, or combination of attributes, that uniquely identifies a row in a relation.
Codd's 12 rules - correct answer defines what is required from a DBMS in order for it to be considered relational
Codd's relational model of data - correct answer the original normalization process
composite key - correct answer An identifier consisting of a combination of
two or more fields that is used when more than one column is necessary to make a row unique in a table; also, an index with more than one key field.
data modification anomalies - correct answer storing info from multiple topics in one list creates problems when entering, updating and deleting information. Three types, insertion, update and delete anomalies
Deletion Anomaly - correct answer - unintended loss of data due to deletion of other data
- Ex: If a professor retires, data with his name deletes creating data deleted about current students
field - correct answer attribute, column
foreign key field - correct answer is a column or group of columns in a relational database table that provides a link between data in two tables.
functional dependence - correct answer idea of how attributes depend on or relate to other attributes in a relation.
functionally dependent - correct answer Functional dependency is a relationship that exists when one attribute uniquely determines another attribute.
- ex: idea of how attributes depend on or relate to other attributes in a relation.
IIF (Access built-in- function) - correct answer to extract a number of characters from the right side of the field
Insertion Anomaly - correct answer - if you cannot add data to the database due to absence of other data
- Ex: If student does not have student ID can't be assigned to professor
InStr (access built-in function) - correct answer to identify the location of the space character in the current field [Show Less]