databases Flashcards
(11 cards)
1
Q
what do data bases do
A
data bases allow users to store, organise and search data as well as outputting it in eitther a printed or electronic format
2
Q
give 3 examples of a data base
A
netflix amazon playstation
3
Q
what is a boolean system
A
based on thinks that can only be true or false
4
Q
what does alphanumeric or text data type do
A
stores letters, numbers and special character such as punctuation
5
Q
what does date data type do
A
stores dates using day month and year
6
Q
what does currency data type do
A
stores monetary values
7
Q
what is a report
A
a user friendly layout for query results
8
Q
what is a form
A
a user friendly layout that displays fields for data entry
9
Q
what is a foriegn key
A
a primary key from another table
10
Q
what is a primary key
A
which attributes identify a record
11
Q
A
