OMIS 452 Final Exam (all quizzes)
Questions and Answers 100% Solved
In a relational database design, all relationships are expressed by
________. - 🧠 ANSWER ✔✔Creating a foreign key
The identifier of the entity becomes the ________ of the corresponding
table - 🧠 ANSWER ✔✔Primary Key
Which of the following is not true about surrogate keys? - 🧠 ANSWER
✔✔They are non-unique within a table
Which of the following is not a step in the database design process? - 🧠
ANSWER ✔✔Create constraints and triggers
Each attribute of an entity becomes a(n) ________ of a table. - 🧠 ANSWER
✔✔Column
,The first step in transforming an extended E-R model into a relational
database design is to ________ - 🧠 ANSWER ✔✔Create a table for each
entity
A surrogate key should be considered when ________. - 🧠 ANSWER
✔✔The key contains a lengthy text field
The ideal primary key is ________. - 🧠 ANSWER ✔✔All of the above
When representing a 1:1 relationship in a relational database design
________. - 🧠 ANSWER ✔✔The key of either table may be placed as a
foreign key into the other
To which of the following actions are referential integrity constraints not
applied? - 🧠 ANSWER ✔✔Create
The Entity-Relationship (E-R) Model may contain which of the following
items: - 🧠 ANSWER ✔✔Tables, Attributes, Identifiers, and Relationships
T/F: When the key of one table is placed into a second table to represent a
relationship, the key is called a "relational key" in the second table - 🧠
ANSWER ✔✔False
, T/F: A foreign key is a key that does not belong in any table. - 🧠 ANSWER
✔✔False
T/F: When creating a table in the relational database design from an entity
in the extended E-R model, the attributes of the entity become the rows of
the table. - 🧠 ANSWER ✔✔False
T/F: Data types are consistent across all DBMS products. - 🧠 ANSWER
✔✔False
T/F: An intersection table can have additional attributes besides the keys of
its parent tables. - 🧠 ANSWER ✔✔False
T/F: It is easy to enforce the referential integrity actions for M-M
relationships. - 🧠 ANSWER ✔✔False
T/F: When creating a relational database design from E-R diagrams, first
create a relation for each relationship. - 🧠 ANSWER ✔✔False
T/F: To represent a 1:N relationship in a relational database design, an
intersection table is created - 🧠 ANSWER ✔✔False
T/F: In a 1:N relationship, the term "parent" refers to the table on the
"many" side of the relationship. - 🧠 ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
Questions and Answers 100% Solved
In a relational database design, all relationships are expressed by
________. - 🧠 ANSWER ✔✔Creating a foreign key
The identifier of the entity becomes the ________ of the corresponding
table - 🧠 ANSWER ✔✔Primary Key
Which of the following is not true about surrogate keys? - 🧠 ANSWER
✔✔They are non-unique within a table
Which of the following is not a step in the database design process? - 🧠
ANSWER ✔✔Create constraints and triggers
Each attribute of an entity becomes a(n) ________ of a table. - 🧠 ANSWER
✔✔Column
,The first step in transforming an extended E-R model into a relational
database design is to ________ - 🧠 ANSWER ✔✔Create a table for each
entity
A surrogate key should be considered when ________. - 🧠 ANSWER
✔✔The key contains a lengthy text field
The ideal primary key is ________. - 🧠 ANSWER ✔✔All of the above
When representing a 1:1 relationship in a relational database design
________. - 🧠 ANSWER ✔✔The key of either table may be placed as a
foreign key into the other
To which of the following actions are referential integrity constraints not
applied? - 🧠 ANSWER ✔✔Create
The Entity-Relationship (E-R) Model may contain which of the following
items: - 🧠 ANSWER ✔✔Tables, Attributes, Identifiers, and Relationships
T/F: When the key of one table is placed into a second table to represent a
relationship, the key is called a "relational key" in the second table - 🧠
ANSWER ✔✔False
, T/F: A foreign key is a key that does not belong in any table. - 🧠 ANSWER
✔✔False
T/F: When creating a table in the relational database design from an entity
in the extended E-R model, the attributes of the entity become the rows of
the table. - 🧠 ANSWER ✔✔False
T/F: Data types are consistent across all DBMS products. - 🧠 ANSWER
✔✔False
T/F: An intersection table can have additional attributes besides the keys of
its parent tables. - 🧠 ANSWER ✔✔False
T/F: It is easy to enforce the referential integrity actions for M-M
relationships. - 🧠 ANSWER ✔✔False
T/F: When creating a relational database design from E-R diagrams, first
create a relation for each relationship. - 🧠 ANSWER ✔✔False
T/F: To represent a 1:N relationship in a relational database design, an
intersection table is created - 🧠 ANSWER ✔✔False
T/F: In a 1:N relationship, the term "parent" refers to the table on the
"many" side of the relationship. - 🧠 ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
