CGS-2060 Lecture 7: CGS 7
Document Summary
Database software/database management system (dbms) allows users to create a computerized database. Field a combination of one or more related characters. Primary key a field that uniquely identifies each record. File maintenance the procedure that keeps data current. Validation compares data with a set of rules or values to find out if the data is correct. File processing system each department has its own set of files, has data redundancy. Database approach programs and users share data, reduced data redundancy. Data dictionary 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.