ISTM 210 Exam 3 Test Questions And Answers Verified 100% Correct

ISTM 210 Exam 3 Test Questions And Answers Verified 100% Correct Well designed data base Advantages - ANSWER --less costly -easy to use -helps ensure data integrity (consistent & accurate) -avoid data redundancy Normalization - ANSWER -process of organizing tables and relationships in a database objectives: -ensure each table has data about specific things -reduce duplicated or redundant info. Table Relationships - ANSWER -1:1 1:M M:M 1:1 - ANSWER -record from a table is associated only with one other record from diff. table. Ex. Employee-Co. Car; Manager-Laptop 1:M - ANSWER -Most common. Single record from table can be associated with more than 1 record from the other table. Ex. Customer-Sales order; Vendor Inventory M:M - ANSWER -Record from 1st table can be associated w/multiple records from the 2nd and vice versa. Requires a linking table. (3 total) Ex. Vendor Inventory; Single product can be bought from more than 1 place/vendor Entity - ANSWER -anything you want to store data about. Each one gets its own table Attribute - ANSWER -what info you want to know about entity. Stored in fields Database Management Systems (DBMS) - ANSWER -software system used to create databases. Similar to filing cabinets bc organize info based on set of rules. Entity Relationship Modeling (ERM) - ANSWER -method used to construct a theoretical and conceptual representation of data to produce a schema. Database Schema - ANSWER -map of tables and their relationships Secure info on a Database - ANSWER -giving certain end users access to data and others limited access Relational Database Model - ANSWER -proposed by Edgar F. Codd in 1970 Structured Query Language (SQL) - ANSWER -Most widely used standard language for relational databases. Allows programmer to manipulate and query data SQL Statement - ANSWER -Select-Field From-Table Where- Order-Field Other: Append, Delete, Update Oracle - ANSWER -most widely used database Update Anomaly - ANSWER -data shown multiple times and may not be updated consistently Insert Anomaly - ANSWER -put partial data in table that is incomplete Delete Anomaly - ANSWER -deleting info that deletes entire records Referential Integrity - ANSWER -ensures there won't be an update anomaly problem w/ foreign key Append - ANSWER -take data and put it at the end Query design approach uses - ANSWER -QBE environment (query by example) QBE Environment - ANSWER -provides graphical way to drag and drop elements of a query until it's exactly how you want it. Multi-level sorting - ANSWER -sorts fields in order they were entered, then by ascending or descending each one. Unique values property - ANSWER -change if you want to see duplicated records or not And - ANSWER -meets more than one criteria Or - ANSWER -meet only one set of criteria NOT - ANSWER -returns records for a query that don't match the defined criteria NULL - ANSWER -Returns records w/empty values Like - ANSWER -search within a field to find a specific value * - ANSWER -wild card character, used to sub for any number of characters. -Beginning: Like "stove*" -End: Like "*stove" G - ANSWER -iDrives. Problem then: internet too slow to store and back up data and info Cloud Service Providers (CSP) examples - ANSWER --Google -Microsoft -Dropbox Cloud advantages - ANSWER --automatic back up -access from any internet enabled computer