ISDS 7301 (actual 2025/2026) QUESTIONS AND verified
ANSWERS CORRECT
What are the 3 steps of 1NF? - ---Answers----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 ? - ---Answers----1NF
The 3 steps of 2NF? - ---Answers----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? - ---Answers----a field in one table
that uniquely identifies a row within another table
Composite attributes are ? - ---Answers----Assembled using
other atomic attributes
an address is an example of a ___ attribute and why? - ---
Answers----composite, is made up of multiple atomic
attributes such as , city , zip, and street
, a relationship exist when an entity refers to ? - ---Answers---
-one or more other entities
1NF = - ---Answers----Eliminate Repeating Group, make
seperate table for each set of related attribute and give each
table a primary key
2NF = - ---Answers----Eliminate Redundant data, if an
attribute depends on only part of a multi-valued key, remove it
to a separate table
What are the two steps of 3NF? - ---Answers----1. ensuring
2NF is met ( ensure 1NF is met, remove subsets of data that
apply to multiple rows of a table and place them in separate
tables , create relationships between these new tables and
their predecessor through the use of foreign keys)
3NF = - ---Answers----Eliminate columns not dependent on
Key; if attributes do not contribute to a description of the key,
remove them to separate table
SQL Components: - ---Answers----
What are the basic features of SQL? - ---Answers----Literal
values , Delimiters , comments, identifiers, reserved keywords
What is a literal value? - ---Answers----an alphanumeric,
hexadecimal, or numeric constant .
ANSWERS CORRECT
What are the 3 steps of 1NF? - ---Answers----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 ? - ---Answers----1NF
The 3 steps of 2NF? - ---Answers----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? - ---Answers----a field in one table
that uniquely identifies a row within another table
Composite attributes are ? - ---Answers----Assembled using
other atomic attributes
an address is an example of a ___ attribute and why? - ---
Answers----composite, is made up of multiple atomic
attributes such as , city , zip, and street
, a relationship exist when an entity refers to ? - ---Answers---
-one or more other entities
1NF = - ---Answers----Eliminate Repeating Group, make
seperate table for each set of related attribute and give each
table a primary key
2NF = - ---Answers----Eliminate Redundant data, if an
attribute depends on only part of a multi-valued key, remove it
to a separate table
What are the two steps of 3NF? - ---Answers----1. ensuring
2NF is met ( ensure 1NF is met, remove subsets of data that
apply to multiple rows of a table and place them in separate
tables , create relationships between these new tables and
their predecessor through the use of foreign keys)
3NF = - ---Answers----Eliminate columns not dependent on
Key; if attributes do not contribute to a description of the key,
remove them to separate table
SQL Components: - ---Answers----
What are the basic features of SQL? - ---Answers----Literal
values , Delimiters , comments, identifiers, reserved keywords
What is a literal value? - ---Answers----an alphanumeric,
hexadecimal, or numeric constant .
