CIS 2010 Study Guide - Final Guide: Database, Query Language, Data Element
Document Summary
Module 8a (also referred to as a table) stores information about a person, place, thing, transaction, or event. Stored into a different two-dimensional table (with rows and columns) Attributes (also called columns or fields) are the data elements associated with an entity. Records: a collection of related data elements. Each record in an entity occupies one row in its respective table. Database management system (dbms: creates, reads, updates, and deletes data in a database while controlling access and security, managers send requests to the dbms, and the dbms performs the actual manipulation of the data in the database. Query-by-example (qbe: helps users graphically design the answer to a question against a database. Structured query language (sql: that asks users to write lines of code to answer questions against a database, managers interact w/ qbe tools and mis professionals have skills required to code sql. Identify advantages and features of relational databases.