Database #2

Front

What is a flat file database?

Back

A flat file database organizes data into a single table and is suitable for many small applications.

Front

What are the data structures used in flat file databases?

Back

Files, records, fields, and characters.

Front

Define a file in the context of databases.

Back

A file is a block of data stored on a computer, divided into a set of related records.

Front

What is a record in a database?

Back

A record is a collection of facts about one specific entry in a database, divided into related fields.

Front

What is a field in a database?

Back

A field is a specific category of data in a database, made up of characters.

Front

What is a character in a database?

Back

A character is the smallest unit of data, including letters, numbers, and special symbols.

Front

What is a relational database?

Back

A relational database organizes data using a series of related tables with relationships between them.

Front

What is a schema in a relational database?

Back

A schema is the data definition for a database, showing how and where data is found and its logical relationships.

Front

Define an entity in a database schema.

Back

An entity is a specific thing about which information is collected and stored.

Front

What is an attribute in a database schema?

Back

An attribute is a defined property of an entity, similar to fields in a flat file database.