CHAPTER 11 TERMS:
• Database: A collection of data organized in a manner that allows access, retrieval, and
use of that data.
• Database Software: (Database management system DBMS) Allows users to create a
computerized database; add, modify, and delete data, sort and retrieve data; create
forms and reports from the data.
• Data is Organized in Levels: Characters, fields records, and files.
• Character: Is one byte. Numbers, letters, space, punctuation marks, or other symbols.
• Field: A combination of one or more related characters. Field name, data type, field size.
• Record: A group of related fields.
• Primary Key: A field that uniquely identifies each record.
• Data File: A collection of related records.
• File Maintenance: Refers to the procedures that keep data current (Adding records,
modifying records, deleting records).
• Validation: Compares data with a set of rules or values to find out if the data meets
• File Processing: Each department has its own set of files. Redundant data. Isolated data.
• Data Model: Defines how users view the organization of the data.
• 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.
• Form: A window on the screen that provides areas for entering or modifying data in a
• Report Writer: Allows users to design a report on the screen, retrieve data into the
report design, and then display or print the report.
• Least Privilege Policy: Requires that in a particular abstraction layer of a computing
environment, every module (such as a process, a user, or a program, depending on the
subject) must be able to access only the information and resources that are necessary
for its legitimate purpose.
• Continuous Backup:
• Information System: A collection of hardware, software, data, people and procedures
that work together to produce information. • System Development: A set of activities used to build an information system.
• System Development Life Cycle: (SDLC) When system development activities are
grouped into phases.
• System Development Phases: 1.) Planning. 2.) Analysis. 3.) Design. 4.) Implementation.
5.) Support and Security.
• Guidelines of System Development: Group activ