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

INSY 3304 EXAM 2 LATEST UPDATED ...

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

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

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

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

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

Exam 2 INSY 3304 EXAM STUDY GUIDE WITH COMPLETE SOLUTIONS 1NF - Answer-first normal form. table format. no repeating groups SQL - Answer-Structured Query Language. The standardized relational database language for defining database objects and manipulating data. 2NF - Answer-Second Normal Form- 1NF and no partial dependencies 3NF - Answer-Third Normal Form- 2NF and no Transitive dependencies Parts of Dependencies - Answer-- Functional -Full functional - Partial -Transitive Functional...