Insy 3304 - Study guides, Class notes & Summaries

UTA INSY 3304 - CHAPTER 10 QUESTIONS

INSY 3304 Quiz 1 QUESTIONS AND ANSWERS 100% CORRECT INSY 3304 Quiz 1 QUESTIONS AND ANSWERS 100% CORRECT Data - ANSWER-Raw facts, or facts that have not yet been processed to reveal their meaning to the end user. Field - ANSWER-a character or group of characters(alphabetic or numeric) that has a specific meaning. A field is used to define and store data. Record - ANSWER-A logically connected set of one or more fields that describes a person, place ,or thing. File - ANSWER-A col...

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

INSY 3304 EXAM 1 REVIEW QUESTIONS & 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 QUESTIONS AND ANSWERS

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 EXAM 2 LATEST UPDATED ...