Most relational database (RDB) designers agree that in order to effectively manage the complexities of real-world transactions without introducing anomalies, a database design needs to reach at least ________.
A.third normal form
B.second normal form
C.the standard of a flat file
D.first normal form
Consider the table (Relation) STUDREC with attributes: SREF (Key Field), INIT, SNAME, DOB, GENDER, RES, KIDS, HTOWN, DISTANCE. Assuming that HTOWN (Hometown) functionally determines DISTANCE (Distance from campus), in which highest normal form is this relation?
💻 sql Snippet
STUDREC(SREF, INIT, SNAME, DOB, GENDER, RES, KIDS, HTOWN, DISTANCE)
FD: HTOWN -> DISTANCE
A.second normal form
B.third normal form
C.first normal form
D.Boyce-Codd normal form
Consider the relation STUDREC(SREF, INIT, SNAME, DOB, GENDER, RES, KIDS, HTOWN, DISTANCE) where SREF (Student Reference Number) is the single-attribute primary key. Assuming HTOWN (Hometown) functionally determines DISTANCE (Distance from campus), in which highest normal form is this relation?
💻 sql Snippet
STUDREC(SREF, INIT, SNAME, DOB, GENDER, RES, KIDS, HTOWN, DISTANCE)
FD: HTOWN -> DISTANCE
A.second normal form
B.first normal form
C.third normal form
D.Boyce-Codd normal form
Which normal form rule specifies that there should be no repeating fields or groups and that all attribute domain values must be atomic?
A.first normal form
B.second normal form
C.third normal form
D.fourth normal form
Which normal form requires that each non-key field (attribute) must be fully functionally dependent on the primary key?
A.second normal form
B.first normal form
C.third normal form
D.Boyce-Codd normal form
Second Normal Form (2NF) is designed to ________.
A.ensure that every non-key field in a record is fully functionally dependent upon the primary key for that record
B.eliminate transitive dependencies between non-key attributes
C.ensure all attributes contain atomic, non-repeating values
D.enforce referential integrity constraints between foreign keys
First Normal Form (1NF) is designed to ________.
A.ensure that there are no repeating fields in a table (i.e., the fields are atomic)
B.ensure that there are no duplicate key fields in a table
C.ensure that data is held accurately without foreign keys
D.ensure that all of the data in an RDBMS is represented in one data table
Third Normal Form (3NF) is designed to ________.
A.ensure that there are no transitive dependencies between non-key fields
B.ensure that every non-key field is fully functionally dependent on the primary key
C.ensure that all fields in a table are atomic and contain no repeating groups
D.ensure that every non-key field has a corresponding foreign key in at least one other table
Normalization is defined as ________.
A.a process whereby the design of a table (relation) is decomposed into more tables that more precisely fit the relational model
B.the process of ensuring that a relational database has at least two tables in it
C.a method for converting relational tables into flat files
D.the process of combining multiple entities into a single universal table
Database normalization is best defined as ________.
A.a process whereby the design of a table (relation) is decomposed into more tables that more precisely fit the relational model
B.the process of ensuring that a relational database has at least two tables in it
C.a process whereby a limit is put on the number of fields a record can contain
D.the process of ensuring that each table has a key
