Databases Key Words

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

fields

A field is the basic unit of data entry in a record. To define a new field, you give it a name. Then you select options that determine how the fields interprets, enters, calculates, stores, and displays data

Primary key

A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number (including area code), or vehicle identification number (VIN). A relational database must always have one and only one primary key.

mask

In computer programming, an input mask refers to a string expression, defined by a developer, that governs what a user is allowed to enter in as input in a text box.

table

In relational databases and flat file databases, a table is a set of data elements (values) using a model of vertical columns (which are identified by their name) and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows.

record

In the context of a relational database, a row—also called a record or tuple —represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields.

foreign key

In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.

relationships

The primary keys within a database are used to define the relationships among the tables. When a PK migrates to another table, it becomes a foreign key in the other table.

integer

a number which is not a fraction; a whole number. "integer values"

Boolean

denoting a system of algebraic notation used to represent logical propositions by means of the binary digits 0 (false) and 1 (true), especially in computing and electronics.

format

the way in which something is arranged or set out


Set pelajaran terkait

24. Probability of committing type I error and how to avoid it...

View Set

AP Bio Cellular respiration and Photosynthesis PT.2

View Set

Unit 12 Basic Electricity and Magnetism

View Set

Introduction to Behavioral Health Nursing

View Set

English 4 Sound and Structure in Poems by Dylan Thomas and W. B. Yeats

View Set

Heart failure - medical management

View Set

Ch3 Attitudes and job Satisfaction

View Set

Trial: Evidence & Burden of Proof

View Set