EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER ©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
INSY 3304 Exam 2 UTA STUDY GUIDE
WITH COMPLETE SOLUTIONS
Normalizations (3) - Answer✔✔--evaluating and correcting table structures to minimize data
redundancies
-1nf
-2nf
-3nf
1NF (First Normal Form) - Answer✔✔-Table Format. No repeating groups and a primary key identified.
2NF (Second Normal Form) - Answer✔✔-1NF and no partial dependencies
3NF (Third Normal Form) - Answer✔✔-2NF and no transitive dependencies
Dependencies (4) - Answer✔✔--Functional Dependency
-Full Functional Dependency
-Partial Dependency
-Transitive Dependency
Functional Dependency - Answer✔✔-The attribute B is fully functionally dependent on the attribute A if
each value of A determines one and only one value of B.
Page 1/6
, EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER ©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
Full Functional Dependency - Answer✔✔-If attribute B is functionally dependent on a composite key A
but not on any subset of that composite key, the attribute B is fully functionally dependent on A.
Partial Dependency - Answer✔✔-functional dependence in which the determinant is only part of the
primary key
Transitive Dependency - Answer✔✔-attribute is dependent on another attribute that is not part of the
primary key
DDL (Data Definition Language) - Answer✔✔-A part of SQL that is used to create and modify objects of a
database such as tables, views, functions and stored procedures
DML (Data Manipulation Language) - Answer✔✔-A part of SQL that is used query, insert, update and
remove data from a database
CREATE DATABASE - Answer✔✔-The SQL command to create a database
CREATE DATABASE databasename;
CREATE TABLE - Answer✔✔-Creates a new table in the user's database schema
CREATE TABLE tablename (as)
ALTER TABLE - Answer✔✔-Modifies a table's definition (adds, modifies, or deletes attributes or
constraints)
Page 2/6
FIRST PUBLISH SEPTEMBER 2024
INSY 3304 Exam 2 UTA STUDY GUIDE
WITH COMPLETE SOLUTIONS
Normalizations (3) - Answer✔✔--evaluating and correcting table structures to minimize data
redundancies
-1nf
-2nf
-3nf
1NF (First Normal Form) - Answer✔✔-Table Format. No repeating groups and a primary key identified.
2NF (Second Normal Form) - Answer✔✔-1NF and no partial dependencies
3NF (Third Normal Form) - Answer✔✔-2NF and no transitive dependencies
Dependencies (4) - Answer✔✔--Functional Dependency
-Full Functional Dependency
-Partial Dependency
-Transitive Dependency
Functional Dependency - Answer✔✔-The attribute B is fully functionally dependent on the attribute A if
each value of A determines one and only one value of B.
Page 1/6
, EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER ©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED
FIRST PUBLISH SEPTEMBER 2024
Full Functional Dependency - Answer✔✔-If attribute B is functionally dependent on a composite key A
but not on any subset of that composite key, the attribute B is fully functionally dependent on A.
Partial Dependency - Answer✔✔-functional dependence in which the determinant is only part of the
primary key
Transitive Dependency - Answer✔✔-attribute is dependent on another attribute that is not part of the
primary key
DDL (Data Definition Language) - Answer✔✔-A part of SQL that is used to create and modify objects of a
database such as tables, views, functions and stored procedures
DML (Data Manipulation Language) - Answer✔✔-A part of SQL that is used query, insert, update and
remove data from a database
CREATE DATABASE - Answer✔✔-The SQL command to create a database
CREATE DATABASE databasename;
CREATE TABLE - Answer✔✔-Creates a new table in the user's database schema
CREATE TABLE tablename (as)
ALTER TABLE - Answer✔✔-Modifies a table's definition (adds, modifies, or deletes attributes or
constraints)
Page 2/6
