Cleana

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

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

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

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

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

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

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

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

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