IST 359 Final Exam Questions With Correct
Answers
Entity Mapping - CORRECT ANSWER✔✔-translates to a relational table
| | | | | | | |
Bridge Table - CORRECT ANSWER✔✔-this is required to map a many-to-many
| | | | | | | | | | |
relationship
Mapping - CORRECT ANSWER✔✔-the process of transforming a conceptual
| | | | | | | | |
model into a logical model
| | | |
Attribute Mapping - CORRECT ANSWER✔✔-translates to relational tables or
| | | | | | | | |
columns within a table
| | |
Analysis - CORRECT ANSWER✔✔-the process of componentizing a complicated
| | | | | | | | |
problem to achieve a better understanding of it
| | | | | | |
Relationship Mapping - CORRECT ANSWER✔✔-translates to foreign key
| | | | | | | |
placement
Unique Attribute Type Mapping - CORRECT ANSWER✔✔-translates to setting a
| | | | | | | | | |
unique key constraint
| |
Entity - CORRECT ANSWER✔✔-a thing for which you need to store date
| | | | | | | | | | |
, Attributes - CORRECT ANSWER✔✔-characteristics or descriptors of an entity
| | | | | | | |
Relationships - CORRECT ANSWER✔✔-business rules which connect entities
| | | | | | | |
together
Required Attribute Type Mapping - CORRECT ANSWER✔✔-translates to not
| | | | | | | | |
allowing null on the table's column
| | | | |
Composite Attribute Type Mapping - CORRECT ANSWER✔✔-translates to
| | | | | | | |
breaking down the attribute into more than one table column
| | | | | | | | |
NOT NULL Foreign Key - CORRECT ANSWER✔✔-this is required to map a weak
| | | | | | | | | | | | |
entity
Unique - CORRECT ANSWER✔✔-an attribute value should be different for each
| | | | | | | | | | |
entity
Foreign Key - CORRECT ANSWER✔✔-this is required to map a one to many
| | | | | | | | | | | | |
relationship
Foreign Key w/ Unique Constraint - CORRECT ANSWER✔✔-this is required to map
| | | | | | | | | | |
a one to one relationship
| | | | |
Required - CORRECT ANSWER✔✔-an attribute value is mandatory
| | | | | | |
Answers
Entity Mapping - CORRECT ANSWER✔✔-translates to a relational table
| | | | | | | |
Bridge Table - CORRECT ANSWER✔✔-this is required to map a many-to-many
| | | | | | | | | | |
relationship
Mapping - CORRECT ANSWER✔✔-the process of transforming a conceptual
| | | | | | | | |
model into a logical model
| | | |
Attribute Mapping - CORRECT ANSWER✔✔-translates to relational tables or
| | | | | | | | |
columns within a table
| | |
Analysis - CORRECT ANSWER✔✔-the process of componentizing a complicated
| | | | | | | | |
problem to achieve a better understanding of it
| | | | | | |
Relationship Mapping - CORRECT ANSWER✔✔-translates to foreign key
| | | | | | | |
placement
Unique Attribute Type Mapping - CORRECT ANSWER✔✔-translates to setting a
| | | | | | | | | |
unique key constraint
| |
Entity - CORRECT ANSWER✔✔-a thing for which you need to store date
| | | | | | | | | | |
, Attributes - CORRECT ANSWER✔✔-characteristics or descriptors of an entity
| | | | | | | |
Relationships - CORRECT ANSWER✔✔-business rules which connect entities
| | | | | | | |
together
Required Attribute Type Mapping - CORRECT ANSWER✔✔-translates to not
| | | | | | | | |
allowing null on the table's column
| | | | |
Composite Attribute Type Mapping - CORRECT ANSWER✔✔-translates to
| | | | | | | |
breaking down the attribute into more than one table column
| | | | | | | | |
NOT NULL Foreign Key - CORRECT ANSWER✔✔-this is required to map a weak
| | | | | | | | | | | | |
entity
Unique - CORRECT ANSWER✔✔-an attribute value should be different for each
| | | | | | | | | | |
entity
Foreign Key - CORRECT ANSWER✔✔-this is required to map a one to many
| | | | | | | | | | | | |
relationship
Foreign Key w/ Unique Constraint - CORRECT ANSWER✔✔-this is required to map
| | | | | | | | | | |
a one to one relationship
| | | | |
Required - CORRECT ANSWER✔✔-an attribute value is mandatory
| | | | | | |