Database Terminology

Database Terminology

8th Grade Computer applications​

Multiple Choice

A collection of named tables, views, and the way the data is accessed is known as a

• database

• field

• record

• field name

Multiple Choice

A name of a column in a table

• database

• field

• record

• field name

Multiple Choice

The column (2) in a table is known as an attribute or a _________.

• database

• field

• record

• field name

Multiple Choice

A row is made up of fields and contains full details of one particular item and is called a _______.

• database

• record

• field

• field name

How are records tracked?

The PRIMARY KEY

Each record in a table has a primary key or a field that uniquely identifies a given record in a table. This number is never repeated and is unique to that individual record. The primary key helps each record RELATE to other records in other tables.

Vocabulary Word: Primary Key

Fill in the Blanks

Multiple Choice

A primary key's number is never repeated in that table.

• True

• False

​The skeleton structure that shows the view of a database with each table having a title is a

database schema.​

​

​Schema

​A search in a database is a query.

​

When you type a search into Google, programmers call this a query.​

​

Query

The most commonly used database query language

SQL

"sequel"​

Multiple Choice

The database ______ is the skeleton structure that shows the view of the database. Each table has a title.

• primary key

• schema

• query

• SQL

Multiple Choice

When someone types a search into Google, programmers call this a _____.

• schema

• query

• SQL

• primary key

Multiple Choice

The most commonly used database query language is ______.

• Python

• SWL

• SQL

• Oracle Database

Multiple Choice

Each record in a database has a unique _____ ______.

• field name

• relational database

• SQL query

• primary key

A simple form of data manipulation between a table of data and another document (paper letters, email, or HTML) is a merge.

​

Vocabulary: Merge

Merge

​

Another way to view data is a view.

View

Forms are used to enter data into a data table. (We have been using Google forms to create our data tables.)

Forms

Multiple Choice

Another way to view data is a ______.

• view

• form

• query

• SQL

Multiple Choice

An example of a form that we use to enter data into a data table in this class is a

• Google Form

• SQL

• query

• Oracle Database server