Call Us: 0800 357 9129 West Sussex, United Kingdom

Homework - Arrays

What is the difference between a flat file & relational database?

 

 

Key Words

Key words:  Flat file, record, field, query, primary key, foreign key, atomic data – make flash cards for these

Explain the benefit of using a primary key.

 

 

Break the following data into atomic data:

Mr Eric Wimp, 29 Acacia Road Nuttytown

 

 

.

Match the term to the definition:

SQL                              This is column of the table, or individuak cell of the row.
Query By Design
    

This query is built by typing in the code that identifies the tables, fields, and criteria.

Field    

This is a whole row within a table.

Record    The query is build using a table where fields, and criteria are selected.

.

What does the following acronym stand for?

C

R

U

D

Give an example of a DBMS and how it helps the user:

 

 

 

 

 

 

Complete & explain your answer to the following exam question:

GCSE database example question

Resize Text
High Contrast