Cleana
I am a student like you, I create notes to help my fellow students excel amidst tight deadlines and never ending responsibilities. Hope the study materials that you will find here will help reduce your college workload.
MOST GRADED STUDYING MATERIALS
- 2754
- 0
- 263
Community
- Seguidores
- Siguiendo
9 Comentarios recibidos
3019 artículos
UTA INSY 3304 - Chapter 10 exam
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 committed they cannot be undone or lost 
 
Serializability - a...
- Examen
- • 8 páginas •
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 committed they cannot be undone or lost 
 
Serializability - a...
UTA INSY 3304 - Exam 2 - Chapter 7&9
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 - answer-Defines a foreign key for a table 
 
DEFAULT - answer-...
- Examen
- • 11 páginas •
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 - answer-Defines a foreign key for a table 
 
DEFAULT - answer-...
INSY 3304 UTA Exam 2 Quizzes and Answers
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 ...
- Examen
- • 6 páginas •
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 ...
INSY 3304 UTA EXAM 1 QUESTIONS AND ANSWERS 2024
Structural dependence - answer-A change in any file's structure requires the modification of all programs using that file. 
 
Data dependence - answer-A change in any files data characteristics requires changes of all data access programs 
 
Data redundancy - answer-Same information stored in more than one place 
 
Problems due to uncontrolled data redundancy - answer-Data inconsistency ( lack of data integrity) 
 
Modification Anomalies - answer-Inconsistent data due to modifications 
 
Inse...
- Examen
- • 13 páginas •
Structural dependence - answer-A change in any file's structure requires the modification of all programs using that file. 
 
Data dependence - answer-A change in any files data characteristics requires changes of all data access programs 
 
Data redundancy - answer-Same information stored in more than one place 
 
Problems due to uncontrolled data redundancy - answer-Data inconsistency ( lack of data integrity) 
 
Modification Anomalies - answer-Inconsistent data due to modifications 
 
Inse...
INSY 3304 MIDTERM EXAM QUIZZES AND ANSWERS
Components of DB System - 1)Hardware (comp, storage, printers) 
2)Software (OS, DBMS software, apps) 
3)People (all users, admin, end users, programmers) 
4)Procedures (rules, enforce standards) 
5)Data (collection of facts stored) 
 
Functions of DBMS - 1) Data Dictionary management (stores definition of data elements and their relationships) 
2) Data storage management (creates/ manages complex structures required for data storage) 
3)Data transformation and presentation (conforms entered data...
- Examen
- • 16 páginas •
Components of DB System - 1)Hardware (comp, storage, printers) 
2)Software (OS, DBMS software, apps) 
3)People (all users, admin, end users, programmers) 
4)Procedures (rules, enforce standards) 
5)Data (collection of facts stored) 
 
Functions of DBMS - 1) Data Dictionary management (stores definition of data elements and their relationships) 
2) Data storage management (creates/ manages complex structures required for data storage) 
3)Data transformation and presentation (conforms entered data...
INSY 3304 FINAL REVIEW TEST 2024
Limitations of a file system in data management - answer-- Data dependence 
- Structural dependence 
- Data redundancy leading to deletion, insertion, and modification anomalies 
 
Components of a DBMS/database Environment - answer-- hardware, software, people, procedure, and data 
 
Data Modeling - answer-is iterative and progressive 
 
Database models - answer-Conceptual and Implementation 
 
Conceptual - answer-The conceptual model provides a global view of an entire database. Describes the m...
- Examen
- • 19 páginas •
Limitations of a file system in data management - answer-- Data dependence 
- Structural dependence 
- Data redundancy leading to deletion, insertion, and modification anomalies 
 
Components of a DBMS/database Environment - answer-- hardware, software, people, procedure, and data 
 
Data Modeling - answer-is iterative and progressive 
 
Database models - answer-Conceptual and Implementation 
 
Conceptual - answer-The conceptual model provides a global view of an entire database. Describes the m...
INSY 2303 UTA Exam 3 Questions and Answers
Information System - answer-Collects, stores, and processes data to provide useful, accurate, and timely information 
 
Organization - answer-a group of people working together to accomplish a goal 
 
Enterprise - answer-Any organization that seeks profit by providing goods and services 
 
5 components of an information system - answer-Hardware, software, communication networks, policies and procedures, people 
 
Vertical Market - answer-software designed for a specific industry or enterprise 
 ...
- Examen
- • 16 páginas •
Information System - answer-Collects, stores, and processes data to provide useful, accurate, and timely information 
 
Organization - answer-a group of people working together to accomplish a goal 
 
Enterprise - answer-Any organization that seeks profit by providing goods and services 
 
5 components of an information system - answer-Hardware, software, communication networks, policies and procedures, people 
 
Vertical Market - answer-software designed for a specific industry or enterprise 
 ...
INSY 3304 Exam 1 Questions and Answers
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 database. - answer-False 
 
Corporations use only struc...
- Examen
- • 11 páginas •
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 database. - answer-False 
 
Corporations use only struc...
EDPNA practice exam – ethical Bundle!!!
EDPNA practice exam – ethical Bundle!!!
EDPNA practice exam – ethical Bundle!!!
- Lote
- • 4 artículos •
EDPNA practice exam – ethical Bundle!!!
EDPNA practice exam – ethical Bundle!!!
CYBR 7350 – Final Exam Questions and Answers
____ planning represents the final response of the organization when faced with any interruption of its critical operations. - answer-Business continuity 
 
Like DR planning, the identification of critical business functions and the resources to support them are the cornerstone of the process used to create the business continuity (BC) plan. - answer-True 
 
The ____ is the amount of time that a business can tolerate losing capabilities until alternate capabilities are available. - answer-recove...
- Examen
- • 6 páginas •
____ planning represents the final response of the organization when faced with any interruption of its critical operations. - answer-Business continuity 
 
Like DR planning, the identification of critical business functions and the resources to support them are the cornerstone of the process used to create the business continuity (BC) plan. - answer-True 
 
The ____ is the amount of time that a business can tolerate losing capabilities until alternate capabilities are available. - answer-recove...
USAV Volleyball Training Answers 2024
Ohio Lead Abatement contractor test questions and answers
Ohio Lead Abatement contractor test questions and answers
Ohio Lead Abatement contractor test questions and answers
Ohio Lead Abatement contractor test questions and answers