1|Page
ISDS 7301 exam 2025 | new
actual questions with answers
What is the entity- relationship (ER) model is used for? - correct -answer-
to design relational databases by removing all existing redundancy in the
data
What is the basic object of the ER model - correct -answer-An entity
What is an entity? - correct -answer-a real world ojbect
Each entity has ? - correct -answer-Attributes
What are attributes ? - correct -answer-Properties of the entity that
describes the entity
What are the types of attributes ? - correct -answer-atomic , multivalued,
composite
An atomic value is always represented by ? - correct -answer-a single
value for a particular entity
Marital status is an example of a? - correct -answer-atomic value
a multivalued attribute may have ? - correct -answer-One or more values
, 2|Page
What are the 3 steps of 1NF? - correct -answer-1.Eliminate repeating
groups, 2. create separate tables for each set of related data , 3. identify a
primary key for each table
Separating the repeating groups of course from information results in ? -
correct -answer-1NF
The 3 steps of 2NF? - correct -answer-1. Ensuring 1NF is met, 2. remove
subsets of data that apply to multiple rows of a table and place them in
separate tables, 3. Create relationships between these new tables and their
predecessors through the use of Foreign keys
What is a foreign key? - correct -answer-a field in one table that uniquely
identifies a row within another table
Composite attributes are ? - correct -answer-Assembled using other
atomic attributes
an address is an example of a ___ attribute and why? - correct -answer-
composite, is made up of multiple atomic attributes such as , city , zip, and
street
a relationship exist when an entity refers to ? - correct -answer-one or
more other entities
1NF = - correct -answer-Eliminate Repeating Group, make seperate table
for each set of related attribute and give each table a primary key
2NF = - correct -answer-Eliminate Redundant data, if an attribute depends
on only part of a multi-valued key, remove it to a separate table
ISDS 7301 exam 2025 | new
actual questions with answers
What is the entity- relationship (ER) model is used for? - correct -answer-
to design relational databases by removing all existing redundancy in the
data
What is the basic object of the ER model - correct -answer-An entity
What is an entity? - correct -answer-a real world ojbect
Each entity has ? - correct -answer-Attributes
What are attributes ? - correct -answer-Properties of the entity that
describes the entity
What are the types of attributes ? - correct -answer-atomic , multivalued,
composite
An atomic value is always represented by ? - correct -answer-a single
value for a particular entity
Marital status is an example of a? - correct -answer-atomic value
a multivalued attribute may have ? - correct -answer-One or more values
, 2|Page
What are the 3 steps of 1NF? - correct -answer-1.Eliminate repeating
groups, 2. create separate tables for each set of related data , 3. identify a
primary key for each table
Separating the repeating groups of course from information results in ? -
correct -answer-1NF
The 3 steps of 2NF? - correct -answer-1. Ensuring 1NF is met, 2. remove
subsets of data that apply to multiple rows of a table and place them in
separate tables, 3. Create relationships between these new tables and their
predecessors through the use of Foreign keys
What is a foreign key? - correct -answer-a field in one table that uniquely
identifies a row within another table
Composite attributes are ? - correct -answer-Assembled using other
atomic attributes
an address is an example of a ___ attribute and why? - correct -answer-
composite, is made up of multiple atomic attributes such as , city , zip, and
street
a relationship exist when an entity refers to ? - correct -answer-one or
more other entities
1NF = - correct -answer-Eliminate Repeating Group, make seperate table
for each set of related attribute and give each table a primary key
2NF = - correct -answer-Eliminate Redundant data, if an attribute depends
on only part of a multi-valued key, remove it to a separate table
