Databases make data - easy to store, organise and search, Data is organised into a - a table structure, A table consists of - records, A field is part of - a record, A field stores - a single data item, A primary key field - uniquely identifies one record, Linking tables together in a database - creates a relationship, To create a database relationship, there must be - a common field between tables, Relationships can be classified as - ONE to ONE, ONE to MANY or MANY to MANY, Primary key appears in another table it is know as - a foreign key, Data duplication - occurs when the same data is entered more than once, Data redundancy - occurs when there is unnecessary duplication of data in a database, Referential integrity - ensures that records linked to another table cannot be deleted, Data type - is a description of the kind of data held in a field, Field properties/attributes - further define a field in a record, exporting data - is sending data out of an application to another, importing data - is bringing data from one application into another, Data integrity - ensures the accuracy and consistency of data, Captions - allow proper English to be used in user interfaces,

Database fundamentals

Εκτύπωση
Ενσωμάτωση

Κατάταξη

Οπτικό στυλ

Επιλογές

Αλλαγή προτύπου

Επαναφορά αυτόματα αποθηκευμένου: ;