.png){kind=logo}
ISDS 7301 (actual / ) 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
- / 2
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 .
- / 2
.png)