Insy 3304 chapter 3 - 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 - Chapter 3 Terms...

INSY 3304 CHAPTER 3 EXAM QUESTIONS AND ANSWERS...

INSY 3304 - Chapter 3 Terms and Definitions Entity - Answer-is a person, place, event, or thing for which we intend to collect data Attribute - Answer-describes a characteristic of an entity Entity Set - Answer-a group of entities of the same type Table - Answer-(relation) contains a group of related entities Predicate Logic - Answer-used extensively in mathematic to provide a framework in which an assertion (statement of fact) can be verified as either true or false Set Theory - Answer-...

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