3.7 Relational Databases Flashcards
What is a database
A persistent collection of organized data
What is a database entity
A object person or thing of interest about which data can be collected
What is a field
One item of data which is represented by a single column in a table
What is a record
An individual collection of data for one person/object which is represented as a row in a table
What is a table
A container used to store related data in an organized manner which consists of recordfs and fields
What are the data types used in databases
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
What is a flat file database
A single table stored inside a text file
What is a primary key
A field used to uniquely identify different records
What is a foreign key?
A reference to a primary key from another table
What is a database query
A search performed within a database