INSY 3304 Exam 1 Questions and Answers bundle!!!

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

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

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

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

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

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