QUESTION 1 What is the most common relationship within a relational database? Select the best answer…

QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an “entity’? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL databases. O An entity provides the meta-data about the entire database. QUESTION 3 What is true of foreign keys. Select the best answer from the following. A foreign key is a column or columns that is the same as the primary key of some table in the database. A foreign is created by giving it the same name as the column that it matches in the primary (parent) table. O A foreign key is only found in Many-To-Many relationships and is the mechanism that makes this relationship possible in database. Foreign keys are not used in relational database design 1015_locontent_id=_13944430_18 step= Question Completion Status: Which of the following answers is the correct response to the issue/question of single-valued versus multivalued attributes? Select the best answer from the following. Single- versus multi-valued attributes is simply a design choice and is an issue that is left up to the personal choices of the database designer. o Only multivalued attributes are allowed in the design of a relational database. o In the design of a relational database there should never be multivalued attributes. Both single- and multi-valued attributes are allowed in a relational database, but single-valued attributes are more efficient in terms of data storage and speed of searching, QUESTIONS What is true with respect to a row’s primary key? Select all answers that apply. The primary key should contain a value that should never change the value should be immutable. The primary key of one table is used only to create a relationship to a different table’s primary key. The primary key must not contain the value . The primary key uniquely identifies each row in a table. Y competion Status QUESTION 7 What is an “ERD? Select the best answer from the following An ERD represents an Error in the Relational Design O An ERD is an Elemental Redesign Document. An ERD is an Entity-Relationship diagram. OERD is the service in AWS where a database is created. QUESTIONS What is an “attribute”? Select the best answer from the following. O An attribute, for our purposes, is the same as a table in the database. O An attribute represents one of the columns in an individual table. There are no attributes in a relational database. Attributes are only part of NoSQL databases. An attribute provides the meta-data about the entire database. QUESTION 9 What is “Referential Integrity’? Select the best answer from the following. o Referential integrity is a process followed by database designers to ensure their database designs are correct Referential integrity is not part of the relational database design. Referential integrity is achieved when related tables are grouped together within a schema Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.