Insy 3304 database - Study guides, Class notes & Summaries

INSY 3304 Midterm Review Study Guide with Complete Solutions Components of a Database System - Answer-People Hardware Software Procedure Data Functions of a DBMS - Answer-Indexing Views Security Integrity Concurrency Backup/Recovery Design Documentation Update/Query The different types of Database Systems (users) - Answer-Desktop Database - one user EMILLYCHARLOTTE 2024/2025 ACADEMIC YAER ©2024 EMILLYCHARLOTTE. ALL RIGHTS RESERVED FIRST PUBLISH SEPTEMBER 2024 Page 2/14 Multi...

INSY 3304 Exam 1 Study Guide with Complete Solutions A _______ is anything about which data are to be collected and stored. - Answer-entity A ________ is bidirectional. - Answer-relationship Database designers determine the data and information that yield the required understanding of the entire business. - Answer-False In an SQL-based relational database, each table is dependent on every other table. - Answer-False An operational database is sometimes referred to as an enterprise databas...

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 1 Review Study Guide with Complete Solutions Data - Answer-Raw facts that must be formatted for storage, processing, and presentation Information - Answer-The result of processing raw data to reveal its meaning Knowledge - Answer-The body of information and facts about a specific subject Data Management - Answer-A discipline that focuses on the proper generation, storage, and retrieval of data Database - Answer-A shared, integrated computer structure that stores a collectio...

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

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

UTA INSY 3304 - Chapter 10 Study Guide with Complete Solutions Transaction - Answer-A logical unit of work that must be entirely completed or aborted Atomicity - Answer-All operations of a transaction must be completed; if not the transaction is aborted Consistency - Answer-Permanence of database's consistent state Isolation - Answer-Data used during transaction cannot be used by second transaction until the first is completed Durability - Answer-Ensures that once transactions are com...

INSY 3304 CH 3 EXAM STUDY GUIDE WITH COMPLETE SOLUTIONS If a foreign key contains either matching values or nulls, the tables that make use of such a foreign key are said to exhibit ________ integrity. - Answer-Referential The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be. - Answer-1 : 1 A relational operator that yields all rows in one table that are not found in the other table is the ________ operator. - Answer-d...