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

von
Drucken
Einbetten

Bestenliste

Visueller Stil

Einstellungen

Vorlage ändern

Soll die automatisch gespeicherte Aktivität wiederhergestellt werden?