quiz10review207

A _____ are the individual categories of information stored in a record

Fields

What are the three types of databases

Flat-file, Relational, XML or Object

To allow easy access to data in various database formats, Microsoft established the ____ ___ _____ standard

Open database connectivity standard (ODBC)

___ Databases store information across multiple related tables, they are best used for large and complex collections of information

Relational database

Databases are ____ ____

Structured Data

One of more applications used to access and manage a database is called a ____

database management system

Each column n a database table is called a ____

field

A ____ databasse stores information in a single table, and it is usually adequate for simple collections of information

flat-flie databases

A ___ ___ is a field or fields in a related table that refer to the primary key in a primary table

foreign key

A primary key is a type of ____, which identifies records in a database to make retrievals and sorting fast

index

A ____ ___ creates a one-to-many relationship for each of the tables in a many-to-many relationship

junction table

Breaking tables into multiple related tables to reduce redundant and duplicate information is called _____

normalization

What are the three basic types of relationships within a relational database

one-to-one, one-to-many, and many-to-many

Tables in a relationship are connected using ___ and ____ keys

primary and foreign keys

A _____ ___ is a field or fields that contain a unqiue identifier for each record in a primary table

primary key

A _____ table (aka parent table) is the main table in a relationship that is referenced by another table

primary table

A ___ is a structure set of instructions and criteria for retrieving, adding, modifying, and deleting database information

query

A ____ in a database is a single, complete set of related information

record

Each row in a database table is called a ___

record

A ____ table (aka child table) references a primary table in a relational database

related table

A DBMS is used to define a databases ____, which is the structure of the database

schema