ISTM 210 Phinney, Ch 15-17, Exam 3 TAMU with Certified Solutions

ISTM 210 Phinney, Ch 15-17, Exam 3 TAMU with Certified Solutions entity anything about which an organization wants to collect and store information students are entities table Where a database holds data records & fields rows & columns queries What produces subsets of information? DBSM Database Management System. A software system that stores data in files called tables and tables are connected to other tables with related information. relational database A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables reports display database information on screen or on paper query files used to find specific populations (subsets) of information forms overlay data tables and queries for more specific views of data entity relationship (ER) diagram Used by database designers to construct databases. A data model that uses basic graphical symbols to show the organization of and relationships between data. entity relationship modeling (ERM) is a database-modeling method used to construct a theoretical and conceptual representation of data to produce a schema schema is a "map" of database tables and their relationship to each another attributes a name of a field a relationship "On to Many" is an example of? cardinality a "One to Many" relationship is a type of? data validation rules A set of rules that determine what users can enter in a specific cell or range data redundancyDatabase Management Systems help avoid what? data redundancy Structured Query Language (SQL) asks users to write lines of code to answer questions against a database SQL statements SELECT, FROM, WHERE, ORDER, APPEND, UPDATE, DELETE REO Real Estate Owned field mask restricts data input filtering the ability to add a filter to a data table that would display specific information data validation Insuring a field is populated with usable data iDrives Companies like GoD have offered off-site