Test Flashcards
Advantages of a computerised database over a paper based database?
Easier to search and find what you’re looking for
Can’t lose it as you can make a back-up
Can make changes to it very easily
What are ‘Name, Address, Phone number, Card details’ an example of?
FIELDs
What are FIELDS?
One piece of information about the customer
What is a record?
All the information (fields) that is about ONE CUSTOMER
How many characters can you have in a short text?
You have a limit of 255 characters
How many characters can you have in a long text?
More than 255 characters
What is a query?
A Query is a way of asking a question, in order to find information from a Database.
What is a flat file?
A flat file consists of a single table of data