Database and design development Flashcards
1
Q
it consists of one table
A
Flat file database
2
Q
Stores words, numbers and other characters such as punctuation marks.
A
Text Field
3
Q
It is a field used to uniquely identify every record in the database.
A
Primary Key
4
Q
Stores both whole numbers and decimal numbers
A
Number Field
5
Q
Flat data base three specific problem
A
- Insert anomaly
- Delete anomaly
- Update anomaly
6
Q
Dates can be stored using the date field type
A
Date Field
7
Q
It is a primary key from one table that appears in another table to link the two together.
A
Foreign Key
8
Q
It stores either true or false, often showing on screen as Yes or No
A
Boolean Field
9
Q
What is an “End-User” ?
A
what it needs to be like for the users
