Introduction to Databases
A collection of organized information stored electronically.
Database
The first step when designing a database is identifying this.
the purpose of the database
Forms are used to make this easier.
entering data
Arranging data alphabetically is called this.
sorting
A field that uniquely identifies each record.
primary key
The software used to create and manage databases.
Database Management System ( DBMS)
A table is made up of rows and this.
columns
A form displays one record at a time (True/False)
True
Sorting A–Z is known as this type of order.
Ascending
A primary key must be this for every record.
unique
An example of a database you use every day (e.g., student records, contacts).
Any example of a database eg school database, phone contacts
Choosing appropriate names for fields helps improve this.
organization or clarity
Forms help reduce this when entering data.
errors
Sorting Z–A is known as this.
descending
A primary key cannot contain this.
duplicates or null values
The rows in a database table are called.....
records
A field that stores numbers, text, or dates is defined by this.
data type
A feature that restricts what users can enter in a field.
validation
Sorting helps users find this more easily.
information/data
An example of a good primary key in a student table.
student ID
The columns in a database table are called.....
fields
Breaking data into multiple related tables avoids this problem.
data redundancy
Forms are linked to this part of the database.
tables
Sorting by more than one field is called this.
multi-level sorting
Primary keys help link tables together using this.
relationships (or foreign keys)