Databases - Lesson 1

Database

an structured set of data.

What are three advantages of databases?

• Keep things organized

• stores information

• saves time

Field

one piece of information about someone or something.

Examples of fields

• Surname

• Forename

• DOB (date of birth)

• Address

• Postcode

• Email

• Telephone number

Record

all the information about someone or something

Primary key

to identify a record in a database.

Examples of primary key

• CAR registration number

• STUDENT ID

• CUSTOMER Number

• BOOK ISBN
  

What kind of field would the school hold on to you ?

• Name

• Surname

• DOB
  Address

• Postcode

• Email

• Telephone number

What are the two types of databases ?

Flat file databases and Relational database

Flat file database

one big table

Relational database

many tables linked together

What is an example of a database ?

Microsoft teams

Would a primary key be useful for a database table ?

Yes

Foreign key

a primary key that’s in another table. It identifies a record from another table

What are the advantages of a foreign key ?

• data isn’t entered in twice or more in the database

• this reduces the data stored, which makes the database smaller

• Reduces mistakes as information doesn’t need to be tpyed again