3.7 Relational Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What is a database

A

A persistent collection of organized data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is a database entity

A

A object person or thing of interest about which data can be collected

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a field

A

One item of data which is represented by a single column in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is a record

A

An individual collection of data for one person/object which is represented as a row in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a table

A

A container used to store related data in an organized manner which consists of recordfs and fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the data types used in databases

A

Integer (whole number)

Real, Float, Decimal (number with a decimal component)

Date, Time, Datetime (to store dates and times)

Char (fixed length string up to 8,000 characters)

Varchar (variable length string up to 8,000 characters)

Text (variable length string up to 2 GB of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is a flat file database

A

A single table stored inside a text file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a primary key

A

A field used to uniquely identify different records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is a foreign key?

A

A reference to a primary key from another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What is a database query

A

A search performed within a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly