CGS-2060 Study Guide - Quiz Guide: Document Management System, Transaction Processing System, Expert System
Document Summary
Programs and users share data, reduced data redundancy. Quiz 5 contains data about each file in the database and each field in those files. Query language consists of simple, english-like statements that allow users to specify the data to display, print, store, update, or delete. Structured query language (sql) a popular query language that allows users to manage, update, and retrieve data. Query by example (qbe) a feature that has a graphical user interface to assist users with retrieving data. A window on the screen that provides areas for entering or modifying data in a database. Allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. Defines how users view the organization of the data. Relational database stores data in tables that consists of rows and columns - each row has a primary key, each column has a unique name.