Chapter 5 - MISY 5300 question and answers graded A+ 2023/2024

Chapter 5 - MISY 5300 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 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