Insy 3304 - Study guides, Class notes & Summaries

UTA INSY 3304 – EXAM 2 -CHAPTER 7 AND 9 ()...

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 EXAM QUESTIONS AND ANSWERS 100% VERIFIED...

INSY 3304 Midterm Exam With Questions And 100% Correct Answers...

CREATE TABLE AS - ️️Creates a new table based on a query in the user's database schema SELECT Syntax - ️️Command to list the content SELECT columnlist FROM tablename; 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 w...

INSY 3304 EXAM 2 LATEST UPDATED ...

INSY 3304 EXAM 1 REVIEW ...

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

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