Uta insy 3304 exam 2 - Study guides, Class notes & Summaries

UTA INSY 3304 - Exam 2 - Chapter 7&9 Latest 2023 Graded A Data definition language DDL Data manipulation language DML CREAT SCHEMA AUTHORIZATION Creates a database schema CREATE TABLE Creates a new table in the user's databse schema NOT NULL Ensures that a column will not have null values UNIQUE Ensures that a column will not have duplicate values PRIMARY KEY Defines a primary key for a table FOREIGN KEY Defines a foreign key for a table DEFAULT Defines a default value for a column ( whe...

UTA INSY 3304 EXAM 2 – 2024/2025...

UTA INSY 3304 – EXAM 2 -CHAPTER 7 AND 9 ()...

Data definition language - ️️DDL Data manipulation language - ️️DML CREAT SCHEMA AUTHORIZATION - ️️Creates a database schema CREATE TABLE - ️️Creates a new table in the user's databse schema NOT NULL - ️️Ensures that a column will not have null values UNIQUE - ️️Ensures that a column will not have duplicate values PRIMARY KEY - ️️Defines a primary key for a table FOREIGN KEY - ️️Defines a foreign key for a table DEFAULT - ️️Defines a d...

QUESTIONS AND ANSWERS

QUESTIONS AND ANSWERS

UTA INSY 3304 - Exam 2 - Chapter 7&9 Questions and Answers Latest Version 2023/2024( A+ GRADED 100% VERIFIED).

UTA INSY 3304 - Exam 2 - Chapter 7&9 Study Guide with Complete Solutions Data definition language - Answer-DDL Data manipulation language - Answer-DML CREAT SCHEMA AUTHORIZATION - Answer-Creates a database schema CREATE TABLE - Answer-Creates a new table in the user's databse schema NOT NULL - Answer-Ensures that a column will not have null values UNIQUE - Answer-Ensures that a column will not have duplicate values PRIMARY KEY - Answer-Defines a primary key for a table FOREIGN KEY - ...

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 -Parti...