Database Test 1 - Chapters 1, 2, 3 Flashcards
A document for gathering data input
Form
This key is the primary key repeated in another table to create a link between the tables.
Foreign Key
A document including the scope, objectives, and timeline for a given project.
Statement of Work
A key based on one or more “natural” attributes of an entity
Natural key
This key uniquely identifies each row in the table.
Primary Key
The official steps and rules for completing some process
Procedure
Refers to the accuracy and the correctness of the data in the database.
Data Integrity
Refers to storing the same data in more than one place in the database.
Redundancy
These files have some sort of character separating columns of data
Delimited Files
A type of database that uses “relations,” tables, to store and relate tables.
Relational Database
Something that the database is concerned with, about which data can be stored.
Entity
The process of organizing data into tables or entities and then determining the relations
among them.
Relational Design
The process of organizing data into tables or entities and then determining the relations
among them.
SQL
Limits on what the database will do.
Constraints
Files where the length in characters of each column is the same.
Fixed Width Files
A short statement of one or more paragraphs that says in clear, but general, terms what the project will do.
Statement of Scope
A multiple-choice question
Closed-ended question
The purpose or subject of a database
Domain
A set of tools for analyzing business trends
Business intelligence
Things that define aspects of entities.
Attribute
A database optimized for storing and processing real-time transactions
Transaction Database
A question that has no set answer
Open-ended question
Combining data in a variety of formats for trends and patterns
Data mining
A document for displaying summarized data
Report
An alternate way of doing a process
Exception
Marked up Unicode text that follows a set of a few strict rules
XML
A database optimized for queries that summarize transaction data
Management information system
Something the database needs to do to be successful
Requirement
A collection of all the various types of business information including databases and documents
Data Warehouse
Anyone who has a stake in the process
Stakeholder
Observing workers handling data on the job
Work shadowing
The permissions a user has to use or view database objects and data
User access
A program that offers a service to requesting programs
Server
An artificial key, often just an incremented number
Surrogate key
A person or program that makes some use of the database
Actor
A program that requests a service
Client
A program in SQL that is triggered by a database event
Trigger
A key that consists of more than one attribute
Composite key
A rule about how data are acquired, stored, or processed
Business rule
The general problem area with which a database is concerned
Problem domain
Something a database must do to meet a business need
Requirement
