Databases Flashcards
A database
Gives structure to data so it can be processed to give us information
What’s a primary key
Uniquely identifies a record
Data types
Help ensure data entered is vailed
Examples of data types
Text
Number
Date/time
Currency
Boolean
Yes/no
Flat file database
Has only one table containing all the data
Relational database
Has more than one table + has relationships between the data
Why is a relational database better than a flat file database
It avoids all the problems associated with flatfile databases such as data duplication, data redundancy and data inconsistency
What are queries
Used to preform searches
What are forms
Make it easier for users to enter data
What are reports designed for
Printing
What software do we use to create a database in school?
Microsoft access
